Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 12c Data Guard standby-snapshot standby-standby conversion

user2522172Jul 14 2017 — edited Jul 21 2017

Hi,

I've a Oracle 12c primary database with a physical standby database. Via OMS i can convert the standby database to snapshot standby and back to physical standby again. But now I need to script this.

I've been looking in the alert-log file and DG log-file but I'm not sure what command's OMS does behind the screen. I believe it does:

alter database convert to snapshot standby;

and

alter database convert to physical standby;

Is this enough? Or can it also be done via dgmgrl with a:

CONVERT DATABASE <db-name> TO SNAPSHOT STANDBY

and

ONVERT DATABASE <db-name> TO physical STANDBY

regards,

Ivan

This post has been answered by mseberg on Jul 18 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2017

Added on Jul 14 2017

#data-guard, #performance-availability

8 comments

818 views