Re: Coruppted system01.dbf

http://metalink.oracle.com.

Daniel Morgan

"Sławomir Marcinkowski" wrote:

> 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 Wed Apr 10 2002 - 10:26:56 CDT