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 c:oradata\houston\*.log
$ cp /home/backup/*.log c:oradata\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