Q&As: Fast Recovery Area (I)



(Q) What is a Fast Recovery Area? What does it contain?

  • Is an Oracle managed space that can be used to hold RMAN disk backups, control file autobackups, and archived redo logs
  • Files here are maintained by Oracle and have an OMF format
  • Disk location in which the database can store and manage files related to backup and recovery. It contains:
  • (a) multiplexed copies of current control file and online redo logs, (b) archived redo logs (c) Foreign archived redo logs (d) flashback logs (e) image copies of datafiles and control files (f) backup pieces


(Q) What does Oracle recommends about the location of the Fast Recovery Area?

  • Should be on a separate disk from the database area (database files, control file, redo logs)
  • DB_RECOVERY_FILE_DEST should be different than DB_CREATE_FILE_DEST or any DB_CREATE_ONLINE_LOG_DEST_n



(Q) How can you find out the size of the Fast Recovery Area?

SQL> show parameter db_recovery

NAME        TYPE  VALUE
---------------------------- ----------- ------------------------------
db_recovery_file_dest      string  /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size   big integer 4977M


(Q) What is the default size of an online log created in the Fast Recovery Area?

  • 100 Mb


(Q) Which statements about Fast Recovery Area are correct?

  • ( ) Fast Recovery Area automates management of backup-related files.
  • ( ) It minimizes the need to manually manage disk space for backup-related files
  • ( ) It balances the use of space among the different types of files
  • ( ) When you create a Fast recovery area:
  • (a) you choose a location on disk and set an upper bound for storage space. (b) you set a backup retention policy
  • ( ) RMAN retains the data file backups required to satisfy the current retention policy AND any arquived redo logs required for complete recovery of those data file backups

No comments:

Post a Comment