RMAN 中change backupset unavailable 测试和相关命令用法

比如我有两个备份集,数据库在恢复时是按默认最新的备份集来恢复,但这时如果我想ITPUB个人空间;BY]8|.arBmB
要比这个更早点的备份集来恢复,那就可以用到change 某个备份集不可用了ITPUB个人空间\(i
f0PW)w5g]
具体还是看业务需要
^8F*f ME5n7OP0以下是测试过程

PHP code:

_tU I%yg
s|.o:K0

it _2q?{|}+y S'x0RMAN> change backupset 96,97 unavailable;ITPUB个人空间5dZ+L*i H

uF?5F6`!B s"D0ITPUB个人空间;s-NLn3D\mIw3l
ITPUB个人空间pL8L
z.D"}Co$d
changed backup piece unavailable
*O8W&f ? Z0Xrs3k0ITPUB个人空间1` R~3r{n
backup piece handle=D:BACKUP34JI2ROR_1_1 recid=96 stamp=656502555ITPUB个人空间$l+Z&@$IT\/Gx-T
ITPUB个人空间E;C%W ~|Bo
changed backup piece unavailable
n]zh(Op+_0ITPUB个人空间6k8N|.I] ]4y(Y$De#T
backup piece handle=D:BACKUPC-799229701-20080604-03 recid=97 stamp=656502580
/?(]l\0M4KJ0
8v|I4b sq o0Changed 2 objects to UNAVAILABLE status
e@ v2|7w$}Cd-DH^L0ITPUB个人空间%Nct E"C-{e

