Let's see an example of configuring automatic maintenance of the archived logs on a standby database:
Enable the fast recovery area on the standby database by setting the
DB_RECOVERY_FILE_DESTandDB_RECOVERY_FILE_DEST_SIZEparameters: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';
Set the
LOG_ARCHIVE_DEST_1parameter as follows so that the archived logfiles will be created at theDB_RECOVERY_FILE_DESTparameter:SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_ FILE_DEST';
Set the
RMANarchived 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 onDB_RECOVERY_FILE_DEST_SIZE...