Hello,
I'm running Oracle 10.2 Dataguard with SAP and encounter below errors while doing log shipping from Primary to Standby:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
MRP0 started with pid=17, OS id=3264
Managed Standby Recovery not using Real Time Apply
MRP0: Background Media Recovery terminated with error 1111
Errors in file z:\oracle\c30\saptrace\background\c30_mrp0_3264.trc:
ORA-01111: name for data file 36 is unknown - rename to correct file
ORA-01110: data file 36: 'O:\ORACLE\C30\102\DATABASE\UNNAMED00036'
ORA-01157: cannot identify/lock data file 36 - see DBWR trace file
ORA-01111: name for data file 36 is unknown - rename to correct file
ORA-01110: data file 36: 'O:\ORACLE\C30\102\DATABASE\UNNAMED00036'
--> So I recreated the datafile on Standby:
alter database create datafile 'O:\ORACLE\C30\102\DATABASE\UNNAMED00036' as
'Z:\ORACLE\C30\SAPDATA2\SR3_29\SR3.DATA29';
--> Got below errors when I reactivate the log shipping:
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Wed Oct 19 10:51:09 2016
Recovery interrupted!
Recovered data files to a consistent state at change 2757781634
Wed Oct 19 10:51:09 2016
Errors in file z:\oracle\c30\saptrace\background\c30_mrp0_5068.trc:
ORA-00308: cannot open archived log 'L:\ORACLE\C30\ORAARCH\C30ARCH\ARC02050_0891178030.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
--> Ran recover standby database:
SQL> recover standby database;
ORA-00279: change 2757781634 generated at 05/26/2016 06:01:45 needed for thread
1
ORA-00289: suggestion : L:\ORACLE\C30\ORAARCH\C30ARCH\ARC02050_0891178030.001
ORA-00280: change 2757781634 for thread 1 is in sequence #2050
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'L:\ORACLE\C30\ORAARCH\C30ARCH\ARC02050_0891178030.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: 'Z:\ORACLE\C30\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'
The recovery is asking for ARC02050_0891178030.001 but the redo log from Primary is C30ARCHARC02050_0891178030.001.
Any idea how to resolve it?
Thank you.