Thursday, August 27, 2009

Active standby database test

SQL> alter database open;

Database altered.

SQL> recover managed standby database disconnect;
Media recovery complete.
SQL> connect oradba/oradba
Connected.
SQL> select * from ACTIVE_STANDBY_TEST;

ID
----------
1

# run an insert on PROD then switch logs, and recovery applies the transaction on the active standby

SQL> select * from ACTIVE_STANDBY_TEST;

ID
----------
1
2