High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Converting physical standby to READ /WRITE without using Snapshot Standby

Hello Everyone

We have 2 11g databases configured in a primary and physical standby

Primary database is prod and Physical standby is stdby

There is this requirement where we need to convert the current physical standby database into a READ / WRITE for good

We dont want this to impact the production database at all

So basically what we want is to convert the standby database into READ WRITE database WITHOUT impacting the primary database

For the sake of argument, we cannot use the SNAPSHOT STANDBY option.

We plan to use the standby database in a READ / WRITE environment for at least a few months and then down the road

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center