Oracle Data Guard 11gR2 Administration : Beginner's Guide

Time for action – enabling advanced compression

Perform the following steps in order to enable advanced compression:

1. Check for the current settings of the remote destinations and options of compression as follows:

   SQL>  select parameter,value from v$option where parameter='Advanced Compression';
   PARAMETER                 VALUE
   ------------------------- -----
   Advanced Compression      TRUE
   
   SQL> select dest_id,compression,db_unique_name from v$archive_dest where dest_id=2;
      DEST_ID COMPRESSION     DB_UNIQUE_NAME
   ---------- --------------- ------------------------------
            2 DISABLE         INDIA_UN

2. Enable compression by modifying the remote destination parameter as follows:

   SQL> alter system set LOG_ARCHIVE_DEST_2='service=INDIA LGWR ASYNC COMPRESSION=ENABLE VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) ...