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)
How RMAN Backup Parallelly
To backup the database with multithreads can considerably speed up the backup process as long as IO throughput is good enough to handle high volume… Read More »How RMAN Backup Parallelly
Truncate vs Delete
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 »Truncate vs Delete
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 Oracle 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 Oracle 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 Oracle Enable ARCHIVELOG Mode
What is Archivinglog Mode? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which… Read More »How Oracle Enable ARCHIVELOG Mode