| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Coruppted system01.dbf
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:14:34 CDT
 |
 |