Hi all,

I have this scenario on my recover task and it's not succesful when I tried to recover the database.

power surge caused the database crash and media failure, losing all the online logs.

SVRMGRL> shutdown abort

$ rm cradata\houston\*.log
$ cp /home/backup/*.log cradata\houston\

SVRMGRL> startup mount
ORACLE instance started.
Total System Global Area 57939996 bytes
Fixed Size 75804 bytes
Variable Size 55693312 bytes
Database Buffers 1638400 bytes
Redo Buffers 532480 bytes
Database mounted.

SVRMGR> recover database until cancel;
ORA-00279: change 811845 generated at 08/08/2002 13:04:58 needed for thread 1
ORA-00289: suggestion : C:\ARCHIVEDREDOLOGS\HOUSTON\ARC01266.001
ORA-00280: change 811845 for thread 1 is in sequence #1266
Specify log: {=suggested | filename | AUTO | CANCEL}

Log applied.
ORA-00279: change 811846 generated at 08/08/2002 13:04:59 needed for thread 1
ORA-00289: suggestion : C:\ARCHIVEDREDOLOGS\HOUSTON\ARC01267.001
ORA-00280: change 811846 for thread 1 is in sequence #1267
ORA-00278: log file 'C:\ARCHIVEDREDOLOGS\HOUSTON\ARC01266.001' no longer needed
for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log 'C:\ARCHIVEDREDOLOGS\HOUSTON\ARC01267.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-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORADATA\HOUSTON\SYS1HOUSTON.ORA'

the thing is ARC01267.001' never exists un the archive log so why Oracle ask for you??? is it b/c I have uncommit process when the database crash???

Please advise and solutions of how to fix this issues.

Thanks