Fast Recovery Area

How to Resolve ORA-32005: error while parsing size specification

by Ed Chen
April 15, 2022February 6, 2023

ORA-32005 When I tried to increase the size of Fast Recovery Area (FRA) from 1TB to 1.5TB, it failed with ORA-32005. SQL> show parameter db_recovery_file_dest_size… Read More »

How to Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

by Ed Chen
April 16, 2018December 11, 2022

ORA-16018 Got an error "ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST" when I tried to set the parameter like this: SQL> alter system set… Read More »

How to Set USE_DB_RECOVERY_FILE_DEST

by Ed Chen
April 15, 2018December 11, 2022
2 Comments

USE_DB_RECOVERY_FILE_DEST What is USE_DB_RECOVERY_FILE_DEST? The keyword is a constant value which indicates that we would like to use Fast Recovery Area (FRA) space as the… Read More »

How to Enable Fast Recovery Area (FRA)

by Ed Chen
October 30, 2012December 11, 2022

Fast Recovery Area (FRA) Fast Recovery Area (FRA) is a very convenient feature for DBA to backup and restore database. You may set the FRA… Read More »

How to Resolve ORA-19809 Limit Exceeded for Recovery Files

by Ed Chen
October 22, 2012December 11, 2022
10 Comments

ORA-19809 We usually watch the space usage of log archive destination very closely because the database will be suspended if the space is full. Particularly,… Read More »