Time for action – enabling FRA

Perform the following steps on the primary database now. We'll be enabling FRA on the standby database later.

  1. Check the default FRA location as follows:
    SQL> show parameter db_recovery_file_dest
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- -----------
    db_recovery_file_dest                string
  2. Configure the FRA size.
    SQL> alter system set db_recovery_file_dest_size=4g;
    System altered.
  3. Configure the FRA destination.
    SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area';
    System altered.
  4. Control the FRA configuration.
    SQL> show parameter db_recovery_file_dest
    NAME                        VALUE
    ----------------------      ------------------------
    db_recovery_file_dest       /u01/app/oracle/flash_recovery_area
    db_recovery_file_dest_size ...

Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.