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;