求救:数据库恢复
imfjl 2005-05-13 10:30:04 1.启动数据库出错
SQL> startup
ORACLE instance started.
Total System Global Area 336356520 bytes
Fixed Size 279720 bytes
Variable Size 268435456 bytes
Database Buffers 67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
2.若以noresetlogs打开数据库
SQL> ALTER DATABASE OPEN NORESETLOGS;
ALTER DATABASE OPEN NORESETLOGS
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
3.以resetlogs打开数据库
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: '/home/oracle/software/oradata/ORA1/system01.dbf'
3.恢复数据库
SQL> recover database until cancel
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
4.再尝试恢复
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2039722618 generated at 03/30/2005 11:58:32 needed for thread
1
ORA-00289: suggestion : /home/oracle/software/dbs/arch1_19264.dbf
ORA-00280: change 2039722618 for thread 1 is in sequence #19264
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '/home/oracle/software/dbs/arch1_19264.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: '/home/oracle/software/oradata/ORA1/system01.dbf'
5.打开数据库
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: '/home/oracle/software/oradata/ORA1/system01.dbf'
------------------------------------------------------------------------------
现在我应该怎么办啊??急盼答复