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

MOSC Banner

Database Role during Data guard switch over / switch back

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

Hi

we have a 19c database and configuring data guard

While adding the database to the cluster, we used the srvctl add database -role option and specified PHYSICAL_STANDBY

Now our question is that when and if we do the switch over or fail over to the standby and then switch back / fail back to primary, would oracle handle that (database role settings) automatically?

Like when we switch over to the standby, the standby database role would be PHYSICAL_STANDBY so when we do the switch over, would oracle internally change the database role of standby to PRIMARY and the role of the primary database to PHYSCIAL_STANDBY and vice versa?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center