Re: ora-01194 file 1 needs more recovery - After Blackout

"Igor Kaplun" <ikaplun_at_needhamco.com> wrote in message news:9967d711.0308190335.3e1101e1_at_posting.google.com...
> 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'

This is my understanding of what your situation is, but you would be well advised to open a TAR with Oracle rather than relying on some guy in the newsgroups :)

Your database needs change 73726420 to recover. This change was recorded in a redo log that has been overwritten. Thus Oracle wants to get it from what the archived log file would be called if you had it. Unfortunately you don't have it and so recovery is not possible. You seem to be saying that the only backup you have is an export from last night, so it would look like recreating the database (since it is the system tablespace that is stuffed up) and importing the data from export is your next best bet. This obviously loses data which is why I'd suggest a TAR if I'm incorrect then taking my advice would be very unhelpful indeed.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK