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-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
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
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
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
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