How RMAN Set Backup Location
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
Fast Recovery Area (FRA)
Truncate vs Delete Entire Table
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
How to Create a ASM Disk Group
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
How to Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
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 Resolve ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST
How to Set USE_DB_RECOVERY_FILE_DEST
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
Online Archived Logs vs Backup Archived Logs
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 »Online Archived Logs vs Backup Archived Logs
How to Enable Fast Recovery Area (FRA)
Fast Recovery Area (FRA) is a very convenient feature for DBA to backup and restore database. It could happen on us to leave FRA option… Read More »How to Enable Fast Recovery Area (FRA)
How to Resolve ORA-19809 Limit Exceeded for Recovery Files
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 »How to Resolve ORA-19809 Limit Exceeded for Recovery Files
How to Enable ARCHIVELOG Mode in Oracle
For 9i database or below, please refer to: How to Enable ARCHIVELOG Mode in Oracle 9i What is Archiving? The process of copying inactive redo… Read More »How to Enable ARCHIVELOG Mode in Oracle