Snapshot Standby Easier than manual steps in 10.2

inewup-standby-database

10.2

Standby

> alter database recover managed standby database cancel;

> create restore point before_lt guarantee flashback database;

Primary

> alter system archive log current;

> alter system set log_archive_dest_state_2=defer;

Standby

> alter database activate standby database;

> startup mount force;

> alter database set standby database to maximize performance;

> alter system set log_archive_dest_state_2=defer;

> alter database open;

PERFORM TESTING, ARCHIVE LOGS NOT SHIPPED

> startup mount force;

> flashback database to restore point before_lt;

> alter database convert to physical standby;

> startup mount force;

> alter database recover managed standby database disconnect from session;

Primary

> Alter system set log_archive_dest_state_2=enable

11

Standby

> alter database convert to snapshot standby;

PERFORM TESTING, ARCHIVE LOGS CONTINUE TO BE SHIPPED

> alter database convert to physical standby;