Time for action – enabling FRA
Perform the following steps on the primary database now. We'll be enabling FRA on the standby database later.
- Check the default FRA location as follows:
SQL> show parameter db_recovery_file_dest NAME TYPE VALUE ------------------------------------ ----------- ----------- db_recovery_file_dest string
- Configure the FRA size.
SQL> alter system set db_recovery_file_dest_size=4g; System altered.
- Configure the FRA destination.
SQL> alter system set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'; System altered.
- 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.