How RMAN Restore Table
Recover Table by RMAN We have talked about how to restore a table from the recyclebin earlier. By using the feature of recyclebin, we can… Read More »How RMAN Restore Table
RMAN
How to Resolve RMAN-06094: datafile 1 must be restored
RMAN-06094 Tried to recover a database, but it failed with RMAN-06094. RMAN> recover database; ... RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:… Read More »How to Resolve RMAN-06094: datafile 1 must be restored
How to Resolve RMAN-03031: this option of set command needs to be used inside a run block
RMAN-03031 Saw error RMAN-03031 like this: RMAN> set newname for datafile 1 to '/oradata/ORCLCDB/system01.dbf'; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================… Read More »How to Resolve RMAN-03031: this option of set command needs to be used inside a run block
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
Control_File_Record_Keep_Time, How and Why
In this post, I'll talk about why we should increase CONTROL_FILE_RECORD_KEEP_TIME and how to increase it. RMAN Loss of Memory Check Backup Record Keep Size… 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 There're 2 error patterns of RMAN-06023 and RMAN-06026 in this post. Target Not Found in Backup Missing Directory in ASM Target Not… 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