linux oracle ORA-01221: data file 1 is not the same file to a background process

因此造成在写system时实例down.

alert日志中出现如下信息：ITPUB个人空间K){id,@:dn%C
  Fri Sep  5 14:20:07 2008
~vd"D8gW0Errors in file /oracle/admin/orcl/bdump/orcl_ckpt_4414.trc:ITPUB个人空间Ut~tED%e
ORA-01242: data file suffered media failure: database in NOARCHIVELOG modeITPUB个人空间c)aU?m#UW#c
ORA-01122: database file 1 failed verification check
Rl�ZF*v u0ORA-01110: data file 1: '/oradata/system01.dbf'
@s.DJT%`-P6k,I+gJ,B0ORA-01206: file is not part of this database - wrong database id
\_u:~#\O |)MZS0Fri Sep  5 14:20:07 2008
x-|ct7F5I*{0CKPT: terminating instance due to error 1242
7?]+g/waRZ|X0Instance terminated by CKPT, pid = 4414

处理方法如下：
[zBptgL)~0[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个人空间EQ y6X B~
Connected to an idle instance.
K.fd8Yy|0SQL> startup
.Hi5Cl,^5M~0ORACLE instance started.

Total System Global Area  264241152 bytesITPUB个人空间 a:i*y5l7?'DNu�|'H4@i
Fixed Size                  1218892 bytes
nI1y7z&p+r5L(v0Variable Size              67110580 bytesITPUB个人空间ws1[|~ BL??
Database Buffers          192937984 bytesITPUB个人空间%g%^'Vxae/tM
Redo Buffers                2973696 bytes
U-]%I m&~P$x0Database mounted.ITPUB个人空间'i)P7MmI5@/n~
ORA-01221: data file 1 is not the same file to a background process

ITPUB个人空间Ll4b/b.X'N/x
SQL> shutdown abort;ITPUB个人空间6~@1z"[x${
ORACLE instance shut down.ITPUB个人空间'? tJp+| `
SQL> startup mount;
q7MI�]%I0ORACLE instance started.

Total System Global Area  264241152 bytes
n+z5M+KWN0Fixed Size                  1218892 bytes
~�S/O8d*Lo!C]0Variable Size              67110580 bytes
4Plb;h jD(t`0Database Buffers          192937984 bytes
,Y(}n?Mf.g M\0Redo Buffers                2973696 bytesITPUB个人空间)y(Zk$WN1gQ'q1SL~m;f
Database mounted.
z'?2|8B*s&A0SQL> recover database;
_j^M9IE0Media recovery complete.ITPUB个人空间zEL oUon8_
SQL> alter database open;ITPUB个人空间EcM4YQ/Rw
alter database open
W/iBH1D'?As0*ITPUB个人空间6yt$Y5aMH*J~p)m]F
ERROR at line 1:ITPUB个人空间%h1Q0~n%p:Q
ORA-01221: data file 1 is not the same file to a background process

"n"O:Q:N.``2i0SQL> alter database open resetlogs;ITPUB个人空间"?[�r!^UB1@
alter database open resetlogs
4~la(y9M`0*
R~!?8x$j6N0ERROR at line 1:
#|1F$P3c;F0ORA-01139: RESETLOGS option only valid after an incomplete database recovery

ITPUB个人空间f,\9KP0v#@
SQL> recover database using backup controlfile ;ITPUB个人空间7c;p }5Lw]L9j
ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1
#cc(Wk K2MVHl#Z0ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbf
,hk$?.j$e#jjI!p0ORA-00280: change 1445010 for thread 1 is in sequence #816

