Recover Database with missing Archieve Logs

Recover Database witn missing Archieve Logs

I am trying the restore my old database but due to missing of one archieve log. i m not able to restore and recover from rman

Not able to open database

ora 19870 ora 19505 ora 27041 osd 04002

rman 00571 rman 00569 rman 03002 rman 06053 rman 06025


--------------A---------------------------------------
crosscheck copy of archivelog all;
crosscheck archivelog all;
resync catalog;
delete force obsolete;
delete expired archive all;


Note: not able to resync because not able to connect to recovery catalog because database is not open.

---------------B----------------------------------------
Point in time Recovery
-------------
1)
restore database UNTIL TIME "TO_DATE('03/27/09 10:05:00','MM/DD/YY = HH24:MI:SS')";
recover database UNTIL TIME "TO_DATE('03/27/09 10:05:00','MM/DD/YY = HH24:MI:SS')";

rman-03002 rman-20207

2)
restore database until scn 1000;
recover database until scn 1000;

3)
restore database until sequence 923 thread 1;
recover database until sequence 923 thread 1;


Note: not recover because of missing sequence.


---------------C----------------------------------------

list incranation
reset database to incranation inc_key;

restore database until sequence 923 thread 1;
recover database until sequence 923 thread 1;


Note: not recover because of missing sequence.

--------------D----------------------------------------
alter database backup controlfile to trace as 'c:\newcontrolfile.txt'

create new control file from above.


--------------E-FINAL SOLUTION---------------------------------------

shutdown immediate;
add into init.ora _allow_resetlogs_corruption=true
startup mount;
sql>recover database until cancel using backup controlfile;

Specify log: {=suggested | filename | AUTO | CANCEL}

CANCEL

Alter database open resetlogs








===============================================================