I am having trouble opening DB after Blackout. It was NOT running in
the archived mode. I have export of the DB from a day before. When I
try to recover it, I get the error below.
PLEASE HELP.
SVRMGR> recover database
ORA-00283: recovery session canceled due to errors
ORA-00314: log 1 of thread 1, expected sequence# 99835 doesn't match
99838
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ICMS\REDO01.LOG'
SVRMGR> recover database until cancel
ORA-00279: change 73726420 generated at 08/14/2003 08:48:54 needed for
thread 1
ORA-00289: suggestion : C:\ORACLE\ORA81\RDBMS\ARC99835.001
ORA-00280: change 73726420 for thread 1 is in sequence #99835
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
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:\ORACLE\ORADATA\ICMS\SYS1ICMS.ORA'
Received on Tue Aug 19 2003 - 06:35:24 CDT
