这是我自己的TESTDB
之前使用dbms_backup_restore.zerodbid(0)之后没有重启DB
因此造成在写system时实例down.
alert日志中出现如下信息:
Fri Sep 5 14:20:07 2008
Errors in file /oracle/admin/orcl/bdump/orcl_ckpt_4414.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oradata/system01.dbf'
ORA-01206: file is not part of this database - wrong database id
Fri Sep 5 14:20:07 2008
CKPT: terminating instance due to error 1242
Instance terminated by CKPT, pid = 4414
处理方法如下:
[oracle@asm2 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Sep 5 14:27:58 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 264241152 bytes
Fixed Size 1218892 bytes
Variable Size 67110580 bytes
Database Buffers 192937984 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01221: data file 1 is not the same file to a background process
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 264241152 bytes
Fixed Size 1218892 bytes
Variable Size 67110580 bytes
Database Buffers 192937984 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01221: data file 1 is not the same file to a background process
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database using backup controlfile ;
ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1
ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbf
ORA-00280: change 1445010 for thread 1 is in sequence #816
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/oradata/arch/1_816_663837713.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log '/oradata/arch/1_816_663837713.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> alter database until cancel;
alter database until cancel
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile ;
ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1
ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbf
ORA-00280: change 1445010 for thread 1 is in sequence #816
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel;
ORA-00308: cannot open archived log 'cancel;'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database resetlogs;
alter database resetlogs
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradata/system01.dbf'
SQL> recover datafile 1;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1
ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbf
ORA-00280: change 1445010 for thread 1 is in sequence #816
Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
Database altered.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/104152/viewspace-442123/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/104152/viewspace-442123/