RMAN

How to Resolve ORA-45909: restore, recover or block media recovery may be in progress

by Ed Chen
June 15, 2023June 24, 2023

ORA-45909 Tried to restore a data file by RMAN, it failed with ORA-45909, ORA-19890 and ORA-19573. RMAN> restore datafile 13; ... ORA-19870: error while restoring… Read More »

How to Resolve RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

by Ed Chen
June 14, 2023June 24, 2023

RMAN-06509 When we tried to restore a datafile from a backup piece in RMAN, we saw error RMAN-06509. RMAN> restore datafile 1 from '/home/oracle/datafile-0a1r6qon_1_1'; ...… Read More »

How to Resolve ORA-19697: standby control file not found in backup set

by Ed Chen
June 13, 2023June 24, 2023

ORA-19697 Tried to restore controlfile from a backup set by RMAN, but it failed with ORA-19697. RMAN> restore controlfile from '/home/oracle/031r656h_1_1'; ... ORA-19697: standby control… Read More »

How to Resolve ORA-19687: SPFILE not found in backup set

by Ed Chen
June 12, 2023May 3, 2023

ORA-19687 Tried to restore SPFILE from a backup set by RMAN, but it failed with ORA-19687. RMAN> restore spfile from '/backup/rman/051r6emh_1_1'; ... ORA-19687: SPFILE not… Read More »

How RMAN Restore Table

by Ed Chen
March 30, 2023June 6, 2023

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 to Resolve RMAN-06094: datafile 1 must be restored

by Ed Chen
February 17, 2023June 6, 2023

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-03031: this option of set command needs to be used inside a run block

by Ed Chen
February 16, 2023February 13, 2023

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 »

Control_File_Record_Keep_Time, How and Why

by Ed Chen
May 9, 2022April 26, 2023

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 »

JavaScript is not enabled. Please enable it and reload the page.