ITPUB个人空间 b0[!jc7z
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
4x0kVL,qx0autoITPUB个人空间Or,x3W(r.B_C
ORA-00308: cannot open archived log '/oradata/arch/1_816_663837713.dbf'ITPUB个人空间 x,_"`X7{
ORA-27037: unable to obtain file statusITPUB个人空间l3Ia&?zt
Linux Error: 2: No such file or directoryITPUB个人空间 f iD#s`.P sJs.{
Additional information: 3

ITPUB个人空间&lB| g7[4Kq5@a
ORA-00308: cannot open archived log '/oradata/arch/1_816_663837713.dbf'ITPUB个人空间Fgr$ATz
ORA-27037: unable to obtain file statusITPUB个人空间rn4G9r]u`j
Linux Error: 2: No such file or directoryITPUB个人空间/z Q)Rc:c6dj.P Y$B`
Additional information: 3

f.p:Z(Y�a�q1K0SQL> alter database until cancel;
A6P ] Tys�D["@�B0alter database until cancel
(k!Z}C{G1JI0                     *ITPUB个人空间? aIUbn4m+MeE
ERROR at line 1:
~,^k qI'Ag'ac0ORA-02231: missing or invalid option to ALTER DATABASE

0Suy#_'Dl4CBN�cO0SQL> recover database until cancel;
M"}nw}3K6@i0ORA-00283: recovery session canceled due to errorsITPUB个人空间yc9DXO/nD0QW&U
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Y#[sg1w;L}-k0SQL> recover database using backup controlfile ;
rOA2yW+y�GPI0ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1ITPUB个人空间N1Gd)\2U
ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbfITPUB个人空间iM3VtCG8Dx
ORA-00280: change 1445010 for thread 1 is in sequence #816

ITPUB个人空间/m0Qkv+_G3i$mf
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ITPUB个人空间,U;Y"s M9hA,~#D
cancel;
sMTg-mT�@0ORA-00308: cannot open archived log 'cancel;'
c p&D7Z6C�~+F.F5M0a0ORA-27037: unable to obtain file statusITPUB个人空间0{^8v C}qi
Linux Error: 2: No such file or directory
S1d jM2K'S n0Additional information: 3

ITPUB个人空间YCIOBZ-i)]l
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ITPUB个人空间E8P/|s4[,z$KAo
cancelITPUB个人空间9F(P4]z!A"d;}eP8F
Media recovery cancelled.ITPUB个人空间r1J*\'E*P h
SQL> alter database open;
F!qFYT;P6]0alter database openITPUB个人空间,`V6D5|"Dy
*
\dp+m-yt|8Y0ERROR at line 1:
VVJ tA+qd*l X0ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

PGlx.Bw:\0SQL> alter database resetlogs;
3DQf�sk{#P,p0alter database resetlogsITPUB个人空间,Ju.^\G1x;J
                       *
N7Qe0jQ-l0ERROR at line 1:
}2f9g']vfH;M0ORA-02231: missing or invalid option to ALTER DATABASE

ITPUB个人空间bA KA9k*lrb
SQL> alter database open resetlogs;ITPUB个人空间YQJe%x
alter database open resetlogsITPUB个人空间.C2K4E(^.Lq
*ITPUB个人空间sPaeN4m
ERROR at line 1:
r PM$poa+X'N?J0ORA-01113: file 1 needs media recovery
V_r)BvFiD? E0ORA-01110: data file 1: '/oradata/system01.dbf'

ITPUB个人空间.S3Cd'wU
SQL> recover datafile 1;ITPUB个人空间 BH$U8B|g`k
ORA-00283: recovery session canceled due to errorsITPUB个人空间l`5`?}x.H2rQ
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

ITPUB个人空间 }-q9G9o?@
SQL> recover database using backup controlfile until cancel;
z"l'rQ4n0ORA-00279: change 1445010 generated at 09/05/2008 14:18:57 needed for thread 1ITPUB个人空间'f_B;p%Ikh
ORA-00289: suggestion : /oradata/arch/1_816_663837713.dbfITPUB个人空间X h(mWZ
ORA-00280: change 1445010 for thread 1 is in sequence #816

ITPUB个人空间V$X w_K@'ck/M.DDh v
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}ITPUB个人空间c aFJ_U J
cancelITPUB个人空间Oy.G7TK`&p
Media recovery cancelled.
#u CM3rj$t$V!H2s/?z0SQL> alter database open resetlogs;

Database altered.