RMAN restore - log_file_name_convert

[ErmanArslansOracleBlog]

You need to recover it Roshan..

Try this first;

recover database using backup controlfile until cancel;
<enter>
Then directly write cancel <enter> and then try to open using resetlogs.
If you still get ORA-01110, then you need to recover.
Again use recover database using backup controlfile until cancel;
But this time supply archivelogs or redologs (if they are containing the changes that are required to be applied for the recovery)

[Roshan]

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

[ErmanArslansOracleBlog]

Try the "redologs" for the recovery.
I mean when the recovery will ask archives, give redologs to it. (the correct redolog ofcourse, try redologs one by one)

[Roshan]

Redo logs are not present in the redo directories
SRDC_RMAN_RESTORE_DBINFO_WINSDB2_20161125_193305.htm

[Roshan]

I did the following below and database got started.
recoverlogfileFINAL.txt
Thank you for your help :)