![]() ![]() Therefore, now a days its more commonly known as fast recovery area. But after that Oracle decided to change it from ‘flash’ to ‘fast recovery area’. )Īctually, until Oracle 11gR1 Oracle FRA was known as Flash recovery area. (I won’t blame them because sometimes I too use these terms interchangeably. Some books refer to Oracle FRA as fast recovery area whereas some refer to it as flash recovery area which creates confusion. What does FRA stands for? Is it Fast recovery area or is it Flash recovery area? Fast Recovery Area or Flash Recovery Area?īefore I tell you what Oracle FRA is let me first clear the confusion about its name. These two parameters can be dynamically altered or disabled.How to configure Oracle Fast Recovery Area by Manish Sharma(YouTube Video) Suggested Readingīefore you start learning about FRA I would suggest you to check out the previous blog which is a quick introduction to Oracle RMAN. The recovery area is defined by setting two initialization parameters. Specifying this parameter without also specifying the db_recovery_file_dest_size initialization parameter is not allowed. If you just specify the db_recovery_file_dest parameter, Oracle will create an OMF-based control file in the flash recovery area only.If you specify the db_create_file_dest and db_recovery_file_dest parameters, Oracle will create an OMF based control file in both of these locations.If you specify the db_create_online_log_dest_n parameter, Oracle will create an OMF-based control file in n number of locations, with the first directory holding the primary control file.If you haven’t set the control_files parameter, Oracle will create the control files in various default locations, according to the following rules: When you use the db_recovery_file_dest parameter to specify the destination of your flash recovery area, you can use a directory, file system, or ASM disk group as your destination.ĭynamically Defining the Flash Recovery AreaĪLTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 2G SCOPE=BOTHĪLTER SYSTEM SET DB_RECOVERY_FILE_DEST = ‘C:\ORACLE\RECOVERY_AREA’ SCOPE=BOTH The recovery area contains multiplexed copies of the following files: ![]() Question: What does the db_recovery_file_dest parameter do?Īnswer: The db_recovery_file_dest parameter defines the location of the Flash Recovery Area (FRA) and the db_recovery_file_dest parameter specifies the default location for the recovery area. The following scripts will check space utilization for db_recovery_file_dest_size:Ĭeil( space_limit / 1024 / 1024) size_mb,Ĭeil ( ( space_used / space_limit) * 100) ) pct_used ![]() See these notes on using the RMAN crosscheck command. #Alter system db recovery file dest size update#The trick to increasing the limit for db_recovery_file_dest_size was to:ġ - Start the database, then mount the database (Do not open the database)Ģ - Use RMAN to run a crosscheck on the archive logs and then update the RMAN catalog to delete the expired redo logs that I had manually deleted via the OS to free-up space in the disk filesystem directory. In UNIX/Linux /u01/app/oracle/flash_recovery_area.In Windows: c:\oracle\app\oracle\flash_recovery_area\.The db_recovery_file_dest is located instance-wide, you it is not specified for a specific instance: The storage in db_recovery_file_dest is disk, not RAM. ![]() Monitoring Fast Recovery Area Space UsageĪnswer: The ORA-19809 error involves adjusting a parameter and bouncing your instance. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |