cancel
Showing results for 
Search instead for 
Did you mean: 

Restoration of archived files error

former_member215439
Participant
0 Kudos

Hi Experts,

     I am restoring the arch files to our DR server using brtools and it cannot find the ARCH1234.0001 then i checked out alert_prd it seems that the brtools is looking for the ARCH1234.001 not for ARCH1234.0001.I have checked the log_archive_format='ARC%s_%R.%T' in INIT<SID>.ORA and there's nothing wrong with this parameter.

    

     How can I fix it?

THANKS!

Please see below for more details:

ALERT_PRD

ALTER DATABASE RECOVER  from 'G:\oracle\PRD\sapbackup\vermrsem'  LOGFILE 'G:\oracle\PRD\sapbackup\vermrsem\ARC80_0891011493.001' 

Tue Sep 29 08:55:07 2015

Media Recovery Log G:\oracle\PRD\sapbackup\vermrsem\ARC80_0891011493.001

Tue Sep 29 08:55:07 2015

Errors with log G:\oracle\PRD\sapbackup\vermrsem\ARC80_0891011493.001

Tue Sep 29 08:55:07 2015

Errors in file E:\ORACLE\diag\rdbms\prd\prd\trace\prd_pr00_2460.trc:

ORA-00308: cannot open archived log 'G:\oracle\PRD\sapbackup\vermrsem\ARC80_0891011493.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-308 signalled during: ALTER DATABASE RECOVER  from 'G:\oracle\PRD\sapbackup\vermrsem'  LOGFILE 'G:\oracle\PRD\sapbackup\vermrsem\ARC80_0891011493.001'  ...

ALTER DATABASE RECOVER  from 'G:\oracle\PRD\sapbackup\vermrsem'  LOGFILE 'G:\oracle\PRD\sapbackup\vermrsem\ARC81_0891011493.001' 

Tue Sep 29 08:55:07 2015

Media Recovery Log G:\oracle\PRD\sapbackup\vermrsem\ARC81_0891011493.001

Tue Sep 29 08:55:07 2015

Errors with log G:\oracle\PRD\sapbackup\vermrsem\ARC81_0891011493.001

Tue Sep 29 08:55:07 2015

Errors in file E:\ORACLE\diag\rdbms\prd\prd\trace\prd_pr00_2460.trc:

ORA-00308: cannot open archived log 'G:\oracle\PRD\sapbackup\vermrsem\ARC81_0891011493.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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182657
Active Contributor
0 Kudos

Hi James,

You could refer similar SCN thread at ORA-00308: cannot open archived log, ORA-27041 | SCN

for the issue.

Hope this will resolve your issue.

Regards,