on 09-29-2015 2:26 AM
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.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.