Fast Recovery Area (FRA)

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-02065: illegal option for ALTER SYSTEM

by Ed Chen
September 27, 2021February 5, 2023

ORA-02065 There're 2 error patterns of ORA-02065 in this post. Enabling Archivelog Mode Set DB_RECOVERY_FILE_DEST_SIZE Enabling Archivelog Mode Some may try to enable archivelog mode… Read More »

How to set RMAN Backup Location

by Ed Chen
February 17, 2021December 30, 2022

By default, all backup pieces of RMAN go to Fast Recovery Area (FRA), but we can change it. In RMAN, we can set different backup… Read More »

How RMAN Parallelism Works

by Ed Chen
February 15, 2021September 6, 2022

RMAN Parallelism To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle… Read More »

Truncate vs Delete in Oracle

by Ed Chen
May 27, 2020December 10, 2022

Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… Read More »

How to Create a ASM Disk Group

by Ed Chen
December 3, 2018August 15, 2019

To isolate non-crucial backups from crucial data in the current disk group DATA, a separate new disk group with new disks is needed to put… 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 »

Online Archived Logs vs Backup Archived Logs

by Ed Chen
April 14, 2018December 11, 2022

Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference.… 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 »