ORA-38727: FLASHBACK DATABASE 需要当前的控制文件

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 open space.itpub.net{5v5CE!~
space.itpub.netOMxG_&O3@2C
Database dismounted. space.itpub.net`?v!fH u#{{
ORACLE instance shut down. lvS]/L
SQL> startup nomount space.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 bytes fwZY4T'Pp
Variable Size 117442152 bytes
m R[7nXV7H
Database Buffers 159383552 bytes
t(HA F-S8qJ&H.JLRedo Buffers 7168000 bytes oracle,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 100 LR/]4E%i|
MAXINSTANCES 8
IX5?h-Geix MAXLOGHISTORY 292 space.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+|IOXvoracle,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 AEgWRt9O
'/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 ARCHIVELOG space.itpub.netX:lY8rJC#G,lS
MAXLOGFILES 16
l#~WZ7SYNITPUB个人空间 MAXLOGMEMBERS 3 r0R1D`B5p;Zo"U
MAXDATAFILES 100 Pg#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个人空间 CB3Pqt%t
'/u01/app/oracle/oradata/orcl/redo03.log',
-JzX%l3A,P/e.a
fL '/u01/app/oracle/oradata/orcl/redo03b.log'
#AdO }cHq7^Eoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net ) SIZE 50M
X7x$ q%i?wX@PITPUB个人空间-- STANDBY LOGFILE K(ny3oG'[8EK
T
DATAFILE oracle,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;{'xZkM
'/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.net oracle,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&Szkp6> 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_1 3a8c4p1u].g
channel ORA_DISK_1: sid=156 devtype=DISK YD#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 restore 2j_6OkZv(_5{A
RMAN-06023: no backup or copy of datafile 5 found to restore 4KO7^ Cyb
RMAN-06023: no backup or copy of datafile 4 found to restore jH,Q3n0GB+y'w&CA
RMAN-06023: no backup or copy of datafile 3 found to restore oracle,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 restore g
q{jn6C7H
RMAN> w:`o3@?+iV
RMAN> exit
"N
tWQrT$Joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net ITPUB个人空间@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 2008 7Wp
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 :
&ta#NtpZ_/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2008_03_25/o1_mf_1_19_%u_.ar ITPUB个人空间F%J,@nuhm~
c ITPUB个人空间: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-Iauto RV5y!z{Um2J#Q/HL
ORA-00283: recovery session canceled due to errors &E9q7vX2VtU
ORA-19906: recovery target incarnation changed during recovery t!Y}e[H*q

*|~d2B7ecb5@7B LITPUB个人空间ORA-01112: media recovery not started oracle,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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/450962/viewspace-1032820/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/450962/viewspace-1032820/