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_ FILE_DEST';

3. Set the RMAN archived log deletion policy as follows. With this setting, the applied archived logs will be automatically deleted when there is a space constraint in FRA, depending on DB_RECOVERY_FILE_DEST_SIZE...