Ask Me

Recovery failed while applying RMAN incremental backup on standby

 

 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;
 



Popular Posts