http://space.itpub.net/175005/viewspace-231106[@more@]重建当前incarnation 3的控制文件:
*I%_"mmm-iD$X r `ITPUB个人空间
'G
T"n
eZ Dl
_ ?Foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSQL> conn / as sysdba
E"u8p*?o$r*x4EConnected.n7d Rs.f-}"kK
gs
SQL> alter database backup controlfile to trace;
i1j4V2V FZ
Database altered.
G"j
?/GVv9fSQL> shutdown immediate
8?2S1JNH
I0}(U&]VHoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netORA-01109: database not openspace.itpub.net{5v5CE!~
space.itpub.netOMxG_&O3@2C
Database dismounted.space.itpub.net`?v!f
H u#{
{
ORACLE instance shut down.lvS]/L
SQL> startup nomountspace.itpub.net)JRzv3N:Sc
ORACLE instance started.
/n9c-?2b%[-KTotal System Global Area 285212672 bytes~~$i9V%A#A [9d"]:O)s
{l
Fixed Size 1218968 bytesfwZY4T'Pp
Variable Size 117442152 bytes
m R[7nXV7H
Database Buffers 159383552 bytes

t(HA F-S8qJ&H.JLRedo Buffers 7168000 bytesoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netwXY$x F.}&EK
SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG&WK"Y{ I?Pb!fS
MAXLOGFILES 16
6g5{
?z6Q8B8o MAXLOGMEMBERS 3(qx4{l9Yo7i0i'e:G"l
MAXDATAFILES 100LR/]4E%i|
MAXINSTANCES 8
IX5?h-Geix MAXLOGHISTORY 292space.itpub.net*d*O.eh8A/y
LOGFILE
&p'^0H+P$g[oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net GROUP 1 ([a_U$bjD?S
'/u01/app/oracle/oradata/orcl/redo01.log',ohyngw }
'/u01/app/oracle/oradata/orcl/redo01b.log'space.itpub.net[1@kB"!Imw!Q
|$cO
) SIZE 50M,
xq PjY:_ GROUP 2 (v.u7flmK7m/zW
'/u01/app/oracle/oradata/orcl/redo02.log',
_FgK4wexITPUB个人空间 '/u01/app/oracle/oradata/orcl/redo02b.log' usw7y3z
) SIZE 50M,
}Sl8O'iz$x-Nspace.itpub.net GROUP 3 (oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net6X3e lc?qe*Y[
'/u01/app/oracle/oradata/orcl/redo03.log',
"W b2g:W?ITPUB个人空间 '/u01/app/oracle/oradata/orcl/redo03b.log'oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net3A4f!]:_rC
) SIZE 50M
W0U Qipspace.itpub.net-- STANDBY LOGFILE
(q_5c U7Gnq1Doracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netDATAFILE
!U8ew+|IO
Xvoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net '/u01/app/oracle/oradata/orcl/system01.dbf',
z(f$ak)e4^$l h
B7B '/u01/app/oracle/oradata/orcl/undotbs01.dbf',

j4R;z3M9rm2^oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net '/u01/app/oracle/oradata/orcl/sysaux01.dbf',oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netDC*X
b A
EgWRt9O
'/u01/app/oracle/oradata/orcl/users01.dbf',
P!z%Q7s(e;Tm`oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net '/u01/app/oracle/oradata/orcl/example01.dbf',space.itpub.net/s[r[/qIq Jb }pF
'/u01/app/oracle/oradata/orcl/staging01.dbf'
9S~P%Z$xwCHARACTER SET AL32UTF8
|.D?g6Cx;2a|V'Gk
M
ERROR at line 1:
(shbsK(jORA-01503: CREATE CONTROLFILE failed]v%w`!X ~o
ORA-01189: file is from a different RESETLOGS than previous files

R*|4Fq!Y r7|ORA-01517: log member: '/u01/app/oracle/oradata/orcl/redo01.log'
:b ],S@!QE.Ry
$x!O-J%f*sSQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOGspace.itpub.netX:lY8rJC#G,lS
MAXLOGFILES 16
l#~WZ7SYNITPUB个人空间 MAXLOGMEMBERS 3r0R1D`B5p;Zo"U
MAXDATAFILES 100Pg#lP:['~Mbe
MAXINSTANCES 8
!y)wK7m o1Vh1~ MAXLOGHISTORY 292(w!s9v3o!l'?.o&n7n
v*?
LOGFILE
%[XtK cVs7uze!b GROUP 1 (oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netx.ZN/6^q
'/u01/app/oracle/oradata/orcl/redo01.log',3b&arI{;Z&K%o
'/u01/app/oracle/oradata/orcl/redo01b.log'
PZ3t@+S1u3Lspace.itpub.net ) SIZE 50M,
$VYt}^+gITPUB个人空间 GROUP 2 (
^6CP*j}:QM4}LX '/u01/app/oracle/oradata/orcl/redo02.log',
qb-IItOoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net '/u01/app/oracle/oradata/orcl/redo02b.log' cth%B
F9j9P5z
) SIZE 50M,oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netLJ0KD[
GROUP 3 (ITPUB个人空间 C
B3Pqt%t
'/u01/app/oracle/oradata/orcl/redo03.log',
-JzX%l3A,P/e.a
fL '/u01/app/oracle/oradata/orcl/redo03b.log'
#Ad
O }cHq7^Eoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net ) SIZE 50M
X7x$ q%i?wX@PITPUB个人空间-- STANDBY LOGFILEK(ny3oG'[8EK
T
DATAFILEoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netl&|*X.?6FZ
'/u01/app/oracle/oradata/orcl/system01.dbf',oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netE$P;{'xZ
kM
'/u01/app/oracle/oradata/orcl/undotbs01.dbf',|rsMFLW
'/u01/app/oracle/oradata/orcl/sysaux01.dbf',{$}AD2l,c
'/u01/app/oracle/oradata/orcl/users01.dbf',
CT/}d/Y
[&P Vspace.itpub.net '/u01/app/oracle/oradata/orcl/example01.dbf',
B!NR
ede"ny }8dITPUB个人空间 '/u01/app/oracle/oradata/orcl/staging01.dbf'p#S ~ wE?'@4v-R
CHARACTER SET AL32UTF8
go8IYspace.itpub.net;uQEL;@
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
f2u9Ft#DFFc Xspace.itpub.netControl file created.
/aBj7W.{2JXk1jspace.itpub.netoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netY9aw%f{@_
RMAN> run
4?4t+qg"Sk2> {5E$y$HX*uXM#AK
3> set until time='2008-03-25 13:00:00';
aRV`H3ZITPUB个人空间4> restore database;
A)qt,||A-l#WITPUB个人空间5> recover database;
;F8m&Sz
kp6> alter database open resetlogs;
Q"Cx$~o G&iRb1w7> }#~n4`6A @c
executing command: SET until clause
D(H7q5s r1RITPUB个人空间Starting restore at 2008-03-25 18:22:21&L(wd%B!tiU(s
allocated channel: ORA_DISK_13a8c4p1u].g
channel ORA_DISK_1: sid=156 devtype=DISKYD#vPU5vm
RMAN-00571: ===========================================================
#a3E,p.Rq5Q&h5oiRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
D0rMM
dt
b5kITPUB个人空间RMAN-00571: ===========================================================
fZg9G
}$Lz'sspace.itpub.netRMAN-03002: failure of restore command at 03/25/2008 18:22:21#j-IH'M&_ yC*u
RMAN-06026: some targets not found - aborting restore
#YDuAna~TITPUB个人空间RMAN-06023: no backup or copy of datafile 6 found to restore2j_6OkZv(_5{
A
RMAN-06023: no backup or copy of datafile 5 found to restore4KO7^ Cyb
RMAN-06023: no backup or copy of datafile 4 found to restorejH,Q3n0GB+y'w&CA
RMAN-06023: no backup or copy of datafile 3 found to restoreoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netI;_L?:gJ$n
RMAN-06023: no backup or copy of datafile 2 found to restore*VfY
RMAN-06023: no backup or copy of datafile 1 found to restoreg
q{jn6C7H
RMAN>w:`o3@?+iV
RMAN> exit
"N
tWQrT$Joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netITPUB个人空间@OB!H#e q{ b
Recovery Manager complete.oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netA4I`? Y cNBQ
space.itpub.netEYR2NieHz`
这个时候的datafile已经是24号恢复过来的,但并没有识别归档日志.space.itpub.netDw x
eCo

Gl4Ip/@M7_7I8?[oracle@edbjr4p2 udump]$ sqlplus /nolog
8c:y7DoN
mqXoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 25 18:24:37 20087Wp
g'tO6R'M
Copyright (c) 1982, 2005, Oracle. All rights reserved.
.J4q$Z#m!bk u
[ ~ITPUB个人空间SQL> conn / as sysdba
k;SG6N,kH?(N1Y/B-bConnected.
*ufn
}Z$aY|)Ioracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
/xIy
|'_X ~peITPUB个人空间SQL> recover database until time '2008-03-25 13:00:00' using backup controlfile;ITPUB个人空间o C'k,Xh F0|
z4v
ORA-00279: change 935505 generated at 03/24/2008 17:17:12 needed for thread 1
*YT cR0I6Ol5z3@BORA-00289: suggestion :
&t
a#N
tpZ_/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2008_03_25/o1_mf_1_19_%u_.arITPUB个人空间F%J,@nuh
m~
cITPUB个人空间:KF
_`WZ9f
ORA-00280: change 935505 for thread 1 is in sequence #19
'NVP~2G8[ I+|[
{*fqf
6`Q n.T$O|wSoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSpecify log: {=suggested | filename | AUTO | CANCEL}

@)LO,r
z,b+u7lq-IautoRV5y!z{Um2J#Q/HL
ORA-00283: recovery session canceled due to errors&E9q7vX2VtU
ORA-19906: recovery target incarnation changed during recoveryt!Y}e[H*q

*|~d2B7ecb5@7B LITPUB个人空间ORA-01112: media recovery not startedoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
rz8?};y

uTf
`Yl9_
6HK#x R*Soracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netSQL> ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2008_03_25/o1_mf_1_1_%u_.arc';
BSu&RTi:ha
ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2008_03_25/o1_mf_1_1_%u_.arc'
Yz%Q!W+X JSnITPUB个人空间*ITPUB个人空间
q~!m!j,C
ERROR at line 1:
0ZV-urSX(J2koracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netORA-00604: error occurred at recursive SQL level