Re: RMAN restore - log_file_name_convert
Posted by Roshan on Nov 25, 2016; 10:36am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-log-file-name-convert-tp1576p1618.html
I already did it. It is still asking for archivelogs which does not exist on production. I have applied all the latest once.
Extract from alert log
Media Recovery Log /archive/winsdb/2_27956_767727243.arc
Fri Nov 25 14:09:02 2016
Media Recovery Log /archive/winsdb/2_27957_767727243.arc
Fri Nov 25 14:10:33 2016
Media Recovery Log /archive/winsdb/2_27958_767727243.arc
Fri Nov 25 14:12:10 2016
Media Recovery Log /archive/winsdb/2_27959_767727243.arc
Fri Nov 25 14:13:46 2016
Media Recovery Log /archive/winsdb/2_27960_767727243.arc
Fri Nov 25 14:13:46 2016
Errors with log /archive/winsdb/2_27960_767727243.arc
Errors in file /opt/app/oracle/diag/rdbms/winsdb/WINSDB2/trace/WINSDB2_pr00_14991.trc:
ORA-00308: cannot open archived log '/archive/winsdb/2_27960_767727243.arc'
ORA-17503: ksfdopn:4 Failed to open file /archive/winsdb/2_27960_767727243.arc
ORA-17500: ODM err:File does not exist
Fri Nov 25 14:14:23 2016
ORA-279 signalled during: alter database recover automatic using backup controlfile until cancel...
SQL> set linesize 1000
SQL> /
GROUP# STATUS MEMBER
---------- ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
9 /ORAREDO1/WINSDB/redo09_01.log
9 /ORAREDO2/WINSDB/redo09_02.log
10 /ORAREDO1/WINSDB/redo10_01.log
10 /ORAREDO2/WINSDB/redo10_02.log
11 /ORAREDO1/WINSDB/redo11_01.log
11 /ORAREDO2/WINSDB/redo11_02.log
5 /ORAREDO1/WINSDB/redo05.log
6 /ORAREDO2/WINSDB/redo06.log
5 /ORADATA5/WINSREDO/redo05_1.log
6 /ORADATA5/WINSREDO/redo06_1.log
10 rows selected.
Rgds,
Roshan