Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Recover 81701 db from media failure on linux
During a load a record and commit procedure a media failure occurs and
i lost all logs and control files.
i recreated the controls and logs files from a backup controlfile to
trace procedure but the db wont recover and return the following
error messages...
is it possible to recover the db with only the dbf files in recover
status?
any help is appreciated, nick
ps. i am on linux mandrake 7.2
SQL> SELECT name FROM v$datafile;
NAME
9 rows selected.
SQL> recover datafile '/hdb1/linux/ora81701/users02.dbf' ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE
ORA-00279: change 15345591 generated at 08/22/2001 19:18:06 needed for
thread 1
ORA-00289: suggestion : /ora81701/dbs/arch1_174792.dbf
ORA-00280: change 15345591 for thread 1 is in sequence #174792
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/ora81701/dbs/arch1_174792.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
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: '/ora81701/oradata/hm/system01.dbf'
SQL> RECOVER DATABASE UNTIL CHANGE 15345591 ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/ora81701/oradata/hm/system01.dbf'
SQL> Received on Fri Aug 24 2001 - 03:39:03 CDT