Skip to Content
0
Feb 09, 2012 at 05:27 PM

ORA-00308: cannot open archived log, ORA-27041

5310 Views

hi All,

here I am making DR server and I copied SAP Data file1,2,3,4 from PRD to DR server and created control file. when I try to run following command for applied archives which i copy from PRD then getting below error.

SQL>Startup
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

 SQL> recover database using backup controlfile;
ORA-00279: change 1209554452 generated at 02/09/2012 17:02:57 needed for thre
1
ORA-00289: suggestion : F:\ORACLE\PRD\ORAARCH\PRDARCH1_59501_657865393.DBF
ORA-00280: change 1209554452 for thread 1 is in sequence #59501
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'F:\ORACLE\PRD\ORAARCH\PRDARCH1_59501_657865393.DBF'
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-00308: cannot open archived log
'F:\ORACLE\PRD\ORAARCH\PRDARCH1_59501_657865393.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

here required PRDARCH1_59501_657865393.DBF while PRD server have PRDARCHARC59501_0657865393.001

I did change the LOG_ARCHIVE_DEST parameter in initSID.ora of DR server and not in PRD.

please tell that, how can i apply PRD's archive (.001 extension) on DR.

Regards,