The Power of 11g Snapshot Standby Database for Oracle 10g!!

Page: 1 2

Almost every database administrator has come across the Physical standby database and Logical standby database. Oracle 11g onwards as added more to it by providing us with Snapshot standby database. In Snapshot Standby Database a physical standby database can easily open in read-write mode and again you can convert it back to the physical standby database. This is suitable for test and development environments and also maintains protection by continuing to receive data from the production database and archiving it for later use.

In this article I will discuss some great tips that will help you simulate Oracle 11g Snapshot Standby Database feature on Oracle 10g. This will give you the power to open an Oracle 10g standby database in read write mode and revert it back to standby mode.

Set db_recovery parameters:

First of all you have to set db_recovery_file_dest_size and db_recovery_file_dest parameters on the standby database. Make sure the values are reflected.

Stop Media Recovery:

If media recovery process is active then you must stop it.

Create Restore Point:

In this step a guaranteed restore point after the standby is in MOUNT mode.

CREATE restore point before_rw guarantee flashback database;

Stop Log Shipping:

Now for the safer side you must stop the log shipping on the primary database. This can be done by running below command.

alter system archive log current;

alter system set log_archive_dest_state_2=DEFER;

Failover the standby database:

Now you have to failover the standby database by using below command. Make sure the media recovery process is turned off and minimize the protection mode to MAXIMUM PERFORMANCE, if it is set other than the MAXIMUM PERFORMANCE.

ALTER DATABASE ACTIVATE STANDBY DATABASE; Continued...

Page: 1 2