Re: Coruppted system01.dbf

Don't be daft.

If it's the online log, then the control file already knows of its path and filename (plus the change numbers that would prompt its use). If you have to specify it, it's either not an online log, or there's rather more serious problems with your control file.

Regards
HJR "Mark Bateman" <nowhere_at_nowhere.com> wrote in message news:ygRv8.337$A43.156743_at_news11-gui.server.ntli.net...
>
> Hi there,
>
> It looks likely that the change it is requesting is still within your
online
> redo log. Try the recovery again, but this time type in the full path and
> file name for your online redo log.
>
> Regards,
>
> Mark Bateman
> Oracle remote DBA support, consultancy, discounted licences and training
> www.teamsolve.co.uk
>
> "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote in message
> news:a91ku8$opc$1_at_news.tpi.pl...
> > i do it, but oracle tell me:
> > SQL> recover database until cancel using BACKUP CONTROLFILE;
> > ORA-00279: change 7711636 generated at 04/09/2002 05:48:15 needed for
> thread
> > 1
> > ORA-00289: suggestion : /u01/app/oracle/product/9.0.1/dbs/arch1_156.dbf
> > ORA-00280: change 7711636 for thread 1 is in sequence #156
> > 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:
> > '/u01/app/oracle/product/9.0.1/oradata/BANK/system01.dbf'
> > ORA-01112: media recovery not started
> >
> > any idea?
> >
> > SM
> >
> >
> > Użytkownik "koert54" <koert54_at_nospam.com> napisał w wiadomości
> > news:PlHs8.8186$Ze.2380_at_afrodite.telenet-ops.be...
> > > - recover database until cancel ;
> >
> >
> >
>
>
Received on Fri Apr 19 2002 - 06:10:30 CDT