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

这是我自己的TESTDB
/G Z~Ck0之前使用dbms_backup_restore.zerodbid(0)之后没有重启DBITPUB个人空间w#k&?\ `p
因此造成在写system时实例down.

alert日志中出现如下信息：ITPUB个人空间}_H#a{v"@DE
  Fri Sep  5 14:20:07 2008
,c1Us^!JM;Z.Rn"IL0Errors in file /oracle/admin/orcl/bdump/orcl_ckpt_4414.trc:ITPUB个人空间E\k3X%IeQR
ORA-01242: data file suffered media failure: database in NOARCHIVELOG modeITPUB个人空间\$]/Lb]5X
ORA-01122: database file 1 failed verification checkITPUB个人空间P
W(R}Hth
ORA-01110: data file 1: '/oradata/system01.dbf'
"t ]bYI(]K0ORA-01206: file is not part of this database - wrong database id
.?&l)Eq;Qkis0Fri Sep  5 14:20:07 2008ITPUB个人空间C;s5tC8I y%QQ
CKPT: terminating instance due to error 1242ITPUB个人空间+u9}Mf#B!vog
Instance terminated by CKPT, pid = 4414

处理方法如下：
m)G~(vO0[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 sysdbaITPUB个人空间3C!@#fh)R)`?*r
Connected to an idle instance.ITPUB个人空间v*HTtD_,o{
SQL> startupITPUB个人空间HRv!T5o
ORACLE instance started.

Total System Global Area  264241152 bytes
3^NQb Eu{B0Fixed Size                  1218892 bytes
x}I4oz9zbW:o0Variable Size              67110580 bytes
^ A"nf+W0ea0Database Buffers          192937984 bytes
-A.\q/y;ty:w v0l0Redo Buffers                2973696 bytesITPUB个人空间_*Vm:u}Xbo
Database mounted.ITPUB个人空间bVF,Y[-L
ORA-01221: data file 1 is not the same file to a background process

ITPUB个人空间/B|4l,J#O/{8?-lLLp
SQL> shutdown abort;ITPUB个人空间.vJ[_p t2sf
ORACLE instance shut down.
$Q M,p.U)\r[
g%u~0SQL> startup mount;
\5D!{ N+^7V'Pca0ORACLE instance started.

Total System Global Area  264241152 bytesITPUB个人空间@2A8__HtX:z
Fixed Size                  1218892 bytesITPUB个人空间$N
ro^]+v$wr"o
Variable Size              67110580 bytes
[|F0Zm i0Database Buffers          192937984 bytesITPUB个人空间4J1p/Kj+e ?9mo/k
Redo Buffers                2973696 bytesITPUB个人空间} l8HZEV
Database mounted.ITPUB个人空间}8uN-R
tN F.d
SQL> recover database;ITPUB个人空间9xs(SP4\g't
Media recovery complete.ITPUB个人空间-t9K xo:ihb3s
SQL> alter database open;ITPUB个人空间$N ]#f;zH(W-C
alter database openITPUB个人空间/d!S4U)d?(N`my}
*
E4pW{!l]qA1V9yT"O0ERROR at line 1:
{;Sm h!XbAOh M0ORA-01221: data file 1 is not the same file to a background process

0yV9n%rY0SQL> alter database open resetlogs;ITPUB个人空间+dc0C
`4J
alter database open resetlogsITPUB个人空间Iws9mJFc
*
6j.j:Cp
duP0ERROR at line 1:
D$t+~&oD]0ORA-01139: RESETLOGS option only valid after an incomplete database recovery

ITPUB个人空间^q|!nF.{
SQL> recover database using backup controlfile ;
8[&]Cg7Z&Oh1xsMe0ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1

t&hd.i1q|0ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbf
;b+^K4M8wG&D7C0ORA-00280: change 1445010 for thread 1 is in sequence #816

KFo s1O5S&AKC+P A0Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
2s!s-d Oa1l0autoITPUB个人空间S o6gI1O,r&N
h
ORA-00308: cannot open archived log '/oradata/arch/1_816_663837713.dbf'ITPUB个人空间Z*Jv5t4O-d Y4j8d2f
ORA-27037: unable to obtain file status
*Q%f4}hr0Linux Error: 2: No such file or directoryITPUB个人空间:R b;FMr0Gq.He+x
Additional information: 3

-a7M
[K(fW0ORA-00308: cannot open archived log '/oradata/arch/1_816_663837713.dbf'
Y,zP#xp}5D6i&E0ORA-27037: unable to obtain file statusITPUB个人空间nq0pU~
g3R
Linux Error: 2: No such file or directory
]3Eaj~V0Additional information: 3

oqC1|1|vc0SQL> alter database until cancel;
#Y$WwDb0alter database until cancel
m"v_2t2Xo#S,^0                     *
*P%u(uW#r2y(g"C;U;L*j0ERROR at line 1:
'}i6RD.M`0ORA-02231: missing or invalid option to ALTER DATABASE

ITPUB个人空间'yr.?9{t J b Z
SQL> recover database until cancel;
2~?i:Yef0ORA-00283: recovery session canceled due to errors
+Ur-\b+J1cl0ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

ITPUB个人空间.Xx E9E!RC0?
SQL> recover database using backup controlfile ;
#FI2S:F'T#q6L3l0ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1
&}gs/Z.w^ W0g7{0ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbfITPUB个人空间;E\[m sQ O:R)]4\e
ORA-00280: change 1445010 for thread 1 is in sequence #816

8QQjP U0Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ITPUB个人空间@,eWq7N"uy1}
cancel;ITPUB个人空间UF&h/s[*e
ORA-00308: cannot open archived log 'cancel;'ITPUB个人空间5L.{lH!K On3^-e&me
ORA-27037: unable to obtain file status
%Gt2wA#b6E0Linux Error: 2: No such file or directory
#@9L'|O3P"B$cJ4?0Additional information: 3

4_O+B(Y3L7n\G0Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ITPUB个人空间*}3Dc
W|,Hz?
cancel
+V)Zn C;O~0Media recovery cancelled.ITPUB个人空间(O%eUyw-H6Qa
SQL> alter database open;
Y6I4E1x$m&?x9M0alter database openITPUB个人空间KU-K!B"Dg
*
}hn!HZ0B}rn9v0ERROR at line 1:ITPUB个人空间:B$Cx*ca4vp:`vR
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

Tz)\x'\5b7D0SQL> alter database resetlogs;ITPUB个人空间&eoVTjT O*Q3fk
alter database resetlogs
u`W&LAZ0                       *ITPUB个人空间4r#|l]t b$vz_!dJG*h
ERROR at line 1:ITPUB个人空间X(e#@
E;uU+h
ORA-02231: missing or invalid option to ALTER DATABASE

F}6@-^
A|;s {*zg ]0F$DF0SQL> alter database open resetlogs;
*sFb?'|r3gQ;zd0alter database open resetlogsITPUB个人空间hz{XG+b
*ITPUB个人空间tz(Tg`{*V_(Z
ERROR at line 1:ITPUB个人空间-@1l2U1Ymh
ORA-01113: file 1 needs media recovery
hveW&|Qe T[v0ORA-01110: data file 1: '/oradata/system01.dbf'

pN(cn3w4?(fh0SQL> recover datafile 1;
)_:VmA7WZ"g"[c0ORA-00283: recovery session canceled due to errorsITPUB个人空间e&AG(sWc6z)AMn
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

ly GPJ&?5I0SQL> recover database using backup controlfile until cancel;
y4]~ @A5tRXTn0ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1ITPUB个人空间(f d2Al/`UlF
ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbfITPUB个人空间ly#M8]9S @ }
ORA-00280: change 1445010 for thread 1 is in sequence #816

ITPUB个人空间z.i5F,NP'^T8sy/d
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ITPUB个人空间tV+F%GN6^2` {W"M
cancel
3{3l.M8Q:R9Y4Whb0Media recovery cancelled.ITPUB个人空间\9D*@J&mr'VId
SQL> alter database open resetlogs;

Database altered.