Hi ,,,
I recently have configured Physical standby for my production database (oracle 11.2.0.2 enterprise edition )
I hv following configuration :
On Production :
datafiles residing in '+DATA1/cbsprod/datafile/*' and '+DATA2/cbsprod/datafile/*'
AND on DR :
datafiles restored in '+DATA1/cbsdr/datafile/*' and '+DATA2/cbsdr/datafile/*'
Rman backup restore and media recovery started ,,everything went smooth at starting and media recovery stared and log were getting applied on my DR .
But yesterday i took standby controlfile from cbsprod and restore it on DR side and again started media recovery and it was giving me following errors :
---------------------------------------------------------------------------------------------------------
Slave exiting with ORA-1110 exception
Errors in file /oracle/diag/rdbms/cbsdr/cbsdr/trace/cbsdr_pr00_18481286.trc:
ORA-01110: data file 1: '+DATA1/cbsdr/datafile/system.270.819957033'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA1/cbsdr/datafile/system.270.819957033'
Recovery Slave PR00 previously exited with exception 1110
MRP0: Background Media Recovery process shutdown (cbsdr)
---------------------------------------------------------------------------------------------------------