RMAN> recover database noredo; Starting recover at 11-SEP-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=51 device type=DISK channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: +DATA/hmprod_ndc/datafile/system.256.854646189 destination for restore of datafile 00002: +DATA/hmprod_ndc/datafile/sysaux.272.854646191 destination for restore of datafile 00003: +DATA/hmprod_ndc/datafile/undotbs1.271.854646191 destination for restore of datafile 00004: +DATA/hmprod_ndc/datafile/users.270.854646191 destination for restore of datafile 00005: +DATA/hmprod_ndc/datafile/mgmt_ecm_depot_ts.264.854660485 destination for restore of datafile 00006: +DATA/hmprod_ndc/datafile/mgmt_tablespace.263.854660517 destination for restore of datafile 00007: +DATA/hmprod_ndc/datafile/mgmt_ad4j_ts.262.854660573 destination for restore of datafile 00008: +DATA/hmprod_ndc/datafile/btest.273.946849219 channel ORA_DISK_1: reading from backup piece /backup/incr/inc_hmprd_94se6sub_1_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 09/11/2017 15:50:50 ORA-19870: error while restoring backup piece /backup/incr/inc_hmprd_94se6sub_1_1 ORA-19573: cannot obtain exclusive enqueue for datafile 6 |
Solution : Make sure you have stopped redo apply before starting recovery process. SQL > alter database recover managed standby database cancel; |