学习oracle技术,每天学一点,每天进步一点

rman backup database force 功能

上一篇 / 下一篇  2007-12-21 08:50:36 / 个人分类:rman备份与恢复

FORCEITPUB个人空间9\)n#{G K$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个人空间r3acBn%`$_ Ba
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultITPUB个人空间 Wv'{\J'u
CONFIGURE BACKUP OPTIMIZATION ON;

SQLalter tablespace tools read only;ITPUB个人空间x$F.i8] @nqN4T0D6Mc
ITPUB个人空间CG.dA O n%M
ITPUB个人空间X.Ux4rX-@qN4v

~E u(S0uBT0ITPUB个人空间 d'gQ:j0u A
ITPUB个人空间"Bla P)n
Tablespace altered.ITPUB个人空间p N)BT1WTi;d)u(@t

$H1f*phc0
[,rCr8| R o0
RMANbackup tablespace tools;ITPUB个人空间H2Ij%h#i.TgTC7o

#T8R9_]5f7f}_] {0ITPUB个人空间ca*ltzZ,b

{t3c;q)j0
-PB0G;Fhq L7dA0
$IGh A`CCY0
Starting backup at 21-DEC-07ITPUB个人空间"?7F7a0FHJxF
ITPUB个人空间$admRO
ITPUB个人空间kJ[%I0L{!_yE+V0q
using channel ORA_DISK_1
)ZDU6y9Vz)t0ITPUB个人空间L1^b5b J
ITPUB个人空间C/MK no$u5o
channel ORA_DISK_1
starting full datafile backupset
8[X;Xn:E-]},qV0
D {7ut4s(X0
6rn6]-]q0b0channel ORA_DISK_1
specifying datafile(sin 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 completeelapsed time00:00:01
|,YG7\&j@bqT;R0ITPUB个人空间OB-X)SM3Z~
ITPUB个人空间2m W'DVfZbTR_1hS
Finished backup at 21
-DEC-07
}"KI%k NmbJY0ITPUB个人空间B#e v\6|$E
ITPUB个人空间}Y q8G;x,BbN!~8n _

&|5c EMk0
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个人空间.q My&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%P oO0ITPUB个人空间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
9clXc;CY0
2xOWIk?0ITPUB个人空间s0i'x@n&n^qZ
using channel ORA_DISK_1ITPUB个人空间2_)o;PqF+e
ITPUB个人空间}bWPe'a

'iDBT/b0skipping datafile 4
already backed up 3 time(s)
)K h(w\Dk-Z/~0ITPUB个人空间-i O1C}!{xx1_tK

P mwx/jK0
channel ORA_DISK_1starting full datafile backupsetITPUB个人空间}.L9R@M Hg|#h3w

%?!mM0lI]C q%a9C0ITPUB个人空间R;V Y `"~9l9l
channel ORA_DISK_1
specifying datafile(sin backupset
a0VSRA0P?^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 ~7a qM2wiD+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-{'sN va
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
j v Us\:n0ITPUB个人空间H2fq$fV0[
ITPUB个人空间B4^6f4s.et_n
channel ORA_DISK_1
finished piece 1 at 21-DEC-07ITPUB个人空间0Kzez4I hn"|a&z}8Z

X9^ PoQ7X%p%_0
d%{8Gp3n5F,I7L3Yc0piece handle
=D:BACKUP3KJ454M1_1_1 comment=NONEITPUB个人空间0sA%U1S+|{ m/k
ITPUB个人空间l5QP*Qs@&a'c"Z

#P2H$csM9Xj^0channel ORA_DISK_1
backup set completeelapsed time00:00:45ITPUB个人空间{(eO"Bo%FAm

G&c s0q`.a U0
dEBZ)|E%j:G0Finished backup at 21
-DEC-07
r4W8^)Qp R];uM A0ITPUB个人空间.r)gDK8A6`V ^
ITPUB个人空间Y3s H p }0t)Rz{
ITPUB个人空间`)f:x K7Q*Y`$? n
ITPUB个人空间{v7HPGS*s8R
ITPUB个人空间aXKG6?-d
Starting Control File 
and SPFILE Autobackup at 21-DEC-07ITPUB个人空间(zF2h.TD0]*e/w

^3VeHV2Y(ZT J0
6|K,b\lE0piece handle
=D:BACKUPC-1605165889-20071221-04 comment=NONE
oyDyud le1|0ITPUB个人空间'}&qtaF5gg1Bu
ITPUB个人空间U&kZ R/E0U dA(]
Finished Control File 
and SPFILE Autobackup at 21-DEC-07
9h_YS)w6PKMM0
,Y.z&emrMrn0
])H8p/Gs9m0
3a0W5E0|!l5h5t,?I0ITPUB个人空间_!?U1J2_1E.e
ITPUB个人空间~o+ZH(sZuV
RMAN
backup database force;
P/h7D dI9^3z0
m'c"Z,m-A6h%^x){0
pl3SJ"r2]s9S'ZW0ITPUB个人空间rr|3RL!q-uL I1W-~ @

mv[}[0ITPUB个人空间q,BWQE-Za
Starting backup at 21-DEC-07
&gn7@Vq4E]1G+|0
;WIF:J5dZlqM0
#E3p:Di5?.Z-nr9_0using channel ORA_DISK_1ITPUB个人空间;_:AZNJw0oTo
ITPUB个人空间-k\ a L%J"Mg;D

}]!y{8K0channel ORA_DISK_1
starting full datafile backupsetITPUB个人空间KM sx1LY%|5|
ITPUB个人空间bk"t%jsq k

t&|E-ryXE/ap_:`0channel ORA_DISK_1
specifying datafile(sin backupset
6KCKrwNdc0ITPUB个人空间 IL+iF"Lxx{M?*t7Q
ITPUB个人空间8~JdYZc h|:g)}
input datafile fno
=00001 name=D:ORACLEORADATAPAULSYSTEM01.DBFITPUB个人空间6Fw@@.iyUco
ITPUB个人空间;|:~c'IBh/f
ITPUB个人空间Du'x4\,b1a4dyo*}`
input datafile fno
=00002 name=D:ORACLEORADATAPAULUNDOTBS01.DBFITPUB个人空间S&L:fWHn'q F
ITPUB个人空间;Y1zrA6\.K GG

f&Nv-u.v:_dz0input datafile fno
=00003 name=D:ORACLEORADATAPAULINDX01.DBF
5s5o6yL&mN e0ITPUB个人空间7mW YT;nr

8q0PO7D7x%?C2]"g7N0input datafile fno
=00005 name=D:ORACLEORADATAPAULUSERS01.DBF
`uM4[ |0
Y-g*FW#Qd Tb-yj0
#M pA:Xr4L0input datafile fno
=00004 name=D:ORACLEORADATAPAULTOOLS01.DBF
:_\P/\kZN_0ITPUB个人空间 XE.Yj8\ a:U8u
ITPUB个人空间c1bNfV1O5S @
channel ORA_DISK_1
starting piece 1 at 21-DEC-07
W6NC"uQ0
Vd7})\RR*f#D0ITPUB个人空间h]@ U5x9j,zA~
channel ORA_DISK_1
finished piece 1 at 21-DEC-07ITPUB个人空间A%|g |.~'G

)l1wW1q\)vU"fp0ITPUB个人空间,ZGL^5o K
piece handle
=D:BACKUP3MJ454NL_1_1 comment=NONE
,ZU&s2a+U0
!K]d:I1e8U9c0
&UT.O gs `0channel ORA_DISK_1
backup set completeelapsed time00:00:55ITPUB个人空间~9t5@h fl` qS

,|eL+b\*zo%}0ITPUB个人空间.\,[8xLzA[W
Finished backup at 21
-DEC-07ITPUB个人空间rT/]rA

Q uG{yt-J{0ITPUB个人空间g9LS.V oQg

0d8vz!XC0ITPUB个人空间A9c0m8f4Jht|9H

7X8i bos5nk:|9Dk0Starting Control File 
and SPFILE Autobackup at 21-DEC-07ITPUB个人空间4yY#@)c1d O7f}

fEQ%l m+r8O0ITPUB个人空间3~:P#ZPE v|bU5cR
piece handle
=D:BACKUPC-1605165889-20071221-05 comment=NONEITPUB个人空间z&~Yg3dx'\2Xmp

nbHms-D0
vi4b^*k,if0Finished Control File 
and SPFILE Autobackup at 21-DEC-07
qp(i^M+Q fi&r0ITPUB个人空间eyx"{Sm

q]d0cI$J b0ITPUB个人空间Uwmb,@(k\

{1^ LT-c3Ts([0
Dy4ZY4p'jT{0RMAN
>ITPUB个人空间5K'mk"]6d7Z
ITPUB个人空间!I:F[.DXH;XEi


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-10-13  
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 20359
  • 日志数: 291
  • 图片数: 2
  • 建立时间: 2007-12-11
  • 更新时间: 2008-10-04

RSS订阅

Open Toolbar