Snapshot databases, creating and using

on September 9, 2009 at 1:22 pm
Posted In: Oracle Data Guard Notes (Cat)
  • A snapshot standby db is a fully updateable standby database created by converting a physical standby
  • Snapshot standby databases receive and archive, but not apply, redo data from the primary.
  • When a physical standby is converted an implicit guarantee resore point is created and flashback database is enabled.

CONVERTING
==========
DGMGRL> CONVERT DATABASE pc00sby1 TO SNAPSHOT DATABASE;

WARNING
=======

  • Potential data loss when there is a corrupted log file. A corrupted log file from the primary will not be detected until the db is converted back to a standby.
  • It may take a long time to convert the snapshot db back to a standby.

CAN NOT BE
==========
The only standby db in maximum protection mode
The target of a switchover
A fast-start failover target

VIEWING INFORMATION
===================
SQL> SELECT DATABASE_ROLE FROM V$DATABASE

DGMGRL> SHOW CONFIGURATION [VERBOSE];
DGMGRL> SHOW DATABASE pc00sby1;

CONVERTING BACK
===============
DGMGRL> CONVERT DATABASE pc00sby1 TO PHYSICAL STANDBY;