11g Snapshot Database

A new feature called the Snapshot DATABASE in 11g reduces the amount of manual steps in previous versions to accomplish the same tasks.   See other posts about DATAGUARD and FLASHBACK.  This allows you to use a physical standby for all sorts of tasks besides just disaster recovery. 

The following steps are done on the physical standby.  Redo data is still being shipped from the primary. 

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=50G;

System altered.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’/backup/flash_recovery_area/RGCP/’;
System altered.
SQL> alter database flashback on;
Database altered.
SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;
Database altered.
At this point several tasks are run on the open for read/write database.  When finished I turn it back into a standby by…

 

SQL> shutdown immediate;

ORA-01507: database not mounted

 

ORACLE instance shut down.

SQL> startup mount ;

Database altered.

SQL>

SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Database altered.

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

 

 

 

 

 

 

 

 

 

 

 

Advertisements

About April C Sims

Oracle DBA for over a decade...enough said.
This entry was posted in 11g, DATA GUARD, FLASHBACK, Physical Standby, Recovery and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s