{"id":1026,"date":"2016-02-11T14:32:30","date_gmt":"2016-02-11T06:32:30","guid":{"rendered":"http:\/\/www.821121.com\/?p=1026"},"modified":"2020-12-11T14:33:39","modified_gmt":"2020-12-11T06:33:39","slug":"%e6%9f%a5%e8%af%a2rman%e5%a4%87%e4%bb%bd%e4%bf%a1%e6%81%af%e5%b8%b8%e7%94%a8%e6%8c%87%e4%bb%a4","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1026","title":{"rendered":"\u67e5\u8be2rman\u5907\u4efd\u4fe1\u606f\u5e38\u7528\u6307\u4ee4"},"content":{"rendered":"

----\u767b\u9646\u5230rman<\/p>\n

$rman target \/<\/p>\n

----\u4ee5\u7cbe\u7b80\u7684\u683c\u5f0f\u67e5\u770b\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list backup of database summary;<\/p>\n

RMAN> list backup of database;<\/p>\n

----\u67e5\u770b\u5907\u4efd\u8be6\u7ec6\u4fe1\u606f<\/p>\n

----BS Key\uff1a\u5907\u4efd\u96c6\u53f7<\/p>\n

----Type\uff1a\u5907\u4efd\u7c7b\u578b\uff0cIncr\u4ee3\u8868\u589e\u91cf\u5907\u4efd<\/p>\n

----LV\uff1a\u5907\u4efd\u7ea7\u522b\uff0c\u59821\u7ea7\u5907\u30010\u7ea7\u5907\u4efd<\/p>\n

----Size\uff1a\u5927\u5c0f<\/p>\n

----Device Type\uff1a\u8bbe\u5907\u7c7b\u578b\uff0cDISK\u4ee3\u8868\u78c1\u76d8<\/p>\n

----Elapsed Time\uff1a\u6d88\u8017\u65f6\u95f4<\/p>\n

----Completion Time\uff1a\u5b8c\u6210\u65f6\u95f4<\/p>\n

----BP Key\uff1a\u5907\u4efd\u7247\u53f7<\/p>\n

----Status:\u00a0\u5907\u4efd\u72b6\u6001\uff0cAVAILABLE\u4ee3\u8868\u53ef\u7528\u00a0<\/p>\n

----Compressed:\u00a0\u662f\u5426\u538b\u7f29\uff0cYES\u4ee3\u8868\u5df2\u7ecf\u538b\u7f29\u00a0<\/p>\n

----Tag:\u6807\u7b7e\uff0c\u9ed8\u8ba4\u4f1a\u4ee5\u65f6\u95f4\u683c\u5f0f\u5217\u51fa\uff0c\u5982\u00a0TAG20140526T151509\u4ee3\u88682014\u5e745\u670826\u65e5\uff0c15:15\u8fdb\u884c\u7684\u5907\u4efd<\/p>\n

----Piece Name:\u00a0\u5907\u4efd\u7247\u7684\u7269\u7406\u8def\u5f84\uff0c\u5982\/backup\/level1_25p98sfu_1_1.bak<\/p>\n

----List of Datafilesin backup set 1091\uff1a\u5217\u51fa1091\u53f7\u5907\u4efd\u7247\u5907\u4efd\u7684\u6570\u636e\u6587\u4ef6\u4fe1\u606f<\/p>\n

----Ckp SCN\uff1a\u6570\u636e\u6587\u4ef6\u7684scn\u53f7<\/p>\n

----Ckp Time\uff1a\u751f\u4ea7\u68c0\u67e5\u70b9\u65f6\u95f4<\/p>\n

----\u68c0\u67e5\u5f52\u6863\u65e5\u5fd7\u7684\u8fde\u7eed\u6027<\/p>\n

RMAN> crosscheck archivelog all;<\/p>\n

----\u5220\u9664\u8fc7\u671f\u7684\u5f52\u6863\uff0c\u5982\u679c\u6709\u6267\u884c\u64cd\u4f5c<\/p>\n

RMAN> deleteexpired archivelog all;<\/p>\n

----\u67e5\u770brman\u5907\u4efd\u7684\u5f52\u6863\u4fe1\u606f<\/p>\n

RMAN> list backup of archivelog all;<\/p>\n

----\u67e5\u770b\u63a7\u5236\u6587\u4ef6\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list backup of controlfile;<\/p>\n

----\u67e5\u770b\u955c\u50cf\u6587\u4ef6\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list copy;<\/p>\n

---\u67e5\u770b\u53c2\u6570\u6587\u4ef6\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list backup of spfile;<\/p>\n

----\u67e5\u770b\u6570\u636e\u5e93\u7269\u7406\u7ed3\u6784<\/p>\n

RMAN> report schema;<\/p>\n

----\u67e5\u770b\u9700\u8981\u5907\u4efd\u7684\u6587\u4ef6\u4fe1\u606f<\/p>\n

RMAN> report need backup;<\/p>\n

----\u67e5\u770brman\u914d\u7f6e\u4fe1\u606f<\/p>\n

RMAN> show all;<\/p>\n

----\u67e5\u770b\u8fc7\u65f6\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> report obsolete;<\/p>\n

----\u67e5\u770b\u524d1\u5929\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list backup of archivelog untiltime ='sysdate -1';<\/p>\n

---\u67e5\u770buser\u8868\u7a7a\u95f4\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list backup of tablespace users;<\/p>\n

----\u67e5\u770b\u6587\u4ef6\u53f7\u4e3a1\u7684\u5907\u4efd\u4fe1\u606f<\/p>\n

RMAN> list backup of datafile 1;<\/p>\n

----\u5907\u4efdsystem\u8868\u7a7a\u95f4<\/p>\n

RMAN> backup tablespace SYSTEM;<\/p>\n","protected":false},"excerpt":{"rendered":"

—-\u767b\u9646\u5230rman $rman target <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,18,36,37],"tags":[],"class_list":["post-1026","post","type-post","status-publish","format-standard","hentry","category-oracle-10g","category-oracle-11g","category-36","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1026","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1026"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1026\/revisions"}],"predecessor-version":[{"id":1027,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1026\/revisions\/1027"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1026"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}