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,