How RMAN List Backup Piece Content
Backup Piece A backup piece is a physical file that contain a part of backup targets in a backup operation. In a backup piece, the… Read More »How RMAN List Backup Piece Content
RMAN
Control_File_Record_Keep_Time, How and Why
Symptoms I found that RMAN backup records are lost regularly. Let's see the symptoms. 1. Obsolete Not Deleted Some backup files older than 3 months… Read More »Control_File_Record_Keep_Time, How and Why
How to Resolve RMAN-01009: syntax error: found
RMAN-01009 There're several error patterns that throw RMAN-01009 during RMAN statement execution. found "database" found "list" found "identifier" RMAN-01009 means that the word at the… Read More »How to Resolve RMAN-01009: syntax error: found
How to Resolve RMAN-06023: no backup or copy of datafile found to restore
RMAN-06026 and RMAN-06023 Found errors RMAN-06026 and RMAN-06023 after several hours of database restore. RMAN> restore database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK… Read More »How to Resolve RMAN-06023: no backup or copy of datafile found to restore
How to Resolve RMAN-03009: failure of allocate command on channel
RMAN-03009 I used to allocate multiple RMAN channels to backup the database parallelly, but I failed with RMAN-03009 about channel allocation problem. RMAN> run {… Read More »How to Resolve RMAN-03009: failure of allocate command on channel
How RMAN Duplex Backup Copies
After knowing how to change the backup location in different scenarios, let's see a more advance topic about making backup copies in RMAN. By default,… Read More »How RMAN Duplex Backup Copies
How to set RMAN 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 to set RMAN Backup Location
How RMAN Parallelism Works
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 »How RMAN Parallelism Works
How to Resolve RMAN-06059: expected archived log not found
RMAN-06059 RMAN-06059 means that the archived logs you expect to use are missing from where they should be. In my case, when I tried to… Read More »How to Resolve RMAN-06059: expected archived log not found
How to Restore RAC Database from RMAN Backup Set
For 10g RAC database restoration, you may check: How to Restore 10g RAC Database from a Backup Set. Suppose we have restored 12c clusterware back.… Read More »How to Restore RAC Database from RMAN Backup Set