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 Set Backup Location
Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL or DML? DDL… Read More »Truncate vs Delete Entire Table
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 Create a ASM Disk Group
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 Set USE_DB_RECOVERY_FILE_DEST