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 – 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 ...

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