欢迎Oracle的朋友们,通过交流和学习,互相进步.我通过这个空间把自己的实践和测试都记录下来,与你们共同分享,请多指教 最近读完的书: <<Sybex.OCP.Oracle.10g.Administration.I.Study.Guide>> <<Sybex.OCP.Oracle.10g.Administration.II.Study.Guide>> <<Version3.0-Oracle Database 10g-Administration Workshop I>> <<Version3.0-Oracle Database 10g-Administration Workshop II>> <<Oracle 9i 性能调整指南>>

用10.2.0.1RMAN全备恢复10.2.0.4数据库,通过RESTOREBACKUPPIECE,APPLYBACKUPPIECE解决

上一篇 / 下一篇  2008-06-26 08:28:51 / 天气: 阴雨 / 心情: 高兴

查看( 66 ) / 评论( 29 )
1.升级备份服务器的数据库到10.2.0.4ITPUB个人空间JF SLi?
ITPUB个人空间+H+eK}7}Fr sX
2.通过FTP把生产数据库(10.2.0.1 RAC)的RMAN的full backupset全部copy 到备份数据库上。
g H\t!v]/Kl0ITPUB个人空间 HUL%o9v!`nT
3.rman target / nocatalog
j1X)W"M;iE9EX0ITPUB个人空间i6Yq[;g
4.startup nomountITPUB个人空间 o#DT?!W;r

Bn+m!Z.o(Nn;X U05.restore controlfile from 'file_path';(从生产库考过来那个控制文件的backupset);
u5TU&Pb0C(] Z0
{"J)b'Tj8M$D6z06.检查RMAN的配置信息：
dWC n.K_.K\[9@0$ rman target / nocatalog
"x0f0@ Aj.]0Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 20 16:45:40 2008ITPUB个人空间;bjX!{0k8O
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
/?I!XZS7i'{*^ y0connected to target database: BAAN (DBID=3872779959, not open)ITPUB个人空间VuKs ^7T$@
using target database control file instead of recovery catalog
Za o?8J4}#N4tMGYcm0RMAN> show all;ITPUB个人空间Df NQ;J\P
RMAN configuration parameters are:ITPUB个人空间!j.cw?&hpP3b/k
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
u^h JS0CONFIGURE BACKUP OPTIMIZATION OFF; # defaultITPUB个人空间J!s J R?
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
:@$dd0y$^ U!u3ac0CONFIGURE CONTROLFILE AUTOBACKUP ON;ITPUB个人空间.b `2a?2sB9bh:g*C
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/RAC_BACKUP/%F';
wXr)P-or|:_"XA0CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;ITPUB个人空间~i8I*N/^2B7G&k
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultITPUB个人空间9`"`-m5m2bCC2d*\
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
j)aR;zwc0CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/RAC_BACKUP/%U';ITPUB个人空间+k~rYn~`5W
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
+v3DP?sR0CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
(W0F'`]Kg0CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultITPUB个人空间1{"y*Y(REr_;CF
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
0f K'k-f%Lr2B&`C&c0CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/ora/app/oracle/oracle/product/10.2.0/db_1/dbs/snapcf_baan.f'; # default
+Nb!]I6o-Pf0ITPUB个人空间f!qZ-Y0@F EY,b]4Y]
ITPUB个人空间Ppk{4X+S-_2~
读取控制文件中的备份信息:
h"g!ISb[n| sr0ITPUB个人空间u^])X)eV+q
RMAN> list backup summary;ITPUB个人空间"w"w K~g"ceA Zd)j

x*V B/}e*H0List of BackupsITPUB个人空间]?4Db2l&}6z$B
===============ITPUB个人空间c7~m+k7b.r
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed TagITPUB个人空间-Y.i?7TyR:H@-]
------- -- -- - ----------- --------------- ------- ------- ---------- ---ITPUB个人空间+ayb}}l
723     B  1  X DISK        16-MAR-08       1       1       NO         TAG20080316T025005ITPUB个人空间f)f8U { CO
724     B  1  X DISK        16-MAR-08       1       1       NO         TAG20080316T030314ITPUB个人空间%j W Q-VZ(BUHt
725     B  F  X DISK        16-MAR-08       1       1       NO         TAG20080316T032332ITPUB个人空间'e~1n$ux5J"P
726     B  0  X DISK        16-MAR-08       13      1       NO         TAG20080316T025006
bo7i#BN ^0727     B  0  X DISK        16-MAR-08       4       1       NO         TAG20080316T025006
-K&H2_,S(PY0728     B  0  X DISK        16-MAR-08       22      1       NO         TAG20080316T025006ITPUB个人空间L N;It @6` RjxA M
729     B  F  X DISK        16-MAR-08       1       1       NO         TAG20080316T040123
2j0pIqP#V?%|:L0730     B  1  X DISK        17-MAR-08       1       1       NO         TAG20080317T025003
up7s;nt0731     B  1  X DISK        17-MAR-08       1       1       NO         TAG20080317T025710ITPUB个人空间h!v'ok dQ M8w
732     B  F  X DISK        17-MAR-08       1       1       NO         TAG20080317T030857ITPUB个人空间)H.v~3D z)q ]
733     B  1  X DISK        18-MAR-08       1       1       NO         TAG20080318T025004ITPUB个人空间|*w a(w%zk5O aU
734     B  1  X DISK        18-MAR-08       1       1       NO         TAG20080318T025722ITPUB个人空间VZm)}8rH2]
735     B  F  X DISK        18-MAR-08       1       1       NO         TAG20080318T030908
4G#m [d4W0736     B  1  X DISK        19-MAR-08       1       1       NO         TAG20080319T025005ITPUB个人空间R3A'BWC\-s`I@
737     B  1  X DISK        19-MAR-08       1       1       NO         TAG20080319T025722
"tP;V!ZXV F!d'{ ? gYS0738     B  F  X DISK        19-MAR-08       1       1       NO         TAG20080319T030909
9E(l3Y1Sf k^0739     B  1  X DISK        20-MAR-08       1       1       NO         TAG20080320T025005
{Rr)u+d"@:U0740     B  1  X DISK        20-MAR-08       1       1       NO         TAG20080320T025722
i@M.u%zbQ0741     B  F  X DISK        20-MAR-08       1       1       NO         TAG20080320T030909ITPUB个人空间"MG#i|\;x*L3?)U
742     B  1  X DISK        21-MAR-08       1       1       NO         TAG20080321T025004ITPUB个人空间'RI)]i6u:TJ*X
743     B  1  X DISK        21-MAR-08       1       1       NO         TAG20080321T025722ITPUB个人空间IRW {+p
744     B  F  X DISK        21-MAR-08       1       1       NO         TAG20080321T030908
k1W'oj O Z0745     B  A  X DISK        21-MAR-08       1       1       NO         TAG20080321T140135ITPUB个人空间Sp-qLsv%q
746     B  A  X DISK        21-MAR-08       1       1       NO         TAG20080321T140135ITPUB个人空间:g ]M$_/UOw6^
747     B  A  X DISK        21-MAR-08       1       1       NO         TAG20080321T140135
9?-z\dW6U(Y rR0748     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T140135
Q9R5`c)_"Y4\e"k0749     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T140135
uf:T8d Scv6| Y0750     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T140135
#Q*l,` E8IV{8{0751     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T140135
'Gl aJ9o2hUZ0752     B  F  A DISK        21-MAR-08       1       1       NO         TAG20080321T142855
}~ Pb#zk'Xz#}0753     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145058ITPUB个人空间a DE2|%R(qU Y
754     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145058ITPUB个人空间\ KK4SU
755     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145058ITPUB个人空间(K/WJ5lH
756     B  F  A DISK        21-MAR-08       1       1       NO         TAG20080321T145104ITPUB个人空间)F c,s&S#V*}&M
757     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145751ITPUB个人空间#|DM9g2`#NF7c9M:I
758     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145751ITPUB个人空间0B9[7S\*^F!D
759     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145751
#K\;@y,sJ%c(l9K?%j0760     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145751ITPUB个人空间VN[7d)j ^:h3h'eO
761     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145751ITPUB个人空间9n/_ moqZ
762     B  A  A DISK        21-MAR-08       1       1       NO         TAG20080321T145751
5V~^%h#QUK0763     B  F  A DISK        21-MAR-08       1       1       NO         TAG20080321T152424
? Vus(X$P Nh2dP4_G0764     B  1  A DISK        22-MAR-08       1       1       NO         TAG20080322T025005
F j4l Ux.a{$FII6M0765     B  1  A DISK        22-MAR-08       1       1       NO         TAG20080322T025722
BXv&CA0766     B  F  A DISK        22-MAR-08       1       1       NO         TAG20080322T030909ITPUB个人空间4G)My SR6P8w h
767     B  1  A DISK        23-MAR-08       1       1       NO         TAG20080323T025005
)kq6R|I"H!dF0768     B  1  A DISK        23-MAR-08       1       1       NO         TAG20080323T025712
U)U)vAHCr0769     B  F  A DISK        23-MAR-08       1       1       NO         TAG20080323T030859ITPUB个人空间*v6^hIaLK"gq6ra
770     B  1  A DISK        24-MAR-08       1       1       NO         TAG20080324T025004ITPUB个人空间turm_%M c2v
771     B  1  A DISK        24-MAR-08       1       1       NO         TAG20080324T025711ITPUB个人空间+N!p9F7Z H.G _
772     B  F  A DISK        24-MAR-08       1       1       NO         TAG20080324T030907
n DYZF(B&n0773     B  1  A DISK        25-MAR-08       1       1       NO         TAG20080325T025005
!X#jSz6}@5}R!P0774     B  1  A DISK        25-MAR-08       1       1       NO         TAG20080325T025722ITPUB个人空间3W]9wTu{
775     B  F  A DISK        25-MAR-08       1       1       NO         TAG20080325T030909
l]b5`1V#NH+f Y.{0776     B  1  A DISK        26-MAR-08       1       1       NO         TAG20080326T025005ITPUB个人空间cFh.a/A|
777     B  1  A DISK        26-MAR-08       1       1       NO         TAG20080326T025733ITPUB个人空间|Yl7s!^yb
778     B  F  A DISK        26-MAR-08       1       1       NO         TAG20080326T030929
*Sc1V6U1NN1\/N0779     B  1  A DISK        27-MAR-08       1       1       NO         TAG20080327T025006ITPUB个人空间R|'UNE(x(Uy(Ec
780     B  1  A DISK        27-MAR-08       1       1       NO         TAG20080327T025733ITPUB个人空间(v7wZ@#S,t
781     B  F  A DISK        27-MAR-08       1       1       NO         TAG20080327T030930ITPUB个人空间Ms"T:_2ktW8U
782     B  1  A DISK        28-MAR-08       1       1       NO         TAG20080328T025005
W9?c&o Aqof0783     B  1  A DISK        28-MAR-08       1       1       NO         TAG20080328T025723
6d P EywVF%U0784     B  F  A DISK        28-MAR-08       1       1       NO         TAG20080328T030909
D0zZW:d0785     B  1  A DISK        29-MAR-08       1       1       NO         TAG20080329T025006
2q:t[$|T,[yw0786     B  1  A DISK        29-MAR-08       1       1       NO         TAG20080329T025724ITPUB个人空间6F2L)n~%SQ k3A
787     B  F  A DISK        29-MAR-08       1       1       NO         TAG20080329T030911ITPUB个人空间*wp anq~^
788     B  1  A DISK        30-MAR-08       1       1       NO         TAG20080330T025005ITPUB个人空间zXr4_8fp
789     B  1  A DISK        30-MAR-08       1       1       NO         TAG20080330T025722
P!^7F7Kp7r1g-H"z7Tr6o0790     B  F  A DISK        30-MAR-08       1       1       NO         TAG20080330T030919
.MhFB!dH1[0791     B  1  A DISK        31-MAR-08       1       1       NO         TAG20080331T025003
:l%XP"GE s1gr0792     B  1  A DISK        31-MAR-08       1       1       NO         TAG20080331T025730ITPUB个人空间4Z9n l4{+eh&B e DD V
793     B  F  A DISK        31-MAR-08       1       1       NO         TAG20080331T030927ITPUB个人空间 y4Y5Bd2duW1yj$G
794     B  1  A DISK        01-APR-08       1       1       NO         TAG20080401T025006
"E6fW7~6I7R0795     B  1  A DISK        01-APR-08       1       1       NO         TAG20080401T025724ITPUB个人空间-c @,y7i8d
796     B  F  A DISK        01-APR-08       1       1       NO         TAG20080401T030921
YB$skbp7k0797     B  1  A DISK        02-APR-08       1       1       NO         TAG20080402T025005
Dau _ t)^_)N"\ c8T0798     B  1  A DISK        02-APR-08       1       1       NO         TAG20080402T025722
{d[\ LP6p,nW r0799     B  F  A DISK        02-APR-08       1       1       NO         TAG20080402T030909
PND[3i"vf0800     B  1  A DISK        03-APR-08       1       1       NO         TAG20080403T025005
b%vRBp.J_'M0801     B  1  A DISK        03-APR-08       1       1       NO         TAG20080403T025712
,D&TH-\ z]T3P0802     B  F  A DISK        03-APR-08       1       1       NO         TAG20080403T030859
r3V}GeH0803     B  1  A DISK        04-APR-08       1       1       NO         TAG20080404T025006
0Q5dO#S u0804     B  1  A DISK        04-APR-08       1       1       NO         TAG20080404T025723
"B6S+b]jGN0805     B  F  A DISK        04-APR-08       1       1       NO         TAG20080404T030910
&wfX:WL],[0HCQ p0806     B  1  A DISK        05-APR-08       1       1       NO         TAG20080405T025005
sYYXm {/T0807     B  1  A DISK        05-APR-08       1       1       NO         TAG20080405T025712
c+j W/Vf1a0808     B  F  A DISK        05-APR-08       1       1       NO         TAG20080405T030859
:}?@,uto KxP3k0809     B  1  A DISK        06-APR-08       1       1       NO         TAG20080406T025004
k]Dmz F0810     B  1  A DISK        06-APR-08       1       1       NO         TAG20080406T025711
\ M#|o*F0811     B  F  A DISK        06-APR-08       1       1       NO         TAG20080406T030858ITPUB个人空间/B$I7]E2x+w'_
812     B  1  A DISK        07-APR-08       1       1       NO         TAG20080407T025003
!o:^pz)VY0813     B  1  A DISK        07-APR-08       1       1       NO         TAG20080407T025721
2Q%fZ%L{5q0814     B  F  A DISK        07-APR-08       1       1       NO         TAG20080407T030917ITPUB个人空间WEtd8]u1mb}k!R(hn
815     B  1  A DISK        08-APR-08       1       1       NO         TAG20080408T025006
-V\l x%D0_pU0816     B  1  A DISK        08-APR-08       1       1       NO         TAG20080408T025723
-j;e"})z2w#ty0817     B  F  A DISK        08-APR-08       1       1       NO         TAG20080408T030909
F%]l`-EuP#j^2_0818     B  1  A DISK        09-APR-08       1       1       NO         TAG20080409T025006ITPUB个人空间nz4g)`B'S5d
819     B  1  A DISK        09-APR-08       1       1       NO         TAG20080409T025723
n0J&^-Irpt"K%r0820     B  F  A DISK        09-APR-08       1       1       NO         TAG20080409T030910ITPUB个人空间t*NlX.W'_B
821     B  1  A DISK        10-APR-08       1       1       NO         TAG20080410T025005ITPUB个人空间cR!B{"N6aoa9q
822     B  1  A DISK        10-APR-08       1       1       NO         TAG20080410T025722ITPUB个人空间 O'n:QPI?
823     B  F  A DISK        10-APR-08       1       1       NO         TAG20080410T030909ITPUB个人空间{z-|*ZjBPS'NY
824     B  1  A DISK        11-APR-08       1       1       NO         TAG20080411T025005
S.|&@%`y0825     B  1  A DISK        11-APR-08       1       1       NO         TAG20080411T025723ITPUB个人空间vxZOwA
826     B  F  A DISK        11-APR-08       1       1       NO         TAG20080411T030920
E(o*ZOc0827     B  1  A DISK        12-APR-08       1       1       NO         TAG20080412T025005
+S4E&z#sR2z%M0828     B  1  A DISK        12-APR-08       1       1       NO         TAG20080412T025723ITPUB个人空间wP6Bd*hp$O
829     B  F  A DISK        12-APR-08       1       1       NO         TAG20080412T030919ITPUB个人空间9KPhn~L6fdD
830     B  1  A DISK        13-APR-08       1       1       NO         TAG20080413T025005
y KAE&QC8Iq0831     B  1  A DISK        13-APR-08       1       1       NO         TAG20080413T025722
f+Ar zj/[6Z$E6Yg0832     B  F  A DISK        13-APR-08       1       1       NO         TAG20080413T030909
7{)KribH$@'y S0833     B  1  A DISK        14-APR-08       1       1       NO         TAG20080414T025004
q"d:q&O Tw1Y0834     B  1  A DISK        14-APR-08       1       1       NO         TAG20080414T025721
'o'm mTB$e0835     B  F  A DISK        14-APR-08       1       1       NO         TAG20080414T030908ITPUB个人空间~Dwl&[ Fud
836     B  1  A DISK        15-APR-08       1       1       NO         TAG20080415T025005
'Ih!yWa;UFU!e0837     B  1  A DISK        15-APR-08       1       1       NO         TAG20080415T025723ITPUB个人空间#t,g a$q L#f};~
838     B  F  A DISK        15-APR-08       1       1       NO         TAG20080415T030919ITPUB个人空间3L;]'[(qNMs
839     B  0  A DISK        16-APR-08       13      1       NO         TAG20080416T025006
&c#rr(Y c8}#Z&o+s0840     B  0  A DISK        16-APR-08       4       1       NO         TAG20080416T025006ITPUB个人空间+P3US#^y]#T[
841     B  0  A DISK        16-APR-08       22      1       NO         TAG20080416T025006ITPUB个人空间8P9S"K2g#s.x0h!{7Q
ITPUB个人空间f;@M)w-GHj@
尝试还原backupset 到新的datafile 位置ITPUB个人空间h6{0W9Fb
RMAN> runITPUB个人空间0[+I#M`*\
2> {ITPUB个人空间5~3U:z5kSd2QB;N
3> set newname for datafile 1 to '/RAC_BACKUP/baan/system01.dbf';
J U,sl{y&y-e"H04> set newname for datafile 2 to '/RAC_BACKUP/baan/undotbs1.dbf';
7gj ^"_GA3H4X)b05> set newname for datafile 3 to '/RAC_BACKUP/baan/sysaux.dbf';ITPUB个人空间-\y%IJD
6> set newname for datafile 4 to '/RAC_BACKUP/baan/undotbs2.dbf';
U7k!?*S'h C? z0O/{07> set newname for datafile 5 to '/RAC_BACKUP/baan/users.dbf';
m2`bjQ(Z:Af3W"R08> set newname for datafile 6 to '/RAC_BACKUP/baan/baanidx.dbf';ITPUB个人空间)Y7?v^-rV
9> set newname for datafile 7 to '/RAC_BACKUP/baan/baandb.dbf';
c7LI'Wbt+o010> set newname for datafile 8 to '/RAC_BACKUP/baan/statspack.dbf';
Z5o/W~,`/NN@011> set newname for datafile 9 to '/RAC_BACKUP/baan/system02.dbf';ITPUB个人空间P |/RPq e+S"t
12> restore database;
$H5]KYvo7sR013> }ITPUB个人空间S)y){.T-j%t
ITPUB个人空间H3@ L+JAR&H2e"D C_
出现ora-600错误,查看trace文件,出现异步IO的问题
t?*f w5P;iQ-z dQ0ITPUB个人空间/p L_6Yc#ON#{~
ora/app/oracle/admin/baan/udump/baan_ora_8175.trc
bZoiH8Pq,z0Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionITPUB个人空间3KT f:Y+T9oy
With the Partitioning, OLAP, Data Mining and Real Application Testing options
J0w7X-U jT0ORACLE_HOME = /ora/app/oracle/oracle/product/10.2.0/db_1
oF6]N R:v0System name:    HP-UXITPUB个人空间^9v+v&fsM"M:D
Node name:      astronhpITPUB个人空间#CgP8cpYz!b
Release:        B.11.23ITPUB个人空间-Q D%yv5x pe&A
Version:        UITPUB个人空间)V(Et)hJ/v6z-q!d
Machine:        ia64
2]/J7J%Y6a-be0Instance name: baanITPUB个人空间 zG%gD B#N
Redo thread mounted by this instance: 1
_3IOCQA B[i0Oracle process number: 0
Bu@,A#w2p0Unix process pid: 8175, image: [email=oracle@astronhp]oracle@astronhp[/email]
p B8p.j8r t0Ioctl ASYNC_CONFIG error, errno = 1
9Zv$s8hGQK8~"r1l0*** ACTION NAME0000064 STARTED62) 2008-06-20 18:12:07.885
'gw!{E`]yR0*** MODULE NAME[email=rman@astronhp]rman@astronhp[/email] (TNS V1-V3)) 2008-06-20 18:12:07.885ITPUB个人空间qEu CW k*N ? nq8n
*** SERVICE NAME) 2008-06-20 18:12:07.885ITPUB个人空间5_x;@j(_:v.iEa
*** SESSION ID1971.17) 2008-06-20 18:12:07.885ITPUB个人空间#_a4{a"g1G`0B"g
*** 2008-06-20 18:12:07.885
D7F Cu.g*k%u0ksedmp: internal or fatal errorITPUB个人空间z'T)S M*P,t1u [Q
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
E"i Z;U9w+Dl(b"KVi0
7@b.M)eH)k)@O@0ITPUB个人空间o$z lP#u Q
查看metalink,按metalink的说法解决这个异步IO的问题,但是这个ora-600错误还存在:
p#^%r d&w }3F Ic0
-RQmPVDM!Q0{^0主题:  How to disable asynch_io on HP to avoid Ioctl Async_config Error Errno = 1ITPUB个人空间4w$r8@tcMe
  文档 ID:  注释:302801.1 类型:  HOWTOITPUB个人空间&O2QK6kh+mv
  上次修订日期:  21-FEB-2008 状态:  PUBLISHED
{Qz^/Q5p0l {%[ Z|0In this Document
ukxv:v,?N0  Goal
3}5jAY&TD!x6t#du0  Solution
|qpSDP,U0`d j8S\0  References
3|!Z/gl1wI ?Z0
5oA^y@v:HQ8K0--------------------------------------------------------------------------------ITPUB个人空间3lS2Y$l'su9@"q [

+fg O5Z$k0Applies to:
)d o uU/r$t%joC3|0Oracle Server - Enterprise Edition - Version:ITPUB个人空间*j M7y#Rjxx!K*R
HP-UX Itanium
0| U3ag x2j x0HP-UX PA-RISC (64-bit)
#`([K Zr*s@F0GoalITPUB个人空间q+?jk0``~NE
How to disable async_io on Oracle in HP-UX to avoid this message in trace file:
Vq)v%NW#e ~-Br0Ioctl ASYNC_CONFIG error, errno = 1
3gK[P cn\ U0ITPUB个人空间rck jH,|4I
SolutionITPUB个人空间.|0|a/^Y\]
Oracle (for HP only) always uses async I/O regardless of the value of init settings
jb*c(`2NR3Z4ty/u:UaV0(disk_asynch_io=FALSE and filesystemio_options=none).
#I.fF5S'L0The  parameter filesystemio_options=none doesn't work.
:?%`i1V)}`$K)w0Oracle always opens /dev/async successfully only if the /dev/async HP-UXITPUB个人空间/|1` H-H!fi0HY
device driver is properly configured for read and write. This is irrespective
u_"^3m.X1t}p3fb0of whether the DISK_ASYNC_IO parm is set to TRUE.ITPUB个人空间&^i.^&[{9d
In 9.2 version, to  inactivate ASYNCH_IO with Oracle , workaround is:ITPUB个人空间%T/v'K8x^.n j]
   chown bin:bin /dev/asyncITPUB个人空间 i}*K pyFs
   chmod 660 /dev/async
x8H!dX`K&M0Note:
(J'wm6m+pWD%B0This may impact other applications that wish to use asynch I/O
/n3S4V"mTX5@0Grant dba group the MLOCK priv to avoid the Ioctl ASYNC_CONFIG trace file errors:ITPUB个人空间9q;Wi-v9{6kEN_:g M
(1) # /usr/sbin/setprivgrp dba  MLOCKITPUB个人空间)so8EGZM
(2) # vi /etc/privgroupITPUB个人空间~L vsP${2X
This should contain dba MLOCK RTSCHED RTPRIO
O'y6I,b6UHl+ni0(3) # cat /etc/privgroupITPUB个人空间^,A!T~u
dba MLOCK RTSCHED RTPRIO
a8G7~Hc)]!F]xo0
_.H2E N/o+A MH#|0Starting with Oracle 10.2, these settings will stop the tracing:
*A ?8DK ii@0disk_asynch_io=FALSE
"}(ar{*rSW b(]|0filesystemio_options=none
F4i Tx]F8n y.w&Q0# setprivgrp dba MLOCKITPUB个人空间cft,f8U8i
# vi /etc/privgroupITPUB个人空间GJ B.lM5z:~xO`
"/etc/privgroup" [New file]
k4g}"nLT f"M0dba MLOCK RTSCHED RTPRIO   
r+Lmx~7X[V0# ls |grep as
'M\Jo V(L5k0async
{S\*u_^0asyncdsk
l8\Zz:v0# ll |grep asITPUB个人空间:UuW&f i`+BR7u
crw-rw-rw-   1 bin        bin        101 0x000000 May 31  2007 asyncITPUB个人空间OH.nN#} nb
crw-rw-rw-   1 bin        bin        101 0x000000 May 31  2007 asyncdskITPUB个人空间L2hL:Z v^|(?
ITPUB个人空间IW5r3N_8Wy R9v u
[本帖最后由 赵宇 于 2008-6-25 14:13 编辑]

论坛模式 推荐 收藏 分享给好友 推荐到圈子 管理

TAG:

赵宇的DBA记事本 赵宇 发布于2008-06-23 15:30:15
在trace文件中看到这样的信息:c-3872779959-20080321-00是从RAC那边考过来的rman备份的控制文件
STjve6r,PNspace.itpub.netITPUB个人空间
he~;n6o
        Repeat 101 times
&F*o~ZMZ'uoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net6000000000031BF0 00000002 02000000 0B6B6765 6164655F  [.........kgeade_]
e7X!M6~+f G#l}6000000000031C00 69735F30 2F632D33 38373237 37393935  [is_0/c-387277995]space.itpub.net ?9~8ftc"Tv*j2_0E
6000000000031C10 392D3230 30383033 32312D30 30000000  [9-20080321-00...]5WB'g+}6K,wV)P        {Xv$Z)UG
6000000000031C20 00000000 00000000 00000000 00000000  [................]space.itpub.net;V$OLUs+a0Km'r
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
I.}:X9T*z1U_U)_T^*E$u
        Repeat 98 times
7t,Y^7Qln6000000000031BF0 00000002 02000000 0B6B6765 6164655F  [.........kgeade_]
/k#|r?C%y&dW6000000000031C00 69735F30 5F424143 4B55505F 52455354  [is_0_BACKUP_REST]
        Q;j,x[#t^.d)H6000000000031C10 4F524522 2C200100 00000433 31383002  [ORE", .....3180.]
U?&c+MVDbITPUB个人空间6000000000031C20 0000001D 22535953 2E582444 424D535F  [...."SYS.X$DBMS_]
{2kJk!c(}{;\*AITPUB个人空间6000000000031C30 4241434B 55505F52 4553544F 5245222C  [BACKUP_RESTORE",]Yw!jDN`m7T|
6000000000031C40 20010000 00043332 30340200 00000B6B  [ .....3204.....k]fN\N]2GB7w
6000000000031C50 67656164 655F6973 5F302F63 2D333837  [geade_is_0/c-387]
Ripa.}afd&\~D6000000000031C60 32373739 3935392D 32303038 30333231  [2779959-20080321]
K7| yA6|e6000000000031C70 2D303000 00000000 00000000 00000000  [-00.............]
Ff8P9gI;XI\ ] u6000000000031C80 00000000 00000000 00000000 00000000  [................] o/b,^Q)u9px |H F

2Ql.d gX\ W!G,xspace.itpub.net开始改重做日志路径，虽然报了ora-600错误，但是路径还是修改成功了B5p\$k,zHq,x
SQL> alter database rename file '+MYASM/baan/onlinelog/group_1.280.628807911' tooracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netf U(^*ct&J
  2  '/ora/app/oracle/oradata/baan/redo1a.log';
,X8~7ii4Z;v*calter database rename file '+MYASM/baan/onlinelog/group_1.280.628807911' to
{ TM7YKLF,T$]oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net*oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netn{i-\%l^        Q%t4f
ERROR at line 1:
4H@*j9?PORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
J Pa'U\&U_"jf GQL> select * from v$logfile order by group#;
)UTs~#v
O'f-MITPUB个人空间rows will be truncated
lL7BS*h]
]        v2vjO\v&Vspace.itpub.net    GROUP# STATUS  TYPE    MEMBER
:w_"VS%q*P8r{H---------- ------- ------- -------------------------------------------------------------------------
D` YQ @p
nspace.itpub.net         1         ONLINE  /ora/app/oracle/oradata/baan/redo1a.log
i#QJ?d4G2T3kspace.itpub.net         1         ONLINE  +MYASM/baan/onlinelog/group_1.284.628809135(}a7K9Z6c|Dp(D
         2         ONLINE  +MYASM/baan/onlinelog/group_2.283.628808345
4[W3I&Y,RC/~]{         2         ONLINE  +MYASM/baan/onlinelog/group_2.281.628807931,@p-K7tJ
         3         ONLINE  +MYASM/baan/onlinelog/group_3.268.628808793
NV$loaX&?y;asfITPUB个人空间         3         ONLINE  +MYASM/baan/onlinelog/group_3.285.628809157
*S
EU/a
w
v
L         4         ONLINE  +MYASM/baan/onlinelog/group_4.264.628808849yH6J#\y/DKY;S)q
         4         ONLINE  +MYASM/baan/onlinelog/group_4.286.628809181ITPUB个人空间h
s#k'D3M
         5         ONLINE  +MYASM/baan/onlinelog/group_5.287.628809201
s;\#A(DUoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net         5         ONLINE  +MYASM/baan/onlinelog/group_5.282.628808889"E        D u n4zqe
         7         ONLINE  +MYASM/baan/onlinelog/group_7.288.628809251oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net;[@.~`)zy-P j p!m
    GROUP# STATUS  TYPE    MEMBER
PMw@(u4k
w---------- ------- ------- -------------------------------------------------------------------------ITPUB个人空间y {gnY
         7         ONLINE  +MYASM/baan/onlinelog/log7.ora
yf5G%oTY         8         ONLINE  +MYASM/baan/onlinelog/log8.oraoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net/F8v-@.L        L2zq!Am1v|
         8         ONLINE  +MYASM/baan/onlinelog/group_8.289.628809271oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net1}
}/j8` \^t
         9         ONLINE  +MYASM/baan/onlinelog/group_9.290.628808517
!_/{}B
?-Q*TITPUB个人空间         9         ONLINE  +MYASM/baan/onlinelog/log9.ora
_%j[(R:espace.itpub.net        10         ONLINE  +MYASM/baan/onlinelog/log10.ora
c&?Z+]Jspace.itpub.net        10         ONLINE  +MYASM/baan/onlinelog/group_10.291.628809285
t;oOl(VG}        11         ONLINE  +MYASM/baan/onlinelog/group_11.292.628809315
lp3w,@+oJkg @~Q
        11         ONLINE  +MYASM/baan/onlinelog/log11.ora
%j2^0n[}q7uToracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net20 rows selected.(e"d X^4~5\7Y
:F6?*v,w0N
/GhANJ(i[,L
在rman中做crosscheck的时候,出现下面的错误:
C~i2Qyspace.itpub.net
U0Rl#u'yZ*NITPUB个人空间/ora/app/oracle/admin/baan/bdump/baan_dbw0_27403.trc#x^
?|.|BA
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionITPUB个人空间T4O{e
?5cr-G J8Ef
With the Partitioning, OLAP, Data Mining and Real Application Testing options
0l6gTqS
G$wC PORACLE_HOME = /ora/app/oracle/oracle/product/10.2.0/db_1K:b&LYJ~-v GI'{Rn
System name:    HP-UXspace.itpub.net2sA/m _}f$_
Node name:      astronhp
[$pj t,vSspace.itpub.netRelease:        B.11.23
ZARRz(QbKF,pspace.itpub.netVersion:        U
9{%xy"R+M
_space.itpub.netMachine:        ia64 Z[        i4]8| iO7V
Instance name: baan
!b$^~Dtaw0j9~ITPUB个人空间Redo thread mounted by this instance: 1

u3f;zZi$x2U\^Oracle process number: 5
NCh9s4V AUnix process pid: 27403, image: [email=oracle@astronhp]oracle@astronhp[/email] (DBW0)
.^        c)CD:T:G5?oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net*** 2008-06-23 09:58:37.835]*~E[x^8U/O}
*** SERVICE NAME) 2008-06-23 09:58:37.835
8Rj t
Ty5w.Mo!Axgoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net*** SESSION ID1982.1) 2008-06-23 09:58:37.835
[.T'VBSX%N,Hp2008-06-23 09:58:37.835: [  OCROSD]utgdv:2cr loc file  cannot  be opened:^k.I3g8HfMKh
2008-06-23 09:58:37.835: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
-^&mg#Cuv^ E%ospace.itpub.net2008-06-23 09:58:37.836: [  OCRRAW]proprinit: Could not open raw device space.itpub.netD+k2SCw
Q lof!G
2008-06-23 09:58:37.836: [ default]a_init:7!: Backend init unsuccessful : [33]
fZ1V-m5p
j.IN        @{,A\oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net2008-06-23 09:58:37.836: [ CSSCLNT]clsssinit: error(33 ) in OCR initialization
X-cs
c&\qkgxgncin: CLSS init failed with status 21ITPUB个人空间 J Pk;k(}.O
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] G h@?aIv\
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [+MYASM/baan
%B4{Dy,eworacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net/datafile/system.266.592727231]uo mU%F$H'[$i
ORA-17503: Message 17503 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [+MYASM/baa
+GH$o |l"cn/datafile/system.266.592727231]3v2\+SQ$gT
ORA-15001: Message 15001 not found; No message file for product=RDBMS, facility=ORA; arguments: [MYASM]space.itpub.net'MA p-Uj
ORA-15077: Message 15077 not found; No message file for product=RDBMS, facility=ORAspace.itpub.netXwk|kFN ^1zS
ORA-29701: Message 29701 not found; No message file for product=RDBMS, facility=ORAN&x6d CxE
2008-06-23 09:58:37.838: [  OCROSD]utgdv:2cr loc file  cannot  be openedspace.itpub.netQ%o5Ee4c"g
2008-06-23 09:58:37.838: [  OCROSD]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
赵宇的DBA记事本 赵宇 发布于2008-06-23 15:40:19
现在的主要问题是,不能crosscheck.尝试了用RMAN的debug跟踪:
h`&s.r8jUW$ rman target / debug trace /ora/app/oracle/admin/baan/udump/trace.log
"oKur)t7p7V,i:oDoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netRecovery Manager: Release 10.2.0.4.0 - Production on Mon Jun 23 15:34:24 2008
*AsmA:L)U-C4YM8K
c_5pspace.itpub.netCopyright (c) 1982, 2007, Oracle.  All rights reserved..e;u8f"A.[~G(z
RMAN-06568: connected to target database: BAAN (DBID=3872779959, not open)
v_d)?-q7vITPUB个人空间RMAN> crosscheck backup;
an,i;c N'H#r)yspace.itpub.netRMAN-03090: Starting implicit crosscheck backup at 23-JUN-08
p"CFiu'Z*[oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netRMAN-06009: using target database control file instead of recovery catalogspace.itpub.net,W{-g:h!qKG @U
RMAN-08030: allocated channel: ORA_DISK_1str+Je~
RMAN-08500: channel ORA_DISK_1: sid=1971 devtype=DISK
o7y#M3f8j {@ITPUB个人空间RMAN-08030: allocated channel: ORA_DISK_2
t\9[ mGP IITPUB个人空间RMAN-08500: channel ORA_DISK_2: sid=1970 devtype=DISK
(e]~Bvr4\oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netRMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
yK+x"A6^Y\2sRMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []
{3^"Ibjc
fp2[$_V{7Iw查看trace.log:
M2i8A5X
yb&jZDBGMISC:  Node # 1 [15:34:36.032]
Zb}W,roracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netDBGMISC:  crosscheck
7F] ex!SzDBGMISC:    1 backupspace.itpub.netOk~M:HY9|%Z0Y*G0a
DBGMISC:        1 DBASE
;S        Q-ucU5{0f9Ospace.itpub.netDBGMISC:        2 ALSPEC
V9J[/}b^'LNDBGMISC:            1 ALL
6ZKG:} ]#o)g8b-[DBGMISC:        3 CURCFITPUB个人空间$g$J_9R(v g@w
DBGMISC:            1 NIL U$R4S'y}6[qn!J9]
DBGMISC:        4 SPFILE$BVDMJXmfT+~8g
DBGMISC:            1 NILITPUB个人空间fF@$`
]SM
DBGMISC:        5 Standby Controlfile
s5IONm:hf#Hspace.itpub.netDBGMISC:            1 NIL
@S`B|0tXq+_{Zspace.itpub.netDBGMISC:  ENTERED krmice [15:34:36.035]
cP/v#FKDBGMISC:   command to be compiled and executed is: crosscheck  [15:34:36.035] (krmice)
A%j+Lw6] qUDBGMISC:   command after this command is: NONE  [15:34:36.035] (krmice)
-GEN"m!o?!lDBGMISC:   current incarnation does not matter for crosscheck [15:34:36.036] (krmice)
7b nY3J\/jl uITPUB个人空间DBGSQL:    EXEC SQL AT TARGET select decode(open_mode,'MOUNTED',0,'READ WRITE',1,'READ ONLY',1,0) into :b1  fro
+[eR,?{zspace.itpub.netm v$database  [15:34:36.036]"~ h9r9CT_6fy
DBGSQL:       sqlcode=0 [15:34:36.037]
%IrO}&H)`6QL^kDBGSQL:          :b1 = 0aX|        eD;~L
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net"P;D"Y:]
aG
D
Eb}
DBGMISC:     EXITED krmknmtr with status implicit crosscheck backup [15:34:43.759] elapsed time [00:00:00:05.91a6i6l:nR-^9g^/\
6]
's#y2q\'Fn;m:Q
E+hDBGMISC:     krmkdps: this_reset_scn=247810974 [15:34:43.760]
LO(J4j1QDBGMISC:     krmkdps: this_reset_time=05-DEC-07 [15:34:43.760]
Jd7X$}BDBGMISC:     krmkdps: untilSCN= [15:34:43.761]
E.p^/DJ`J.[space.itpub.netDBGMISC:     krmkdps: untilTime= [15:34:43.761]oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netCn'z;au,i d$t
DBGMISC:     krmkdps: getRA_completedAfter= [15:34:43.761]
,K L$h1Zi;b;a        jDBGMISC:     krmkdps: getRA_completedBefore= [15:34:43.762]oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net oBM8f{
DBGMISC:     krmkdps: getRA_likePattern= [15:34:43.762]KP.L,fWhyn9n8q
DBGMISC:     krmkdps: getRA_containerMask=15 [15:34:43.762]
Ns#N[!]q P.joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netDBGMISC:     krmkdps: getRA_actionMask=63 [15:34:43.763]!}_M(~q*Z$o:A
{
DBGMISC:     krmkdps: computeRA_allRecords0 [15:34:43.763]space.itpub.netT/^#Bj1t$AYd
DBGMISC:     krmkdps: computeRA_fullBackups=1 [15:34:43.763]
T*scF6`ITPUB个人空间DBGMISC:     krmkdps: allIncarnations=0 [15:34:43.764],OZ7|D1]s
Kc

"dm
d_
F aITPUB个人空间RMAN-03002: failure of crosscheck command at 06/23/2008 15:35:13space.itpub.netfc_g^2~NzR
RMAN-12005: error during channel cleanup
tuZLDF)w~RMAN-10035: exception raised in RPC:
c%DhJg0{ Moracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netRMAN-10031: RPC Error: ORA-03114  occurred during call to DBMS_BACKUP_RESTORE.BACKUPCANCEL
waityou81发布于2008-06-23 16:40:45
看来主要是用RMAN时有ORA-600.可以不用RMAN来避免直接使用begin backup/endbackup然后copy datafile->compress datafile->FTP到target.然后就是startup upgrade,运行升级脚本,然后startup normal
waityou81发布于2008-06-23 16:42:08
source库上用的ASM?
赵宇的DBA记事本 赵宇 发布于2008-06-23 16:46:19

QUOTE:

原帖由 waityou81 于 2008-6-23 16:42 发表
1B};gb#oDnITPUB个人空间source库上用的ASM?
space.itpub.netWUn&A6Lu
x"I
是的
赵宇的DBA记事本 赵宇 发布于2008-06-23 16:46:55

QUOTE:

原帖由 waityou81 于 2008-6-23 16:40 发表
(E;@6})`$z%U看来主要是用RMAN时有ORA-600.可以不用RMAN来避免直接使用begin backup/endbackup然后copy datafile->compress datafile->FTP到target.然后就是startup upgrade,运行升级脚本,然后startup normal
space.itpub.netH+p'E etSL?;x
5W9N6NB&{Xm

)M:N1S8Cd?+_ aspace.itpub.net因为RMAN每天备份都要用,直接把RMAN备份考过来做恢复是最省事的
赵宇的DBA记事本 赵宇 发布于2008-06-24 09:49:54
今天用rman做report schema,又看了一下debug  log:
;O t8N4ly        yPH foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net6g K        p y,W2Ka9h3\c        q;X
DBGPLSQL:    channel ORA_DISK_1:  force: 0 [09:02:50.870] (change)bZ.Js qeYN\
DBGRPC:      krmxrpc: xc=6917529027646109448 kpurpc2 rc=600 db=target
a0?J fZyproc=DBMS_BACKUP_RESTORE.VALIDATEBACKUPPIECE*G!C&rL c[
DBGRPC:      krmxrpc: xc=6917529027646109448 chid=ORA_DISK_1 increment rpc count=65ITPUB个人空间i%V9T.[#c*ZC,sUe
DBGMISC:     ENTERED krmzlog [09:02:53.914]

mz-v;V,y:wworacle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netDBGMISC:      Message (len=0) before truncation=ORA-00600: internal error code, arguments: [kgeade_is_0], [], [
V&uOXa,p
p], [], [], [], [], [] [09:02:53.914] (krmzlog)
q-w1x-JO8P1E^k2[cITPUB个人空间RMAN-01005: ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [], [], []space.itpub.net#o1tO.j"`bfI
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net2_Dv        W w6w\
看到这样的信息,去哪能找到这个krmzlog日志呢?
shiri512003发布于2008-06-24 11:19:14
帮顶
蚊子窝 foxmile 发布于2008-06-24 11:35:43
小版本之间数据字典的差别会不会影响备份和恢复？
赵宇的DBA记事本 赵宇 发布于2008-06-24 11:57:40

QUOTE:

原帖由 foxmile 于 2008-6-24 11:35 发表 Z`R7W+X#Tt
小版本之间数据字典的差别会不会影响备份和恢复？
space.itpub.nete|.Hy1lNGr2]

^|3NT_|&PXK)l y目前已经影响了,现在正在用杀手剪 DBMS_BACKUP_RESTORE,如果这个也不行,我也是没有办法了
赵宇的DBA记事本 赵宇 发布于2008-06-24 13:09:08
在生产库查看backupset对应的datafile,进行PL/SQL编辑,开始还原:
-x,[x-uC.du&U3O*kLITPUB个人空间
2h5n3x'J        Y8KK7TITPUB个人空间RMAN> list backupset 840;
8?d{"i\(cWoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
7gA*G
Y&RW-iList of Backup Sets

aw
m$Fd3ZZ1j===================(aX8~aNHQ
BS Key  Type LV Size       Device Type Elapsed Time Completion Timehi)fC$q;hGl Y3j}
------- ---- -- ---------- ----------- ------------ ---------------
gs;}Md/x~.t6q)Z840     Incr 0  7.57G      DISK        00:15:12     16-APR-08      
xQ%`%v%i'm  List of Datafiles in backup set 840
&y^5@Yt!O![A2Foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  File LV Type Ckp SCN    Ckp Time  Name&lOLW&sOd+s
  ---- -- ---- ---------- --------- ----
f        Dz&O:U|*H  1    0  Incr 301504706  16-APR-08 +MYASM/baan/datafile/system.266.592727231+m9g ^)E)zF"Y.P
  4    0  Incr 301504706  16-APR-08 +MYASM/baan/datafile/undotbs2.270.592727267
'Z9X
[vB1L  9    0  Incr 301504706  16-APR-08 +MYASM/baan/datafile/system.293.629465471ITPUB个人空间T(d0J~;F blV
  Backup Set Copy #1 of backup set 840d"x"_3f(?9E
  Device Type Elapsed Time Completion Time Compressed TagITPUB个人空间Y5o"G E]5T r
  ----------- ------------ --------------- ---------- ---,H[-G)a;m+{\4O,LGo
  DISK        00:15:12     16-APR-08       NO         TAG20080416T025006space.itpub.net
O&Ph
vSA(~
    List of Backup Pieces for backup set 840 Copy #1
,[` W
U!V#Yy5s(Dm1~v    BP Key  Pc# Status      Piece Nameoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net)S3rK,?W$o[Qw
    ------- --- ----------- ----------space.itpub.net3OM#Z%}S&}1k
    1176    1   AVAILABLE   /RAC_BACKUP/rejdub9b_1_1space.itpub.net:g w~oWuy_0s1u:m
    1177    2   AVAILABLE   /RAC_BACKUP/rejdub9b_2_1
l[}]8{*X7?
k4cITPUB个人空间    1178    3   AVAILABLE   /RAC_BACKUP/rejdub9b_3_1
$v;KT n        @aAj!HZzH5l    1179    4   AVAILABLE   /RAC_BACKUP/rejdub9b_4_1ITPUB个人空间B/AF:c2~]*C7\        p
d7Z
)V l3T'xqzK
U"Vl)Dt;f W7r.`M
vi restore.sql:
3n-}nu B6]4Tjoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net!u)t)G9c3r@        jl7@
set echo off;
S&S&H6lKI#Loracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netset serveroutput on;@:`n5SMR,D0a
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;
;z        L%W#x
M"gvariable devicename varchar2(255);
#k'D%g'?"?
L@declareoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net(BE2KzZ3VP#{9kQ8h
omfname varchar2(512) := NULL;oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netX+T!~rW7~_Q1E y
  done boolean;2f`y i'YOR
  begin eQ:gg[e(K;p
    dbms_output.put_line(' ');1dqb?
lq7h b
    dbms_output.put_line(' Allocating device.... ');
1a5xEB;sjQ-~'DITPUB个人空间    dbms_output.put_line(' Specifying datafiles... '); LMHzY
       :devicename := dbms_backup_restore.deviceAllocate;
4[(J*YF*j0h,Xp    dbms_output.put_line(' Specifing datafiles... ');ITPUB个人空间YSt?0@HJ
    dbms_backup_restore.restoreSetDataFile;
        ZW:r
Q6M4^/t tdj      dbms_backup_restore.restoreDataFileTo(1, '/RAC_BACKUP/baan/system01.dbf', 0, 'SYSTEM');vb/@8u_O
      dbms_backup_restore.restoreDataFileTo(4, '/RAC_BACKUP/baan/undotbs2.dbf', 0, 'UNDOTBS2');
&Z5J;v5lC%[Y
H"L      dbms_backup_restore.restoreDataFileTo(9, '/RAC_BACKUP/baan/system02.dbf', 0, 'SYSTEM');space.itpub.net4`P%wq9F0]7It6a
    dbms_output.put_line(' Restoring ... ');space.itpub.net
Cp s?"Ea(g_3VZ
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE('/RAC_BACKUP/rejdub9b_1_1',DONE);j?]9{pr"R n
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE('/RAC_BACKUP/rejdub9b_2_1',DONE);
,ult3a@Eim3[rDBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE('/RAC_BACKUP/rejdub9b_3_1',DONE);space.itpub.net-j~$Yz1\8t@z
DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE('/RAC_BACKUP/rejdub9b_4_1',DONE);
o:sy.p%fB wu    if done then
'pb O        rp.OO'voracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net        dbms_output.put_line(' Restore done.');space.itpub.net2tY8\:|R7RY
    else"j2M#L/iH
        dbms_output.put_line(' ORA-XXXX: Restore failed ');
iSlPm4t,Q    end if;ITPUB个人空间ds0w_!q
    dbms_backup_restore.deviceDeallocate;oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net;eaa*TU(yuB
  end;oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net(g.TB([G3Sbc8J
/%?P"y9_s5x_%ad
select TO_CHAR(systimestamp,'YYYYMMDD HH:MI:SS') from dual;
"rQ'c7u Despace.itpub.net.YvJ*B(w1BM
m3GCBHv9aG
SQL> @/RAC_BACKUP/restore02.sql4}UV/L!i9{5w
TO_CHAR(SYSTIMEST
A{}        W#w o-----------------5QQ5b.nt.I&c8i
20080624 11:54:02
IJ$UX(M9Fspace.itpub.net
+? eSO){;ptspace.itpub.netAllocating device....
u
~%AaNj^ISpecifying datafiles...ITPUB个人空间 cx2x-B]@1~pWE
Specifing datafiles...
d6AY
p.|.\Restoring ...ITPUB个人空间jx:ZE9T4R        y
Restore done.
j!gkY7Joracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netPL/SQL procedure successfully completed.space.itpub.net2Pw2e0W`TMFl @
!d'[C-F8}Z
TO_CHAR(SYSTIMEST
"ot
RRyQ1r-----------------ITPUB个人空间vg+k}(D:rCP
20080624 12:55:43oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net8U&iT xV
V3]Q!Sqs(\O


~MQT"c/@&` A
+RF9OS5N.ooracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net$ llITPUB个人空间Bwfu3@6zo$ZqM~
×ÜÊý 30249256

lC.eq` fJ^ITPUB个人空间drwxr-xr-x   2 oracle     oinstall     12288 6ÔÂ20ÈÕ 13:52 archiveoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netWOd/W9ij
-rw-r-----   1 oracle     oinstall   5358231552 6ÔÂ24ÈÕ 12:35 system01.dbf
2^W ~B4Ia3z-rw-r-----   1 oracle     oinstall   5358231552 6ÔÂ24ÈÕ 12:55 system02.dbfi$J,G8o$j$p/O
-rw-r--r--   1 oracle     oinstall   2097160192 6ÔÂ20ÈÕ 12:15 temp.261.592727263oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netfsl^%L%C/l,T
-rw-r-----   1 oracle     oinstall   2673876992 6ÔÂ24ÈÕ 12:22 undotbs2.dbf
&I{ht;WITPUB个人空间j
Atv:]0Y j8i
文件已经生产,看来可以恢复, ,兴奋,继续
赵宇的DBA记事本 赵宇 发布于2008-06-24 13:10:02
不能所有的backupset 都选择上，否则会出现下面的错误:space.itpub.netN.h-C3Rq[r]l1d

4d`Ix"j@SQL> @/RAC_BACKUP/restore.sqlm*l-U&k-G;Ai%Q[E'Z

y'h
dc8JNu:Y5u%VITPUB个人空间TO_CHAR(SYSTIMEST
H.Wl0g A&\-----------------
3Rw1~9sH:V        Mh20080624 11:34:01space.itpub.net;`;@cL0U
qO4@J
ITPUB个人空间        I/L J[&w~
M
Allocating device....ITPUB个人空间8L#~oV8U o.b
Specifying datafiles...oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net"{1R
N_)m#Q
Specifing datafiles...
O;t"\_KITPUB个人空间Restoring ...
^*\
G@3cdeclare
        kv
Q_ cg8J y$niGTITPUB个人空间*
%fT8[}UQf2BERROR at line 1:
U1z&]g8n0pJj3Y
ORA-19624: operation failed, retry possible
[}Qr ?;I/r5}/@(VORA-19870: error reading backup piece /RAC_BACKUP/rcjdu8ev_10_1ITPUB个人空间Nv,_/kO3K_i3`S;\
ORA-19611: backup piece out of order.  Expected 1 but found 10
3T j;m,l&xORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 5170
#D,e5P5_5Q.X(Q]vORA-06512: at line 21
7RC3l;?8\5u/d3|
XXyy1H%_space.itpub.net
Pzd,uJ9x9eh4P
        Y\X&`(xTO_CHAR(SYSTIMEST
)Zn:M2m P`6HWspace.itpub.net-----------------
Vpa3J.j`
SbITPUB个人空间20080624 11:34:02
赵宇的DBA记事本 赵宇 发布于2008-06-24 15:32:58
SQL> @/RAC_BACKUP/restore02.sql i5m{/n|D F"f
TO_CHAR(SYSTIMESTT(iW
h{t
-----------------(oA+}$bZzb
20080624 01:25:15)H8b&I4q0u2Q"h"@2C
Allocating device....D+g)dA N^bG$A:{6G
Specifying datafiles...oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net#R"NebQ
W
Specifing datafiles...
(\uZ$r|Gspace.itpub.netRestoring ...
+^2?5?C{(d!Xspace.itpub.netRestore done.ITPUB个人空间6F Rzb)Wl
PL/SQL procedure successfully completed.
Lw*dvpL
C@yITPUB个人空间
xzfD/FTO_CHAR(SYSTIMEST
5OE5w3Yb4wnspace.itpub.net-----------------space.itpub.net
C?$o1b IMY
20080624 03:30:25oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netErCa        Gt5N        O C

a-d&G-S*|hIX"{8M$goracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net好长时间,又还原了3个datafile,查看alert.log
.r.sT q'H^+inFull restore complete of datafile 3 to datafile copy /RAC_BACKUP/baan/sysaux.dbf.  Elapsed time: 0:16:17 space.itpub.netJQL3BW*Y#sE
  checkpoint is 3014980239`f2_L5w
Tue Jun 24 13:44:52 2008
+kP
T(l\"h6M/bFull restore complete of datafile 2 to datafile copy /RAC_BACKUP/baan/undotbs1.dbf.  Elapsed time: 0:19:37
(DCa8O}d{o]  checkpoint is 301498023
)I'p{KC9Sc|6c#H9wITPUB个人空间Tue Jun 24 15:30:25 2008
W
l!fi N6qW!M
Full restore complete of datafile 6 to datafile copy /RAC_BACKUP/baan/baanidx.dbf.  Elapsed time: 2:05:10 ITPUB个人空间)Flz
OX{hqqy
  checkpoint is 301498023
赵宇的DBA记事本 赵宇 发布于2008-06-25 09:41:37
终于找到了,看来可以用applyBackupPiece 包进行增量备份的restore
Ta/wJD`space.itpub.net4. Applying incrementalsoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net!djI"?        D/E;W

0]vy1XyqXr(OIf incrementals are to be applied, you must execute this anonymous block
^H#br.N&WVhoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netfor each incremental datafile backup. The following SYS.DBMS_BACKUP_RESTOREoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netocVh i
B'f
packaged functions & procedures are called:rX:l)lj.O
m6YU

\R
zb@/E.Soracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netFUNCTION deviceAllocate - allocates a device for sequential I/Ooracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net&BF/n#qj] m-Q3P:f
PROCEDURE applySetDataFile - begins a restore conversationoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net~5b.bq `5^f
PROCEDURE applyDataFileTo - datafile number & destination
"h5jO'?oPROCEDURE applyBackupPiece - performs the restore
)lgP [y JPROCEDURE deviceDeallocate - deallocates the I/O device
;~taAY:aoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net
6V
v@|+`g!d~9OThe following anonymous block can be created and executed to restore aspace.itpub.net+qFN8i&_`k
datafile from a backupset. Before executing it, you MUST edit the block
#J A.Ay*\gYITPUB个人空间as follows:        [f:NVa*CK#qD
space.itpub.net4wRhW4a%O
a. The filetable PL/SQL table entries must reflect the backuppieces
6oeYnak        Q;sPoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netcomprising the backupsetITPUB个人空间$LbJsRf-|0y
C
b. The v_maxPieces variable must reflect the number of backuppieces
`u?J6H#}8zoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netcomprising the backupset
$q0B6ba'@
?pZc. The call to applyDataFileTo must specify the correct datafile number,
b&~C3J
@|Eispace.itpub.netand datafile path & filename
E_!x?1A
g/bV@%DRi ITPUB个人空间l1O)] Z3v
fS0D
DECLARE}y}u*pm
v_dev varchar2(50); -- device type allocated for restorespace.itpub.netnq
B;f6e1C#XKV
v_done boolean:=false; -- has the datafile been fully extracted yet
j^D\]dtype t_fileTable is table of varchar2(255)
[ y
E q3swG\o:voracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netindex by binary_integer;oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net#K&d:kQ/Fp y-tA?
v_fileTable t_fileTable; -- Stores the backuppiece nameITPUB个人空间H0l5g Zh{(z,s
v_maxPieces number:=1; -- Number of backuppieces in backupset4oYAl?
J4U
BEGIN
f
EL'`f2PR}@s
k`.f%e)C2QT"LeG-- Initialise the filetable & number of backup pieces in the backupsetspace.itpub.net5AY?^r|
-- This section of code MUST be edited to reflect the customer's availablespace.itpub.net I3\7F`1i(|{%t
-- backupset before the procedure is compiled and run. In this example, the
Q\l%[p*Hj,FITPUB个人空间-- backupset consists of 1 piece, a level 2 backupset:
-y O9CGT
~Xoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net )l.fq*B&P
v_fileTable(1):='fulldb_level2_s18_p1';
wmT0Fnh FYspace.itpub.netv_maxPieces:=1;

s%I$o?$D^oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net ITPUB个人空间t
]h(DeP7V.Z
-- Allocate a device. In this example, I have specified 'sbt_tape' as I am
-r(a [5~/W*}V-- reading backuppieces from the media manager. If the backuppiece is on disk,
$O} iH)Dsoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net-- specify type=>nullspace.itpub.net C6R0y7c"@.gMS+cE
,I&}R;M)v        |u)qSJn
v_dev:=sys.dbms_backup_restore.deviceAllocate(type=>'sbt_tape',6R H4z1H$w9N
ident=>'t1');
}:Ic.L7^o,Y/c2B5\ lITPUB个人空间 space.itpub.net        kVJ:bkJ)b-b^
-- Begin the restore conversationE*cu
z)M'@ x5L

eAKd_2Y4l)rksys.dbms_backup_restore.applySetDataFile;space.itpub.netV}y;hB
0],sA'SA
ck8E6F%q8l_
-- Specify where the datafile is to be recreated
y+Id6W.eX |
7l_&U8z%\K6Osys.dbms_backup_restore.applyDataFileTo(dfnumber=>1,space.itpub.net6E%|w1@5I;U-z+N
toname=>'/support2/OFA_V804/u1/oradata/dbs/sysV804.dbf');$Z]f-C%A
\&sO
oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net+v[6Hx
Lai!|(c P
-- Restore the datafile
8bN$paw+SkFOR i IN 1..v_maxPieces LOOPoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netQab:m)G.A
sys.dbms_backup_restore.applyBackupPiece(done=>v_done,%VnP ?7o T$?,^"J
handle=>v_fileTable(i),a/n]'?ts}A9|
params=>null);
U|2ZT;j3R        u CITPUB个人空间IF v_done THEN
rJPI~iGOTO all_done;
~@2s$A        j(@END IF;
/`+O{1I.C%p0dm)?ITPUB个人空间END LOOP;
9?yKU'Ypa$i:Aspace.itpub.net<<all_done>>ra+x@fY6i7Gg1K;O
-- Deallocate the device
D:Q9oYLoJspace.itpub.netsys.dbms_backup_restore.deviceDeallocate;
0Z%e;X/[ioracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net

g/}
tGA,Lr-mTPUB个人空间END;
shiri512003发布于2008-06-25 10:13:51
看来这个包还有许多值得研究的东东呀
赵宇的DBA记事本 赵宇 发布于2008-06-25 10:43:25
$ vi applybackuppiece02.sql
V%k0Ho2z"applybackuppiece02.sql" 30 &ETH;&ETH;, 810 ¸ö×Ö½Ú
G,]+K
g ];a8mWjDECLAREb#Jn{%~
v_dev varchar2(50); -- device type allocated for restore
UL-q4P9eYshHoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netv_done boolean:=false; -- has the datafile been fully extracted yetoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netF?R[GRE+i[y
type t_fileTable is table of varchar2(255) index by binary_integer;oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net`#Z,]"kz1^+z.z0s
v_fileTable t_fileTable; -- Stores the backuppiece name
fsBH1OeSCspace.itpub.netv_maxPieces number:=1; -- Number of backuppieces in backupset @'lz|*nl ?
BEGIN
X%ldC{$s8Gsv_fileTable(1):='/ora/backuppiece/rnje6bs4_1_1';             s$WSa"Lz]
v_maxPieces:=1;ITPUB个人空间8pT a0D _8Y'UI9mD
v_dev:=sys.dbms_backup_restore.deviceAllocate;
"^1[6z@\9Roracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netc.H1m.] @_z.ZE
sys.dbms_backup_restore.applySetDataFile;
"`g3q/Yk+Z7@ITPUB个人空间
`;d1E6pP@wlXoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netsys.dbms_backup_restore.applyDataFileTo(dfnumber=>7,toname=>'/RAC_BACKUP/baan/baandb.dbf');space.itpub.netlqT)_4z3O
FOR i IN 1..v_maxPieces LOOPITPUB个人空间%b~4H2D'M
X3r        B.X
sys.dbms_backup_restore.applyBackupPiece(done=>v_done,handle=>v_fileTable(i),params=>null);$Cf/CZ2@
IF v_done THENz%X(zAT8f
GOTO all_done;
X!U7M2[%sE7roracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netEND IF; ^^5h%a;[0h7v4s7T
END LOOP;space.itpub.netZ ?N DS&W
<<all_done>>H0S#I{N)ve
sys.dbms_backup_restore.deviceDeallocate;

^Z1dq6N{4AEND;
_E1i`j,pspace.itpub.net/
3tA*a:w im$koracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net~
W+TK~0E~
        aR^k,X*p~m%U/{$GFQ
~
{/S"jB/i|3d        s r!F7W0y~ITPUB个人空间7T1~6bV%P~?
~
$q.n(J)z.[S1Li }2d~~7\5e
}X3vN!r
~
$a3E&t!]t#?oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net~(|(}w qA/?RzS
"applybackuppiece02.sql" 30 行, 810 字节ITPUB个人空间}T.JS?N3v X,T(H
$ exit3u|%vkC
SQL> @/RAC_BACKUP/applybackuppiece02.sql
_\7^+H.Of,foracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netPL/SQL procedure successfully completed.
g+t.i(ojW        {
4~_)k];A7o%q2mh coracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net已经编辑好这些incremental backup的pl/sql,正在执行
solearn的个人空间 solearn 发布于2008-06-25 11:07:15
留个记号
cyt2005发布于2008-06-25 11:07:56
直播啊
U.V wvLt-p.S P~ZR等lz结果oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net1|"yhLG&cJ.v)PhF
很即时的过程
赵宇的DBA记事本 赵宇 发布于2008-06-25 12:02:55
刚才修改了controlfile中datafile,redo log file的名字,尽管出现了ora-600错误但仍然修改成功,修改时,我发现ITPUB个人空间!G!N,XR0x6a
ASM起的别名都报600错误,而自己以前起的名字不会出现错误*~){R        L0]
ITPUB个人空间7z;gp%i7^*[
SQL> alter database rename file '+MYASM/baan/onlinelog/group_9.290.628808517' to
Q(}+RCN,h4?soracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net  2  '/ora/app/oracle/oradata/baan/redo9a.log';
h)k0b9L{5U AITPUB个人空间alter database rename file '+MYASM/baan/onlinelog/group_9.290.628808517' to
@5_$Cn/T*F&n*
o.L
b I'y\4YERROR at line 1:space.itpub.net$Pwa:H,u)V.Q
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [],
R:C9qC PL6[XmL[], []
K#q%ihp:ZY5I)Bspace.itpub.net&Q&BG:a g
o
SQL> select * from v$logfile order by group#;
mk:z!uC)T'Uoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netrows will be truncated

}xaj [r/qITPUB个人空间-F;}-Na'Y}^
    GROUP# STATUS  TYPE    MEMBER&rVa-]y7V        oZ|5z1w
---------- ------- ------- -----------------------------------------------------
%|evGXX\         1         ONLINE  /ora/app/oracle/oradata/baan/redo1a.logspace.itpub.nett        PLoj
         1         ONLINE  /ora/app/oracle/oradata/baan/redo1b.log
d!KKX*P+[~ V         2         ONLINE  /ora/app/oracle/oradata/baan/redo2a.log
T
Ag+z/o N         2         ONLINE  /ora/app/oracle/oradata/baan/redo2b.log
;S:W
x _5D;m'ud6C         3         ONLINE  /ora/app/oracle/oradata/baan/redo3a.log
$eTsy$K yF`OQ-TY'z{oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net         3         ONLINE  /ora/app/oracle/oradata/baan/redo3b.log
G!i        ?        C5x
B7g _a         4         ONLINE  /ora/app/oracle/oradata/baan/redo4a.logoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net]6u{$_-k0@"Q
         4         ONLINE  /ora/app/oracle/oradata/baan/redo4b.log
z(z9]f9j*Z         5         ONLINE  /ora/app/oracle/oradata/baan/redo5a.log
)zA+kG+Lspace.itpub.net         5         ONLINE  /ora/app/oracle/oradata/baan/redo5b.log:d+Y*J`^U%I
         7         ONLINE  /ora/app/oracle/oradata/baan/redo7a.log
+F~t r/L`;pt-c    GROUP# STATUS  TYPE    MEMBERI`]+a%B
tqT
---------- ------- ------- -----------------------------------------------------space.itpub.net7MM%}7[[NZdnv
         7         ONLINE  /ora/app/oracle/oradata/baan/redo7b.log
0dm'@ac bwn'@         8         ONLINE  /ora/app/oracle/oradata/baan/redo8a.log&~E.jr%gA
         8         ONLINE  /ora/app/oracle/oradata/baan/redo8b.logspace.itpub.net!ZS3X E.b
         9         ONLINE  /ora/app/oracle/oradata/baan/redo9a.logoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net3n*^UI&V
         9         ONLINE  +MYASM/baan/onlinelog/log9.ora&bF4]~:RI+yL
        10         ONLINE  +MYASM/baan/onlinelog/log10.ora
`%j
GCn p)_Q}oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net        10         ONLINE  +MYASM/baan/onlinelog/group_10.291.628809285ITPUB个人空间t
zLS2s/d_
        11         ONLINE  +MYASM/baan/onlinelog/group_11.292.628809315
3c M]"\xP0|        11         ONLINE  +MYASM/baan/onlinelog/log11.oraspace.itpub.net%R|0ty[CZ1M
20 rows selected.ITPUB个人空间"J^hK        A e a&L
SQL> alter database rename file '+MYASM/baan/onlinelog/log9.ora' to.bDDV-E
  2  '/ora/app/oracle/oradata/baan/redo9b.log';S.z0z4A5f0^8U"e&n
Database altered.
赵宇的DBA记事本 赵宇 发布于2008-06-25 14:09:38
通过FTP把两个节点的archived log拷贝过来了,已经开始恢复了,SCN也开始改变了oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net:^:s$j+xh

KF&z*V.i3[-SWtR2ispace.itpub.netSQL> alter database flashback off;
g5{ w4L1m"b#atqoracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.netDatabase altered.
.?:A3sZ^"Z
z!lJj$M:a(Q/~SQL> alter system set log_archive_dest_1 ='LOCATION=/ora/flash_recovery_area/BAAN';oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net;uF ?U@6f)e {-P0y
System altered.
p-Nv*NH'?$f@*FDITPUB个人空间
+~C9bUSwspace.itpub.netSQL> archive log listspace.itpub.netn[#X9A)d
Database log mode              Archive Mode
\        {B-~cWAutomatic archival             Enabledspace.itpub.net        L6g/cz8I RB$}w
Archive destination            /ora/flash_recovery_area/BAAN
g2Y%r
DB1IX
Oldest online log sequence     467%f]'z*N%h.HK&NK'H
Next log sequence to archive   471ITPUB个人空间0a6hQ'DzWP
p
Current log sequence           471
XIEb:Q}'qspace.itpub.netITPUB个人空间2B1q|Ckp\
SQL> recover database using backup controlfile until cancel;vc[*TS2s
ORA-00279: change 301498022 generated at 04/16/2008 02:50:07 needed for thread 1ITPUB个人空间 v:_Zk@QN[
ORA-00289: suggestion : /ora/flash_recovery_area/BAAN/1_471_640546001.arcITPUB个人空间zf b~K
ORA-00280: change 301498022 for thread 1 is in sequence #471
C[9w0YxU6Loracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net u+Q#c n3^u\g
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
J9U_IfFauto
4M1us:U!Im4ZORA-00279: change 301498022 generated at 04/15/2008 21:59:05 needed for thread 2JZ;BFp{h"f
ORA-00289: suggestion : /ora/flash_recovery_area/BAAN/2_468_640546001.arcvh!Y4LS#NZ
ORA-00280: change 301498022 for thread 2 is in sequence #468oracle,db2,sqlserver,sybase,mysql,erp,scm,sap,java,.net;s;}eV2b

%MC-m4@?/GITPUB个人空间ORA-00279: change 301512547 generated at 04/16/2008 04:42:25 needed for thread 1ITPUB个人空间,qk-o&XLr`7ED
s
ORA-00289: suggestion : /ora/flash_recovery_area/BAAN/1_472_640546001.arc
yr?4lGzS!zORA-00280: change 301512547 for thread 1 is in sequence #472N.O"f UG
W~$G
ORA-00278: log file '/ora/flash_recovery_area/BAAN/1_471_640546001.arc' no longer needed for this recovery/jw;Ay{s+ci


wkAe8B'@ORA-00279: change 301562850 generated at 04/16/2008 09:00:58 needed for thread 2
8Um3~NA(V8H dORA-00289: suggestion : /ora/flash_recovery_area/BAAN/2_469_640546001.arc
azIo@m#?ORA-00280: change 301562850 for thread 2 is in sequence #469*G4L}~4Ly SG o
ORA-00278: log file '/ora/flash_recovery_area/BAAN/2_468_640546001.arc' no longer needed for this recoveryD0pt&jhRsI+y

6I2PPb8YfaITPUB个人空间ORA-00279: change 301634672 generated at 04/16/2008 10:28:31 ne