{"id":984,"date":"2012-07-05T23:52:40","date_gmt":"2012-07-05T15:52:40","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=984"},"modified":"2012-07-08T19:29:14","modified_gmt":"2012-07-08T11:29:14","slug":"10g-rman%e7%9a%84redundancy%e7%ad%96%e7%95%a5%e6%94%b9%e5%8f%98","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=984","title":{"rendered":"10g RMAN\u7684REDUNDANCY\u7b56\u7565\u6539\u53d8"},"content":{"rendered":"<p>\u6700\u8fd1\u53d1\u73b010g\u7684RMAN\u5907\u4efd\u4fdd\u7559REDUNDANCY\u7b56\u7565\u548c9i\u76f8\u6bd4\u53d1\u751f\u4e86\u6539\u53d8\u3002<br \/>\n\u5728Oracle9i\u4e2d\uff0c\u5907\u4efd\u4fdd\u7559\u7b56\u7565\u7684REDUNDANCY\u7684\u503c\uff0c\u6307\u7684\u662f\u5907\u4efd\u5197\u4f59\u7684\u4e2a\u6570\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u5982\u679cREDUNDANCY\u8bbe\u7f6e\u4e3a1\uff0c\u90a3\u4e48Oracle\u4f1a\u4fdd\u75592\u4e2a\u5907\u4efd\u3002<br \/>\n\u4f46\u662f\u572810g\u4ee5\u540e\uff0cREDUNDANCY\u7684\u503c\uff0c\u5c31\u662f\u6700\u7ec8\u5907\u4efd\u4fdd\u7559\u7684\u503c\uff0c\u624b\u5934\u6ca1\u670910g\u7684\u73af\u5883\uff0c\u752811g\u7684rman\u505a\u4e86\u4e00\u4e2a\u4f8b\u5b50\uff1a<\/p>\n<pre lang='SQL'>solaris*orcl-\/home\/oracle$ rman target \/\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Sun Jul 8 19:04:43 2012\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\nconnected to target database: ORCL (DBID=1299676637)\r\nRMAN> show retention policy;\r\nusing target database control file instead of recovery catalog\r\nRMAN configuration parameters for database with db_unique_name ORCL are:\r\nCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\r\nRMAN> backup tablespace ts_32k;\r\nStarting backup at 08-JUL-12\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=180 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_ts_32k_7w1w3zmb_.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 08-JUL-12\r\nchannel ORA_DISK_1: finished piece 1 at 08-JUL-12\r\npiece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORCL\/backupset\/2012_07_08\/o1_mf_nnndf_TAG20120708T190559_7zltdqxy_.bkp tag=TAG20120708T190559 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 08-JUL-12\r\nRMAN> backup tablespace ts_32k;\r\nStarting backup at 08-JUL-12\r\nusing channel ORA_DISK_1\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_ts_32k_7w1w3zmb_.dbf\r\nchannel ORA_DISK_1: starting piece 1 at 08-JUL-12\r\nchannel ORA_DISK_1: finished piece 1 at 08-JUL-12\r\npiece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORCL\/backupset\/2012_07_08\/o1_mf_nnndf_TAG20120708T190609_7zltf22b_.bkp tag=TAG20120708T190609 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02\r\nFinished backup at 08-JUL-12\r\nRMAN> list backup of tablespace ts_32k;\r\n\r\nList of Backup Sets\r\n===================\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n20      Full    2.69M      DISK        00:00:01     08-JUL-12      \r\n        BP Key: 20   Status: AVAILABLE  Compressed: NO  Tag: TAG20120708T190559\r\n        Piece Name: \/u01\/app\/oracle\/flash_recovery_area\/ORCL\/backupset\/2012_07_08\/o1_mf_nnndf_TAG20120708T190559_7zltdqxy_.bkp\r\n  List of Datafiles in backup set 20\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  5       Full 28932281   08-JUL-12 \/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_ts_32k_7w1w3zmb_.dbf\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ ---------------\r\n21      Full    2.69M      DISK        00:00:01     08-JUL-12      \r\n        BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20120708T190609\r\n        Piece Name: \/u01\/app\/oracle\/flash_recovery_area\/ORCL\/backupset\/2012_07_08\/o1_mf_nnndf_TAG20120708T190609_7zltf22b_.bkp\r\n  List of Datafiles in backup set 21\r\n  File LV Type Ckp SCN    Ckp Time  Name\r\n  ---- -- ---- ---------- --------- ----\r\n  5       Full 28932300   08-JUL-12 \/u01\/app\/oracle\/oradata\/ORCL\/datafile\/o1_mf_ts_32k_7w1w3zmb_.dbf\r\nRMAN> delete obsolete;\r\nRMAN retention policy will be applied to the command\r\nRMAN retention policy is set to redundancy 1\r\nusing channel ORA_DISK_1\r\nDeleting the following obsolete backups and copies:\r\nType                 Key    Completion Time    Filename\/Handle\r\n-------------------- ------ ------------------ --------------------\r\nBackup Set           20     08-JUL-12         \r\n  Backup Piece       20     08-JUL-12          \/u01\/app\/oracle\/flash_recovery_area\/ORCL\/backupset\/2012_07_08\/o1_mf_nnndf_TAG20120708T190559_7zltdqxy_.bkp\r\nDo you really want to delete the above objects (enter YES or NO)? yes\r\ndeleted backup piece\r\nbackup piece handle=\/u01\/app\/oracle\/flash_recovery_area\/ORCL\/backupset\/2012_07_08\/o1_mf_nnndf_TAG20120708T190559_7zltdqxy_.bkp RECID=20 STAMP=788123159\r\nDeleted 1 objects<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u4ece10g\u5f00\u59cb\u8bbe\u7f6e\u7684REDUNDANCY\u7684\u503c\uff0c\u5c31\u662f\u6700\u7ec8\u5907\u4efd\u4fdd\u7559\u7684\u4e2a\u6570\u3002\u4e3a\u4e86\u786e\u8ba4\u8fd9\u4e2a\u95ee\u9898\uff0c\u7279\u610f\u67e5\u8be2\u4e86\u4e00\u4e0b9i\u548c10g\u7684\u5b98\u65b9\u6587\u6863\u3002<br \/>\n9i\u7684\u8bf4\u6cd5\u662f\uff1a<\/p>\n<pre lang='SQL'>The REDUNDANCY parameter specifies that any number of backups or copies beyond a specified number need not be retained.<\/pre>\n<p>\u800c10g\u7684\u6587\u6863\u4e2d\uff0c\u8be5\u53c2\u6570\u7684\u63cf\u8ff0\u53d8\u4e3a\uff1a<\/p>\n<pre lang='SQL'>A redundancy-based backup retention policy determines whether a backup is obsolete based on how many backups of a file are currently on disk.<\/pre>\n<p>Oracle\u6539\u53d8\u529f\u80fd\u7684\u5b9e\u73b0\u5f88\u5e38\u89c1\uff0c\u4f46\u662f\u6ca1\u6709\u60f3\u5230\uff0c\u5bf9\u4e8e\u8fd9\u79cd\u7ec6\u8282\u7684\u5b9a\u4e49\u4e5f\u4f1a\u8c03\u6574\u3002\u5bf9\u4e8e\u719f\u60899i\u5907\u4efd\u7b56\u7565\u7684DBA\u9700\u8981\u7559\u795e\uff0c\u5728\u8bbe\u7f6e10g\u4ee5\u540e\u7684RMAN\u5907\u4efd\u4fdd\u7559\u7b56\u7565\u65f6\uff0c\u9700\u8981\u57289i\u7684\u57fa\u7840\u4e0a\u589e\u52a01\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6700\u8fd1\u53d1\u73b010g\u7684RMAN\u5907\u4efd\u4fdd\u7559REDUNDANCY\u7b56\u7565\u548c9i\u76f8\u6bd4\u53d1\u751f\u4e86\u6539\u53d8\u3002 \u5728Oracle9i\u4e2d\uff0c\u5907\u4efd\u4fdd\u7559\u7b56\u7565\u7684REDUNDANCY\u7684\u503c\uff0c\u6307\u7684\u662f\u5907\u4efd\u5197\u4f59\u7684\u4e2a\u6570\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u5982\u679cREDUNDANCY\u8bbe\u7f6e\u4e3a1\uff0c\u90a3\u4e48Oracle\u4f1a\u4fdd\u75592\u4e2a\u5907\u4efd\u3002 \u4f46\u662f\u572810g\u4ee5\u540e\uff0cREDUNDANCY\u7684\u503c\uff0c\u5c31\u662f\u6700\u7ec8\u5907\u4efd\u4fdd\u7559\u7684\u503c\uff0c\u624b\u5934\u6ca1\u670910g\u7684\u73af\u5883\uff0c\u752811g\u7684rman\u505a\u4e86\u4e00\u4e2a\u4f8b\u5b50\uff1a solaris*orcl-\/home\/oracle$ rman target \/ Recovery Manager: Release 11.2.0.3.0 &#8211; Production on Sun Jul 8 19:04:43 2012 Copyright (c) 1982, 2011, Oracle and\/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1299676637) RMAN> show retention policy; &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=984\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[842,841,844,845,843,98],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-fS","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/984"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=984"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/984\/revisions"}],"predecessor-version":[{"id":985,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/984\/revisions\/985"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}