使用dbms_backup_restore.zerodbid(0)后的问题

这是我自己的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/