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!

Dataguard (activate physical standby database as a standalone database)?

toonieAug 27 2015 — edited Aug 27 2015

Hi all,

Can I please ask for opinions on how one would activate a physical standby database for 11.2.0.4?

Note - I will not want to revert the "standby" to a standby again...

Note1 - I do not (and cannot leverage flashback technology to do this) - So I cannot use a "snapshot standby"...

Note2 - The current "primary" cannot be impacted.

Something like the below?

Stop redo apply to the standby

SQL> alter database recover managed standby database cancel;

Stop redo log shipping to the standby.

PRIMARY

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;

Activate and open the physical standby database.

PHYSICAL STANDBY side

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;

SQL> STARTUP MOUNT FORCE;

SQL> alter database set standby database to maximize performance;

SQL> ALTER DATABASE OPEN;

Regards

This post has been answered by Shivananda Rao on Aug 27 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 24 2015

Added on Aug 27 2015

#data-guard, #performance-availability

6 comments

1,604 views