Re: Coruppted system01.dbf

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 - 04:17:33 CDT