rman backup database force 功能
上一篇 / 下一篇 2007-12-21 08:50:36 / 个人分类:rman备份与恢复
FORCEITPUB个人空间9\)n#{GK$m`
Causes RMAN to ignore backup optimization. In other words, even if CONFIGURE BACKUP OPTIMIZATION is set to ON, RMAN backs up all specified files.
0I4S)fjfg/V`7k0ITPUB个人空间]"^3W@5T4l6\#R
Note: You can also specify this option in the backupSpecOperand clause.
$D,so#VaC
Ou5_/P0加上FORCE选项,则RMAN忽略调CONFIGURE里的优化功能选项.
;H&CTT1EC j0比如:你配置了RMAN优化功能为ON,之前对只读表空间作了备份,这时,再备份全库,不加FORCE.
|gh9RnGW0则RMAN不会备份只读表空间,因为之前已经备份过,加上FORCE,则RMAN忽略掉优化功能,ITPUB个人空间
J7Q"X{'?r[9n
作全库备份.
RMAN> show all;
RMAN configuration parameters are:ITPUB个人空间r3ac Bn%`$_Ba
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultITPUB个人空间
Wv'{\J'u
CONFIGURE BACKUP OPTIMIZATION ON;
SQL> alter tablespace tools read only;ITPUB个人空间x$F.i8]
@nqN4T0D6Mc
ITPUB个人空间 CG.dA O n%M
ITPUB个人空间 X.Ux4rX-@qN4v
~E
u(S0uBT0ITPUB个人空间d'gQ:j0uA
ITPUB个人空间"Bl aP)n
Tablespace altered.ITPUB个人空间p
N)BT1WTi;d)u(@t
$H1f*phc0
[,rCr8|
R o0RMAN> backup tablespace tools;ITPUB个人空间H2Ij%h#i.TgTC7o
#T8R9_]5f7f}_] {0ITPUB个人空间ca*ltzZ,b
{t3c;q)j0
-PB0G;Fhq L7dA0
$IG h
A`CCY0Starting backup at 21-DEC-07ITPUB个人空间"?7F7a0FHJxF
ITPUB个人空间$admRO
ITPUB个人空间kJ[%I0L{!_yE+V0q
using channel ORA_DISK_1
)ZDU6y9Vz)t0ITPUB个人空间L1^b5bJ
ITPUB个人空间C/MKno$u5o
channel ORA_DISK_1: starting full datafile backupset
8[X;X n:E-]},qV0
D {7ut4s(X0
6rn6]-]q0b0channel ORA_DISK_1: specifying datafile(s) in backupsetITPUB个人空间0o3K;\c"{
ITPUB个人空间&xPko,W3i
ITPUB个人空间!bqckC-T)uV
input datafile fno=00004 name=D:ORACLEORADATAPAULTOOLS01.DBFITPUB个人空间/i0V5F|'zj
ITPUB个人空间 g*a)J1S&P`V
ITPUB个人空间
}HWJ:c`+E8?
channel ORA_DISK_1: starting piece 1 at 21-DEC-07ITPUB个人空间4B WLc*~"e*{3_{&E
ITPUB个人空间 O5OM&K7O!{:Y5lk
ITPUB个人空间D&XQ"k2c.s O7n/e
channel ORA_DISK_1: finished piece 1 at 21-DEC-07ITPUB个人空间/ZS;h0_pu
/?t
?9i,s4^G3pBXs0
]5X(P"hxs/t0piece handle=D:BACKUP3IJ454LF_1_1 comment=NONE
jZ|1c-` V
m$k0ITPUB个人空间G7y*Q-oU5L4V
)T\
np7ce0channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
|,YG7\&j@bqT;R0ITPUB个人空间OB-X)SM3Z~
ITPUB个人空间2mW'DVfZbTR_1hS
Finished backup at 21-DEC-07
}"KI%k
NmbJY0ITPUB个人空间B#e v\6|$E
ITPUB个人空间}Yq8G;x,BbN!~8n_
&|5c
E Mk0
5C
A#{$f-K7UX^7m0
5\0M wl}N"nx0Starting Control File and SPFILE Autobackup at 21-DEC-07
)G,wY0X'@b0ITPUB个人空间2U/z#s3\Jhb*w
ITPUB个人空间*|}~w,y&m6uQzZ
piece handle=D:BACKUPC-1605165889-20071221-03 comment=NONEITPUB个人空间.qMy&f9^/tS6b
ITPUB个人空间#{g? IN_#G{2z
r
x}#^oP:i ?0Finished Control File and SPFILE Autobackup at 21-DEC-07ITPUB个人空间p(Gwn9|${z
ITPUB个人空间+Ad
NT'z,lA7?Z\
ITPUB个人空间;B
|/Wy@T
l:rd_N-n0
,bW{]]:\M%PoO0ITPUB个人空间a[b&]0w
RMAN> backup database;
m.k|HDV+mS0ITPUB个人空间+J+Dn2JM-c8U-DM5Q
ITPUB个人空间
A9O
NR}8f.~
cSe
YxHZ*[0ITPUB个人空间yLXJ5k?En ]z&i$@
ITPUB个人空间M!C6Te0BnNwd
Starting backup at 21-DEC-07
9clX c;C Y0
2x OWIk?0ITPUB个人空间s0i'x@n&n^qZ
using channel ORA_DISK_1ITPUB个人空间2_)o;PqF+e
ITPUB个人空间 }bWPe'a
'iD BT/b0skipping datafile 4; already backed up 3 time(s)
)Kh(w\Dk-Z/~0ITPUB个人空间-iO1C}!{xx1_tK
P
mwx/jK0channel ORA_DISK_1: starting full datafile backupsetITPUB个人空间}.L9R@M
Hg|#h3w
%?!mM0lI]C
q%a9C0ITPUB个人空间R;V Y
`"~9l9l
channel ORA_DISK_1: specifying datafile(s) in backupset
a0VSR A0P?^0ITPUB个人空间7]@.a(QT
!F"m4{*^yH0input datafile fno=00001 name=D:ORACLEORADATAPAULSYSTEM01.DBF
V'C3j6G*GP;m0
w-vg"ZW2XNd0
o,V
v#Gst;Td {0input datafile fno=00002 name=D:ORACLEORADATAPAULUNDOTBS01.DBF
rFB*VdF0
.\'M
~7aq M2wiD+V0
X%D&H E$v/t1U[0input datafile fno=00003 name=D:ORACLEORADATAPAULINDX01.DBFITPUB个人空间uH qu J
PZK
m(iH8s:k-?.Ex
MwP0ITPUB个人空间h\
OD?oB-{'sNva
input datafile fno=00005 name=D:ORACLEORADATAPAULUSERS01.DBF
&a,jXggB0
"w8tZ;QO:_i0
?U3?0R;z+xp0channel ORA_DISK_1: starting piece 1 at 21-DEC-07