O'Reilly logo

Oracle Data Guard 11gR2 Administration Beginner's Guide by Nassyam Basha, Emre Baransel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Time for action – the recommended configuration for archived log maintenance on a standby database

Let's see an example of configuring automatic maintenance of the archived logs on a standby database:

  1. Enable the fast recovery area on the standby database by setting the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters:
    SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='/data/FRA';
    SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=500G;

    If we're using ASM, we can specify a disk group as DB_RECOVERY_FILE_DEST.

    SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+FRA';
  2. Set the LOG_ARCHIVE_DEST_1 parameter as follows so that the archived logfiles will be created at the DB_RECOVERY_FILE_DEST parameter:
    SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_ ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required