DGMGRL – Active Data Guard – enabling and using

on September 9, 2009 at 1:30 pm
Posted In: Oracle Data Guard Notes (Cat)

Seperately licensed for 11g which

  • includes the real-time query facility.
  • enables you to configure RMAN block change tracking for a physical standby database

ENABLING
========
DGMGRL> EDIT DATABASE ‘pc00sby1′ SET STATE=’apply-off’;
SQL> ALTER DATABASE OPEN;
DGMGRL> EDIT DATABASE ‘pc00sby1′ SET STATE=’apply-on’;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;

 

BLOCK CHANGE TRACKING
=====================
SQL> ALTER DATABASE ENABLE | DISABLE BLOCK CHANGE TRACKING {USING FILE ‘…’};

SQL> SELECT FILENAME, STATUS, BYTES FROM V$BLOCK_CHANGE_TRACKING;

SQL> SELECT * FROM V$BACKUP_DATAFILE;

Â