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

[former_member182034]

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,

[Former Member · Accepted solution]

Hi,

Could you paste here, LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT parameters, on both servers?

Best regards,

Orkun Gedik

[former_member182034 · Accepted solution]

hi Dear,

Primary server (PRD)

*.log_archive_dest='F:\oracle\PRD\oraarch\PRDarch'

now I have to delete the parameter Log_Archive_Dest on PRD system and set the Log_Archive_Dest_1.

please confirm me that if i set the log_archive_dest_1 then PRDarch folder automatically create in Oraarch folder or will l create it manually AND new archives automatically store in PRDarch folder after restart the DB.

STANDBY (DR)

*.log_archive_dest_1='LOCATION=F:\oracle\PRD\oraarch\PRDarch'

*.log_archive_format='%t_%s_%r.dbf'

now I did copies all archive with extension(0657865393.001)from PRD to DR (F:\oracle\PRD\oraarch\PRDarch) and when I try to apply archive then getting below error

ORA-00308: cannot open archived log

here i need to change the format parameter.

Regards,

[Former Member · Accepted solution]

Hi,

Change tbe below parameter on DR (standby) server as suggested by Eric.

*.log_archive_format='%t_%s_%r.dbf'

to

*.log_archive_format='%t_%s_%r.001'

(Please note the extension part...)

Shutdown and mount DB on DR server.

It will solve your problem.

If you maintain same value on both PRD and DR server, you will not get such error in future..

Regards.

Rajesh Narkhede

[former_member182034 · Accepted solution]

hi all,

after recommendation , now parameter values on DR server is :

*.log_archive_dest_1='LOCATION=F:\oracle\PRD\oraarch\PRDarch'
*.log_archive_format='%t_%s_%r.001'

when i try to apply

SQL> recover database using backup controlfile;
ORA-00279: change 1211443555 generated at 02/10/2012 23:36:05 needed for thread
1
ORA-00289: suggestion : F:\ORACLE\PRD\ORAARCH\PRDARCH\1_59557_657865393.001
ORA-00280: change 1211443555 for thread 1 is in sequence #59557


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'F:\ORACLE\PRD\ORAARCH\PRDARCH\1_59557_657865393.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.

if you see that the required archive is: 1_59557_657865393.001

while copied archive exist with this name: PRDARCHARC59557_0657865393.001

I tried to change in Format parameter to make required format but

Exp:

%t_%s_%r.001

1_59557_657865393.001

ARC%s%r%t.001

ARC595576578653931.001'

ARC%s_%r%t.001

ARC59557_6578653931.001

ARC%s_%r.%t

ARC59557_657865393.1

PRDARCHARC%s_%r.%t

PRDARCHARC59557_657865393.1

Required Format: PRDARCHARC59540_0657865393.001

how can i resolve this different name issue? please suggest me required format.

Regards,

[former_member188883 · Accepted solution]

Hi,

What is the value of log_archive_format on PRD.

Maintain the same on DR server as well.

Regards,

Deepak Kori

[former_member182034 · Accepted solution]

hi Kori,

thx for your reply,

dear, as i mentioned above that there is no value against format parameter on PRD server.

one thing which i have to remember , the value of log_archive_format should be same on both server.

but here how can i resolve this naming convention issue and which format i have to set to make below archive.

%t_%s_%r.001

PRDARCHARC59557_0657865393.001

Regards,

[former_member188883 · Accepted solution]

Hi Majamil,

Can you try with this solution

log_archive_format = "PRDARCHARC%s_%R.%T"

Note the letters in CAPS.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi,

To Avoid any confusion, just make sure that below parameters are same on both servers.

*.log_archive_dest_1

*.log_archive_format

Second, make sure that both server has the same path (folders) in "log_archive_dest_1" location. Means if you have "F:\oracle\PRD\oraarch\PRDarch" path in PRD server use/create same on DR server.

Ensure that archive logs are at same location as PRD server with same permissions.

It will solve the issue.

Regards.

Rajesh Narkhede

[former_member182034]

thanks Respected Kori, Ventaka and other for your support. problem solved with the help of.

Kori,

last reply.

hi Venkata,

renaming "remedy" also resolved the issue.

this reply only for SDN users to know the solution.

Regards,

majamil

[former_member182034]

thanks Respected Kori, Ventaka and other for your support. problem solved with the help of.

Kori,

last reply.

hi Venkata,

renaming "remedy" also resolved the issue.

above only for SDN users.

Regards,

majamil

[former_member182034]

thanks Respected Kori, Ventaka and other for your support. problem solved with the help of.

Kori,

last reply.

hi Venkata,

renaming "remedy" also resolved the issue.

[Former Member]

Hi Majamil,

Try to copy(rename) the restored production redolog file PRDARCH1_59501_657865393.DBF as PRDARCH1_59501_657865393.001, and give a try.

Regards,

Venkata S Pagolu.

[Former Member]

Hi Majamil,

Try to copy(rename) the restored production redolog file PRDARCH1_59501_657865393.DBF as PRDARCH1_59501_657865393.001 as mentioned below and give a try

> mv PRDARCH1_59501_657865393.DBF PRDARCH1_59501_657865393.001

Regards,

Venkata S Pagolu.

[former_member204746]

hi,

make sure you use the same parameters on initial and DR instance.

change this:

log_archive_format='%t_%s_%r.dbf'

to this:

log_archive_format='%t_%s_%r.001

then, restart DR DB

[Former Member]

Hi,

Please go through the below thread. It may be helpful to you

http://www.idevelopment.info/data/Oracle/DBA_tips/Standby_Database/SD_2.shtml

Regards,

Venkata S Pagolu.