Last modified on 5 April 2013, at 05:56

RAC Attack - Oracle Cluster Database at Home/Block Change Tracking

Prev: RAC SQL and PLSQL



RAC Backups and Recovery (e)
  1. Setup Backups
  2. Flashback Database
  3. Block Change Tracking
  4. Archived Logs
  5. Database Backups
  6. Database Recovery


Next: Home



  1. Enable block change tracking on the database and explicitly choose the local FRA destination. (Typically the block change tracking file is created in the OMF DB destination rather than the FRA.)

    SQL> alter database enable block change tracking
     2   using file '/u01/app/oradata/changetracking.ctf';
    

    What happens? Make sure to check the alert logs. Try it with only one instance open, and then open the other instance to see what happens.


  2. Disable block change tracking.

    SQL> alter database disable block change tracking;
     
    SQL> col filename format a40
    SQL> select * from v$block_change_tracking;
     
    STATUS     FILENAME                                      BYTES
    ---------- ---------------------------------------- ----------
    DISABLED