R p4P'_ P~(]0
J%PK0EN^0
/^-P#ZHTQ3V+Y$H`f.j0ITPUB个人空间
f4K;_H;a%J|3h#J
RMAN> list backup summary;
3k[T{!S9^5Q.z p C7VC0ITPUB个人空间llsr~(Os

]W"a m Z`XQ"Y-N!P0ITPUB个人空间(@:O-T Tg(Mc9o2ms

l)`i"~y%],~!Q5dg0
7X
U7^m)w0List of Backups
q"\e&yP1_l0
3XoXxR&s|nb,YE0===============
-H"DFJ\,u E:xT Jw0ITPUB个人空间9b"JmK-gOT(j!QG
Key     TY LV S Device Type Completion Time #Pieces #Copies Tag
;YxT6@cl0
:Xw9i_y S0------- -- -- - ----------- --------------- ------- ------- ---
F d"fZ2pL0
$M#Gc1m ~-~2P094      B  F  A DISK        04-JUN-08       1       1       TAG20080604T094245
R#@5P"M{ c"b0
1Z YT,|.|2j3PI7_095      B  F  A DISK        04-JUN-08       1       1ITPUB个人空间
c3d'B"Rt;ib

G6`K)l!?0bc096      B  F  U DISK        04-JUN-08       1       1       TAG20080604T094915ITPUB个人空间kP{"{~q)R#L
ITPUB个人空间*j_&Y ]ziu0@K
97      B  F  U DISK        04-JUN-08       1       1ITPUB个人空间 MAO8a'u\*[6NQu
ITPUB个人空间U!I-kSi:~%Y
ITPUB个人空间yY-yl;g/}
ITPUB个人空间;{4Lc$rv0L(w
RMAN> exitITPUB个人空间"V;g[!w T'Fq0Rz
ITPUB个人空间w-or+H*U@
状态U 表示不可用ITPUB个人空间;P+p&I1oO p3I8Y c D;| r

t%l2D6pF&V4W0
`%yy%J,{"VU*d0ITPUB个人空间}5eo2ua
Recovery Manager complete.ITPUB个人空间giJ-kC"k

k8\w1ia;W0
0M(M&N&Zi0
r3V Uy};hJ3`0ITPUB个人空间4Gm-Y D"S[I(R#D

O/pSu|.Y2r0RMAN> startup nomount;ITPUB个人空间U}M&H#Q

$OV:YZ1_6j0ITPUB个人空间\*nUx-X

-se4e}$b?0Oracle instance startedITPUB个人空间/J6_3Y(cb E~\

Ka#w/WV"u&S+B0ITPUB个人空间d,Wd HT8vE

(k,m|m"O~%T:n0Total System Global Area     101785012 bytes
h)_x(dV;o\cDL0ITPUB个人空间(Zg*K@_+M|5n4O

~]a/H9n0ITPUB个人空间n%x(_/f-B+N9M-y ym
Fixed Size                      454068 bytes
V.[6h-n V A*F0ITPUB个人空间[}
e K*YCl(j~
X
Variable Size                 75497472 bytes
9yh NX`0
;C
M;QUL/De#hY8|0Database Buffers              25165824 bytesITPUB个人空间%O*w#MCOm X8h2W7h
ITPUB个人空间+|nW,?{[K1^sD
Redo Buffers                    667648 bytesITPUB个人空间:A3X7[L(B([

3I@~c({Nu;^#X(R?0

EJ"Auy
M0
L-^8E.N ?0ITPUB个人空间LRKM0JMo

.kE/N$Q"y n0RMAN> alter database mount;
su+e+H S8BBJ0
]aq5EKR[oZ0ITPUB个人空间%d!R)P-\7k%r4n(YC
ITPUB个人空间(M#H^!E_&u;hY
database mountedITPUB个人空间bS3_8x\x AX r9q

1dx'L+RF.| M0
%f r1_2iW0
:y"K|%} W-k{9Q:v0
c V#G,W}\&c1h.\!Q0
Y.G q.e0B:@5w?A"j0RMAN> restore database;ITPUB个人空间{8L.I$~1Ps

7o3x`'N-Y;HB0ITPUB个人空间 k3F#S F7d
ITPUB个人空间 o%\:?t,OI`
Starting restore at 04-JUN-08
w"NxNzo
iJ,p0
Q,Sh4@-]C0ITPUB个人空间2d2lM;Ay

V5GF!We,V0using channel ORA_DISK_1ITPUB个人空间;L$u |6lR$T6xq[

,|[ Z+?2]HXT _0channel ORA_DISK_1: starting datafile backupset restore
"Iw/{&n};R2u'cf0ITPUB个人空间6Eo9qf9]rdzz
channel ORA_DISK_1: specifying datafile(s) to restore from backup setITPUB个人空间&TtB8H5? C6}]'K h)g
ITPUB个人空间
K#U1jz#[4D l
restoring datafile 00001 to D:ORACLEORADATAPUBTESTSYSTEM01.DBFITPUB个人空间t^XlC/v:^bQ
ITPUB个人空间]d.[,Z"F7?J:r
restoring datafile 00002 to D:ORACLEORADATAPUBTESTUNDOTBS01.DBFITPUB个人空间Y Om*bt O
ITPUB个人空间Zrxm0P8b)lRe
restoring datafile 00003 to D:ORACLEORADATAPUBTESTEXAMPLE01.DBF
%e+q]!S-i!cX)e
V0ITPUB个人空间-j ]0m+?0g5R'H5U4L9C
restoring datafile 00004 to D:ORACLEORADATAPUBTESTINDX01.DBF
$Z.k*r2Z
?U0
3E:l{'O(J|0restoring datafile 00005 to D:ORACLEORADATAPUBTESTTOOLS01.DBF
k3K!OX O0
2KZ,E.E#C1Dy0restoring datafile 00006 to D:ORACLEORADATAPUBTESTUSERS01.DBF
\#|9UD#ww.pc3W!X0
A:Q#Qign/P1^7J#a0channel ORA_DISK_1: restored backup piece 1
U4cjdz0ITPUB个人空间M4KB+\$@2ZM7i7s
piece handle=D:BACKUP32JI2RCM_1_1 tag=TAG20080604T094245 params=NULL
I9z ll)y X/?b0
k5}/E/Oo6r8wb|3AL{0channel ORA_DISK_1: restore completeITPUB个人空间.B6EiAr+UG:]g;CK

!zh8O x![*vH.Mz'I0Finished restore at 04-JUN-08ITPUB个人空间 P4lVj-LR
ITPUB个人空间 v L,}:Th2R7O m y
与可用的tag 备份集名一致ITPUB个人空间tZ"c*M(_6E7R$NA{
ITPUB个人空间y|F/ePC{T
RMAN> recover database;ITPUB个人空间2J#ah:yi iH9Q

%ASc}J2\`x0
+z5J#L8nl`6vJ;A/@x0ITPUB个人空间,EV,PRT'w/d4V
Starting recover at 04-JUN-08ITPUB个人空间.R:[6[G3eYUa`
ITPUB个人空间w!pm5sqy C
using channel ORA_DISK_1ITPUB个人空间6E"E%T4Y^
ITPUB个人空间1fx%a,k5pdu"Mv
ITPUB个人空间X;p] Dk[+t!ML

8MY/F\_U\O0starting media recovery
*@)s lU(a{:N0
%^R,I}&nJzV/T1E0media recovery complete
9z.WTB|t+ftC0ITPUB个人空间0Brauve5l

+\etl(ig2y0
MAm.c)u*f(?N0Finished recover at 04-JUN-08
"QgO;YM)p7M0ITPUB个人空间5~yt0Wp[D
ITPUB个人空间*A
cv6I3KM

6r,Yi,[X0RMAN> alter database open;ITPUB个人空间/\cIU0]

#Yt6X+[#@0
L/D3@+hd5E`,w7g0
1DKH)nzR[-uhc0database opened
9NL1`jG/j5Qj0ITPUB个人空间0GWY)`o@+P
ITPUB个人空间r6K3L9tb/B"bTo
ITPUB个人空间(bm-L}_bm z0B
RMAN>ITPUB个人空间i6z~1` @q)f3E

---

1. list backup of database;
hKoZ6z:D6O/xR02. change backupset 2 keep forever logs;   --備份集2不受冗余策略的影響永遠有效（）
2Pzas)j3P%g%[/NzK%[6t0   change backupset 2 keep until time 'sysdate+7' logs;  --備份集2不受冗余策略的影響在超出正常日期7天內有效ITPUB个人空间)f {"SB'~s
   change backupset 2 nokeep;     --變更備份集2為廢棄狀態（為無效狀態可以用delete obsete來刪除）ITPUB个人空间%Dc(z.E.I"EQEcx
3. delete obsolete;      --刪除所有無效的備份集

4. backup database keep forever;ITPUB个人空间%S*RuQP
   backup database keep unitl time "to_date('01/01/05','mm/dd/yy')";
/z)o7Vo-H3V0l0   backup database keep 5 days;

~,D5bP%pIV9Va05. change backup of database tag='whole_db' unavailable;
m6kWt*Hc0P:w@t0   change backup of database like '%GOLD%' unavailable;
fC!@L7|I eVl)^0   change backupset 2 unavailable;
P)wo%b{Ne0   change backupset 2 available;ITPUB个人空间:Pf E'x N/Lj$P
   change archivelog '/cfs01/oradata/archive/2_8.log' unavailable;
,I9q8r1F ]"r'T\0   change archivelog all backed up 5 times to device type disk unavailable;
'g:sXMAX,@|/a3V(Z0   change backup of database device type disk unavailable;

   change backupset 2,3 delete;     --刪除指定的備份集（物理刪除備份文件）ITPUB个人空间1J6D"zz,b
   change backuppiece 3 delete;     --刪除備份片3(物理刪除備份文件)
4P-y;`2Q"_D3j0   change archivelog until logseq=3 thead=1 delete;

c*y~:\o;y1@Z0