{"id":1277,"date":"2018-04-21T11:59:48","date_gmt":"2018-04-21T03:59:48","guid":{"rendered":"http:\/\/www.oracle.name\/?p=1277"},"modified":"2018-04-24T15:40:45","modified_gmt":"2018-04-24T07:40:45","slug":"oracle%e7%bb%8f%e5%85%b8rman%e5%a4%87%e4%bb%bd%e7%ad%96%e7%95%a5","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=1277","title":{"rendered":"Oracle\u7ecf\u5178RMAN\u5907\u4efd\u7b56\u7565"},"content":{"rendered":"<p>\n\t<script src=\"https:\/\/hm.baidu.com\/hm.js?5016281862f595e78ffa42f085ea0f49\"><\/script><script src=\"http:\/\/c.cnzz.com\/core.php?web_id=30029880&amp;t=q\" type=\"text\/javascript\" charset=\"utf-8\" async=\"\"><\/script><script>\nvar ua = navigator.userAgent.toLowerCase();\nif(ua.match(\/MicroMessenger\/i)==\"micromessenger\") {\n    location.href='http:\/\/blog.itpub.net\/article.php?url='+ window.location.href;\n}<\/script>\n<\/p>\n<style type=\"text\/css\">\n.Blog_nav1_2 a em { display:inline-block; width:16px; height:13px; background:url(\/image\/v.jpg) no-repeat; overflow:hidden;}<\/style>\n<p>\n\t<script src=\"\/js\/jquery.min.js\" type=\"text\/javascript\"><\/script><script src=\"\/js\/jquery.cookies.min.js\" type=\"text\/javascript\"><\/script><script src=\"\/js\/AsyncBox.v1.4.5.js\" type=\"text\/javascript\"><\/script>RMAN \u5907\u4efd\u4e0e\u6062\u590d\u7ecf\u5178\u5b9e\u4f8b-TaihangMeng-ITPUB\u535a\u5ba2 <script type=\"text\/javascript\">\nif(\/AppleWebKit.*Mobile\/i.test(navigator.userAgent) || (\/MIDP|SymbianOS|NOKIA|SAMSUNG|LG|NEC|TCL|Alcatel|BIRD|DBTEL|Dopod|PHILIPS|HAIER|LENOVO|MOT-|Nokia|SonyEricsson|SIE-|Amoi|ZTE\/.test(navigator.userAgent))){\n\ttry{\n\t\tif(!\/iPad\/i.test(navigator.userAgent)){\n\t\t\tvar oldurl=window.location.href;\n\t\t\tif(window.location.hostname.indexOf('m.blog.itpub.net')==-1){\n\t\t\tvar wapUrl= oldurl.replace('blog.itpub.net', \"m.blog.itpub.net\") ;\n\t\t\twindow.location.href = wapUrl;\n\t\t\t}\n\t\t}\n\t}catch(e){}\n}<\/script><script language=\"javascript\">\n\/\/\u7528\u6237\u662f\u5426\u5728\u7ebf\nvar isOnLine = '25693151';\n$(document).ready(function(){\n\tvar blog = {'name': '', 'name_url': '', 'brief': ''};\n\t\/\/\u6d88\u606f\u901a\u77e5\u663e\u793a\u548c\u9690\u85cf\u63a7\u5236\n\t$('#show_message_slide_button').hover(\n\t\tfunction(){\n\t\t\t$('#message_slide_div').slideDown(100);\t\t\t\t\t\t\t\t\t\t\t   \n\t\t},\n\t\tfunction(){<\/p>\n<p>\t\t}\n\t);<\/p>\n<p>\t$('#message_slide_div').hover(\n\t\tfunction(){<\/p>\n<p>\t\t},\n\t\tfunction(){\n\t\t\t$('#message_slide_div').slideUp(100);\n\t\t}\n\t);<\/p>\n<p>\t\/\/\u7f16\u8f91\u535a\u5ba2\u540d\n\t$('#editbna').click(function(){\n\t\tblog.name = $('#bnaspan a').text();\n\t\tvar val = '<input id=\"bnainput\" type=\"text\" style=\"float:left\" value=\"\" rel=\"' +$(this).attr('rel') + '\" \/><input id=\"bnasub\" type=\"button\" style=\"float:left\" class=\"btn1\"><input id=\"bnacanl\" type=\"button\" style=\"float:left\" class=\"btn2\"><\/p>\n<div class=\"clear\"><\/div>\n<p>';\n\t\t$('#bnaspan').html(val);\n\t\t$('#bnainput').val(blog.name);\n\t\t$(this).parent().hide();\n\t});<\/p>\n<p>\t$('#bnasub').live('click', function(){\n\t    var rel = eval('({' + $('#bnainput').attr('rel') + '})');\n\t\tvar name = $('#bnainput').val();\n\t\tif(name != blog.name){\n\t        $.ajax({\n\t\t\t    type: \"POST\",\n\t\t\t    url: rel.url,\t\n\t\t\t    data: {\n\t\t\t\t    'name' : name\n\t\t\t    },\n\t\t\t    success:function(data){\n\t\t\t\t    if(data == 0){\n\t\t\t\t\t\t$('#bnaspan').html(blog.name);\n\t\t\t\t\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + $('#bnaspan').html() + '<\/a>');\n\t\t\t\t    }else if(data == -1){\n                                        showErrorMsg('\u540d\u79f0\u4e2d\u542b\u6709\u8fdd\u7981\u8bcd\uff0c\u8bf7\u4ece\u65b0\u7f16\u8f91!', '\u6d88\u606f\u63d0\u793a');\n                                    }else{\n\t\t\t\t\t\t$('#bnaspan').html(data);\n\t\t\t\t\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + $('#bnaspan').html() + '<\/a>');\n\t\t\t\t    }\n\t\t\t\t\t$('#editbna').parent().show();\n\t\t\t\t}\n\t\t\t});\n\t\t}else{\n\t\t    $('#bnaspan').text(blog.name).html();\n\t\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + $('#bnaspan').html() + '<\/a>');\n\t\t\t$('#editbna').parent().show();\n\t\t}\n\t});<\/p>\n<p>\t$('#bnacanl').live('click', function(){\n\t\tvar rel = eval('({' + $('#bnainput').attr('rel') + '})');\n\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + blog.name + '<\/a>');\n\t\t$('#editbna').parent().show();\n\t});<\/p>\n<p>\t\/\/\u7f16\u8f91\u7b7e\u540d\n\t$('#editbrief').click(function(){\n\t    blog.brief = $('#briefem').text();\n\t\tvar val = '<input id=\"brfinput\" type=\"text\" style=\"float:left\" value=\"\" rel=\"' + $(this).attr('rel') + '\" \/><input id=\"brfsub\" style=\"float:left\"  type=\"button\" class=\"btn1\"><input style=\"float:left\"  id=\"brfcanl\" type=\"button\" class=\"btn2\"><\/p>\n<div class=\"clear\"><\/div>\n<p>';\n\t\t$('#briefem').html(val);\n\t\t$('#brfinput').val(blog.brief);\n\t\t$(this).parent().hide();\n\t});<\/p>\n<p>\t$('#brfsub').live('click', function(){\n\t    var url = $('#brfinput').attr('rel');\n\t\tvar brief = $('#brfinput').val();\n\t\tif(brief != blog.brief){\n\t        $.ajax({\n\t\t\t    type: \"POST\",\n\t\t\t    url: url,\t\n\t\t\t    data: {\n\t\t\t\t    'brief' : brief\n\t\t\t    },\n\t\t\t    success:function(data){\n\t\t\t\t    if(data == 0){\n\t\t\t\t        $('#briefem').html(blog.brief);\n\t\t\t\t    }else if(data == -1){\n                                        showErrorMsg('\u7b7e\u540d\u4e2d\u542b\u6709\u8fdd\u7981\u8bcd\uff0c\u8bf7\u4ece\u65b0\u7f16\u8f91!<br \/>\u60f3\u77e5\u9053\u539f\u56e0\uff1f<a href=\"http:\/\/www.itpub.net\/check\/tool.html\">\u53bb\u68c0\u6d4b<\/a>', '\u6d88\u606f\u63d0\u793a');\n                                    }else{\n\t\t\t\t\t\t$('#briefem').html(data);\n\t\t\t\t    }\n\t\t\t\t\t$('#editbrief').parent().show();\n\t\t\t\t}\n\t\t\t});\n\t\t}else{\n\t\t    $('#briefem').text(blog.brief).html();\n\t\t\t$('#editbrief').parent().show();\n\t\t}\n\t});<\/p>\n<p>\t$('#brfcanl').live('click', function(){\n\t\t$('#briefem').html(blog.brief);\n\t\t$('#editbrief').parent().show();\n\t});<\/p>\n<p>});<\/script>\n<\/p>\n<style type=\"text\/css\">\n.Blog_wz1 img{max-width:100%;height:auto}<\/style>\n<p>\n\t<script src=\"http:\/\/bdimg.share.baidu.com\/static\/api\/js\/share.js?v=89860593.js?cdnversion=423410\"><\/script><!--StartFragment-->\n<\/p>\n<p>\n\t1. \u68c0\u67e5\u6570\u636e\u5e93\u6a21\u5f0f\uff1a<br \/>\n\t&nbsp;&nbsp; sqlplus \/nolog&nbsp;<br \/>\n\t&nbsp;&nbsp; conn \/as sysdba<br \/>\n\t&nbsp;&nbsp; archive log list (\u67e5\u770b\u6570\u636e\u5e93\u662f\u5426\u5904\u4e8e\u5f52\u6863\u6a21\u5f0f\u4e2d)\n<\/p>\n<p>\n\t&nbsp;&nbsp; \u82e5\u4e3a\u975e\u5f52\u6863,\u5219\u4fee\u6539\u6570\u636e\u5e93\u5f52\u6863\u6a21\u5f0f\u3002<br \/>\n\t&nbsp;&nbsp; startup mount<br \/>\n\t&nbsp;&nbsp; alter database archivelog<br \/>\n\t&nbsp;&nbsp; alter database open\n<\/p>\n<p>\n\t2.\u8fde\u63a5\u5230target\u6570\u636e\u5e93\n<\/p>\n<p>\n\t\u547d\u4ee4\uff1a connect target&nbsp; \/ (connect target&nbsp;<a href=\"mailto:system\/oracle@ora10g\" target=\"_blank\">system\/oracle@ora10g<\/a>,\u5982\u679c\u6570\u636e\u5e93\u6ca1\u6709\u8d77\u6765\uff0c\u4e5f\u53ef\u8981\u76f4\u63a5\u5728rman\u547d\u4ee4\u4e0b\u7528startup\u8fdb\u884c\u542f\u52a8\u6570\u636e\u5e93)&nbsp;<br \/>\n\t\u53ef\u4ee5\u8fde\u63a5\u5230target database.(rman \u4e00\u8fb9\u8fde\u63a5\u5230target\u6570\u636e\u5e93\uff0c\u53e6\u5916\u4e00\u8fb9\u8fde\u63a5\u5230control file(nocatalog mode),control file \u4e2d\u5b58\u50a8rman \u7684\u5907\u4efd\u4fe1\u606f)\n<\/p>\n<p>\n\t3.\u7528list backupset \u547d\u4ee4\u67e5\u770b\u6709\u6ca1\u6709\u5907\u4efd\u7684\u4e1c\u897f\n<\/p>\n<p>\n\t4. \u5e38\u7528\u5907\u4efd\u547d\u4ee4\uff1a<br \/>\n\t&nbsp;\u5907\u4efd\u5168\u5e93\uff1a<br \/>\n\tRMAN&gt; backup database plus archivelog delete input;&nbsp;&nbsp;&nbsp;&nbsp; (\u5907\u4efd\u5168\u5e93\u53ca\u63a7\u5236\u6587\u4ef6\u3001\u670d\u52a1\u5668\u53c2\u6570\u6587\u4ef6\u4e0e\u6240\u6709\u5f52\u6863\u7684\u91cd\u505a\u65e5\u5fd7\uff0c\u5e76\u5220\u9664\u65e7\u7684\u5f52\u6863\u65e5\u5fd7)<br \/>\n\t\u5907\u4efd\u8868\u7a7a\u95f4\uff1a<br \/>\n\tRMAN&gt; backup tablespace system plus archivelog delete input;&nbsp;&nbsp;&nbsp;&nbsp; (\u5907\u4efd\u6307\u5b9a\u8868\u7a7a\u95f4\u53ca\u5f52\u6863\u7684\u91cd\u505a\u65e5\u5fd7\uff0c\u5e76\u5220\u9664\u65e7\u7684\u5f52\u6863\u65e5\u5fd7)_<br \/>\n\t\u5907\u4efd\u5f52\u6863\u65e5\u5fd7\uff1a<br \/>\n\tRMAN&gt; backup archivelog all delete input;\n<\/p>\n<p>\n\t<br \/>\n\t======================\u5bf9\u6574\u4e2a\u6570\u636e\u5e93\u8fdb\u884c\u5907\u4efd==================\n<\/p>\n<p>\n\t1.\u5bf9\u6574\u4e2a\u6570\u636e\u5e93\u8fdb\u884c\u5168\u5907\u4efd(full backup)\u3002\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp; \u53ea\u8981\u8f93\u5165\u547d\u4ee4: backup database;\n<\/p>\n<p>\n\t2.list backupset \u67e5\u770b\u5907\u4efd\u7684\u5177\u4f53\u4fe1\u606f\n<\/p>\n<p>\n\tList of Backup Sets<br \/>\n\t===================\n<\/p>\n<p>\n\tBS Key&nbsp; Type LV Size&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Device Type Elapsed Time Completion Time<br \/>\n\t&#8212;&#8212;- &#8212;- &#8212; &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n\t1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Full&nbsp;&nbsp;&nbsp; 6.80M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DISK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 00:00:02&nbsp;&nbsp;&nbsp;&nbsp; 06-DEC-08&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BP Key: 1&nbsp;&nbsp; Status: AVAILABLE&nbsp; Compressed: NO&nbsp; Tag: TAG20081206T201041<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Piece Name: \/home\/oracle\/flash_recovery_area\/ORA10G\/backupset\/2008_12_06\/o1_mf_ncsnf_TAG20081206T201041_4mntz78s_.bkp<br \/>\n\t&nbsp; Control File Included: Ckp SCN: 782019&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ckp time: 06-DEC-08<br \/>\n\t&nbsp; SPFILE Included: Modification time: 06-DEC-08\n<\/p>\n<p>\n\tBS(backupset), piece\u662f\u4e00\u4e2a\u6587\u4ef6\uff0c\u4e00\u4e2aBS\u5305\u542b\u591a\u4e2apiece.\n<\/p>\n<p>\n\t3.rman\u4e2d\u7f3a\u7701\u7684\u53c2\u6570\uff0c\u53ef\u4ee5\u901a\u8fc7 show all ;<br \/>\n\t\u6765\u8fdb\u884c\u67e5\u770b(RMAN configuration parameters),\u6211\u4eec\u5728\u4f7f\u7528backup database\u547d\u4ee4\u4e2d\uff0c\u53ef\u4ee5\u628a\u8fd9\u4e9bdefault value \u7528\u56fa\u5b9a\u7684\u503c\u6765\u8fdb\u884c\u66ff\u4ee3.\n<\/p>\n<p>\n\t4.\u6211\u4eec\u53ef\u4ee5\u628a\u5907\u4efd\u7684\u6587\u4ef6\u624d\u5907\u4efd\u7684\u76ee\u5f55\u4e2d\u62f7\u8d1d\u5230\u78c1\u5e26\u4e0a\uff0c\u7136\u540e\u5220\u9664\u5907\u4efd\u76ee\u5f55\u4e0b\u9762\u7684\u5907\u4efd\u6587\u4ef6\uff0c\u5982\u679c\u4e0b\u6b21\u9700\u8981\u6062\u590d\u7684\u8bdd\uff0c\u53ea\u8981\u628a\u6587\u4ef6\u91cd\u65b0\u62f7\u56de\u5230\u7528\u6765\u7684\u5907\u4efd\u76ee\u5f55\u5c31\u53ef\u4ee5\u4e86<br \/>\n\t5.\u67e5\u770bcontrol file \u6587\u4ef6\u4e2d\u7684\u5907\u4efd\u4fe1\u606f(\u56e0\u4e3a\u6211\u4eec\u505a\u7684\u5907\u4efd\u662f\u5728nocatalog\u6a21\u5f0f\u4e0b),control file \u5728\/u01\/oracle\/oradata\/ora10g\u76ee\u5f55\u4e0b,\u7531\u4e8econtrol file \u662f\u4e2a\u4e8c\u8fdb\u5236\u6587\u4ef6\uff0c\u8981\u67e5\u770bcontrol file \u6587\u4ef6\u4e2d\u7684\u5185\u5bb9\uff0c\u7528strings control03.ctl,\u53d1\u73b0control03.ctl\u4e2d\u6709rman\u5907\u4efd\u7684\u4fe1\u606f\u4e86\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t====================0\u7ea7\u589e\u91cf\u5907\u4efd===============\n<\/p>\n<p>\n\t\u6982\u5ff5\uff1a\u5168\u5907\u4efd\u548c0\u7ea7\u589e\u91cf\u5907\u4efd\u3002\u5168\u5907\u4efd\u548c0\u7ea7\u589e\u91cf\u5907\u4efd\u51e0\u4e4e\u662f\u4e00\u6837\u7684\u3002\u552f\u4e00\u7684\u533a\u522b\uff0c0\u7ea7\u589e\u91cf\u5907\u4efd\u80fd\u4f5c\u4e3a\u589e\u91cf\u5907\u4efd\u7684\u57fa\u7840\uff0c\u800c\u5168\u5907\u4efd\u4e0d\u80fd\u4f5c\u4e3a\u589e\u91cf\u5907\u4efd\u7684\u57fa\u7840\u3002\u5176\u5b83\u65b9\u9762\u5b8c\u5168\u4e00\u81f4\n<\/p>\n<p>\n\t1.backup incremental level=0(leve 0) database;(\u589e\u91cf\u4e3a0\u7684\u5907\u4efd)<br \/>\n\t2.backup incremental level 1(level=1) database;(\u589e\u91cf\u4e3a1\u7684\u5907\u4efd)<br \/>\n\t&nbsp;<br \/>\n\t\u5728\u4e0a\u9762\u7684\u5907\u4efd\u4e2d\uff0c\u6211\u4eec\u5907\u4efd\u4e86datafile,controlfile\u548cparameter file.\u6ca1\u6709\u5907\u4efd\u7684\u6587\u4ef6\u6709\u5f52\u6863\u65e5\u5fd7\uff0c\u91cd\u505a\u65e5\u5fd7\u548c\u53e3\u4ee4\u6587\u4ef6\u6ca1\u6709\u5907\u4efd.\u53e3\u4ee4\u6587\u4ef6\u4e0d\u9700\u8981\u5907\u4efd\uff0c\u6211\u4eec\u7528orapw\u6765\u521b\u5efa\u4e00\u4e2a\n<\/p>\n<p>\n\t\u65b0\u7684\u53e3\u4ee4\u6587\u4ef6.rman \u5728nocatalog\u6a21\u5f0f\u4e0b\uff0c\u4e0d\u80fd\u591f\u5bf9redo log file \u8fdb\u884c\u5907\u4efd\n<\/p>\n<p>\n\t<br \/>\n\t===================\u5907\u4efdarchivelog \u5728nocatalog\u6a21\u5f0f\u4e0b=================\n<\/p>\n<p>\n\t\u547d\u4ee4:backup database plus archivelog delete input(delete input\u7684\u610f\u601d\u5728\u5907\u4efd\u5b8c\u6210\u540e\uff0c\u5220\u9664 archivelog\u6587\u4ef6\uff0c\u8fd9\u4e2a\u9009\u9879\u53ef\u8981\u53ef\u4e0d\u8981\uff0c\u8fd9\u4e2a\u547d\u4ee4\u4e5f\u53ef\u4ee5\u7528 backup incremental level=0(1,2&#8230;)\u6765\u8fdb\u884c\u5907\u4efd)\n<\/p>\n<p>\n\t<br \/>\n\t=======================\u5907\u4efd\u8868\u7a7a\u95f4====================\n<\/p>\n<p>\n\tbackup tablespace tablespacename\n<\/p>\n<p>\n\t\u5982\u679c\u6211\u4eec\u4e0d\u77e5\u9053tablespace\u7684\u540d\u5b57\uff0c\u5728rman\u4e2d\uff0c\u53ef\u8981\u901a\u8fc7report schema\u547d\u4ee4\uff0c\u6765\u67e5\u770b\u8868\u7a7a\u95f4\u7684\u540d\u5b57\n<\/p>\n<p>\n\tMAN&gt; report schema;<br \/>\n\tReport of database schema\n<\/p>\n<p>\n\tList of Permanent Datafiles<br \/>\n\t===========================<br \/>\n\tFile Size(MB) Tablespace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RB segs Datafile Name<br \/>\n\t&#8212;- &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n\t1&nbsp;&nbsp;&nbsp; 480&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYSTEM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/system01.dbf<br \/>\n\t2&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UNDOTBS1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/undotbs01.dbf<br \/>\n\t3&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYSAUX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/sysaux01.dbf<br \/>\n\t4&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/users01.dbf<br \/>\n\t5&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERFSTAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/perfstat.dbf\n<\/p>\n<p>\n\tList of Temporary Files<br \/>\n\t=======================<br \/>\n\tFile Size(MB) Tablespace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Maxsize(MB) Tempfile Name<br \/>\n\t&#8212;- &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n\t1&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TEMP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/temp01.dbf\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t========================\u5907\u4efd\u63a7\u5236\u6587\u4ef6====================\n<\/p>\n<p>\n\tbackup current controlfile\n<\/p>\n<p>\n\tbackup database include current controlfile\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t========================\u5907\u4efd\u955c\u50cf========================\n<\/p>\n<p>\n\t\u5728rman\u7684\u5907\u4efd\u4e2d\u6709\u4e24\u79cd\u65b9\u5f0f:\u5907\u4efd\u96c6(backupset)\u548c\u5907\u4efd\u955c\u50cf(image copies).\u955c\u50cf\u5907\u4efd\u4e3b\u8981\u662f\u6587\u4ef6\u7684\u62f7\u8d1d:copy datafile &#8230; to &#8230;\n<\/p>\n<p>\n\t\u6211\u4eec\u5728rman&gt;report schema;\n<\/p>\n<p>\n\tReport of database schema\n<\/p>\n<p>\n\tList of Permanent Datafiles<br \/>\n\t===========================<br \/>\n\tFile Size(MB) Tablespace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RB segs Datafile Name<br \/>\n\t&#8212;- &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n\t1&nbsp;&nbsp;&nbsp; 480&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYSTEM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/system01.dbf<br \/>\n\t2&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UNDOTBS1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/undotbs01.dbf<br \/>\n\t3&nbsp;&nbsp;&nbsp; 250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYSAUX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/sysaux01.dbf<br \/>\n\t4&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; USERS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/users01.dbf<br \/>\n\t5&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERFSTAT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ***&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/perfstat.dbf\n<\/p>\n<p>\n\tList of Temporary Files<br \/>\n\t=======================<br \/>\n\tFile Size(MB) Tablespace&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Maxsize(MB) Tempfile Name<br \/>\n\t&#8212;- &#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>\n\t1&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TEMP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 32767&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \/home\/oracle\/oradata\/ora10g\/temp01.dbf\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\trman&gt;copy datafile 5 to &#39;\/u01\/rmanbak\/tbso1bak.dbf&#39;;(copy 5 \u5bf9\u5e94\u7684schme:perfstat.dbf)\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u5b83\u4f1a\u628atbs\u4f5c\u4e3a\u4e00\u4e2a\u62f7\u8d1d\u3002\u6211\u4eec\u7528list backupset\u6765\u770b\uff0c\u4e0d\u80fd\u591f\u67e5\u770b\u6211\u4eec\u521a\u5907\u4efd\u7684 tbs01bak.dbf&#39;,\u56e0\u4e3a\u5b83\u4e0d\u662fbackupset. \u6211\u4eec\u7528list copy \u5c31\u80fd\u591f\u67e5\u770b\u6211\u4eec\u521a\u624d\u521a\u521a\u5907\u4efd\u7684\u6587\u4ef6\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t=======================\u5355\u547d\u4ee4\u4e0e\u6279\u547d\u4ee4=================\n<\/p>\n<p>\n\t\u5355\u547d\u4ee4: backup database;\n<\/p>\n<p>\n\t\u6279\u547d\u4ee4:\n<\/p>\n<p>\n\trman&gt; run{<br \/>\n\t&nbsp;2&gt; allocate channel cha1 type disk;<br \/>\n\t&nbsp;3&gt; backup<br \/>\n\t&nbsp;4&gt; format &#39;\/u01\/rmanbak\/full_%t&#39;<br \/>\n\t&nbsp;5&gt; tag full-backup \/\/\u6807\u7b7e\u53ef\u4ee5\u987a\u4fbf\u8d77\uff0c\u6ca1\u5173\u7cfb<br \/>\n\t&nbsp;6&gt; database;<br \/>\n\t&nbsp;7&gt; release channel cha1;<br \/>\n\t&nbsp;8&gt;}\n<\/p>\n<p>\n\t\u8fd9\u4e2arun\u4e2d\u67093\u6761\u547d\u4ee4\uff0c\u5206\u522b\u7528\u5206\u53f7\u6765\u8fdb\u884c\u5206\u5272.\n<\/p>\n<p>\n\tformat:<br \/>\n\t%c\uff1a\u5907\u4efd\u7247\u7684\u62f7\u8d1d\u6570(\u4ece1\u5f00\u59cb\u7f16\u53f7)\uff1b<br \/>\n\t%d\uff1a\u6570\u636e\u5e93\u540d\u79f0\uff1b<br \/>\n\t%D\uff1a\u4f4d\u4e8e\u8be5\u6708\u4e2d\u7684\u5929\u6570(DD)\uff1b<br \/>\n\t%M\uff1a\u4f4d\u4e8e\u8be5\u5e74\u4e2d\u7684\u6708\u4efd(MM)\uff1b<br \/>\n\t%F\uff1a\u4e00\u4e2a\u57fa\u4e8eDBID\u552f\u4e00\u7684\u540d\u79f0\uff0c\u8fd9\u4e2a\u683c\u5f0f\u7684\u5f62\u5f0f\u4e3ac-xxx-YYYYMMDD-QQ,\u5176\u4e2dxxx\u4f4d\u8be5\u6570\u636e\u5e93\u7684DBID\uff0cYYYYMMDD\u4e3a\u65e5\u671f\uff0cQQ\u662f\u4e00\u4e2a1-256\u7684\u5e8f\u5217\uff1b<br \/>\n\t%n\uff1a\u6570\u636e\u5e93\u540d\u79f0\uff0c\u5e76\u4e14\u4f1a\u5728\u53f3\u4fa7\u7528x\u5b57\u7b26\u8fdb\u884c\u586b\u5145\uff0c\u4f7f\u5176\u4fdd\u6301\u957f\u5ea6\u4e3a8\uff1b<br \/>\n\t%u\uff1a\u662f\u4e00\u4e2a\u7531\u5907\u4efd\u96c6\u7f16\u53f7\u548c\u5efa\u7acb\u65f6\u95f4\u538b\u7f29\u540e\u7ec4\u6210\u76848\u5b57\u7b26\u540d\u79f0\u3002\u5229\u7528%u\u53ef\u4ee5\u4e3a\u6bcf\u4e2a\u5907\u4efd\u96c6\u4ea7\u751f\u4e00\u4e2a\u552f\u4e00\u7684\u540d\u79f0\uff1b<br \/>\n\t%p\uff1a\u8868\u793a\u5907\u4efd\u96c6\u4e2d\u7684\u5907\u4efd\u7247\u7684\u7f16\u53f7\uff0c\u4ece1\u5f00\u59cb\u7f16\u53f7\uff1b<br \/>\n\t%U\uff1a\u662f%u_%p_%c\u7684\u7b80\u5199\u5f62\u5f0f\uff0c\u5229\u7528\u5b83\u53ef\u4ee5\u4e3a\u6bcf\u4e00\u4e2a\u5907\u4efd\u7247\u6bb5(\u65e2\u78c1\u76d8\u6587\u4ef6)\u751f\u6210\u4e00\u4e2a\u552f\u4e00\u7684\u540d\u79f0\uff0c\u8fd9\u662f\u6700\u5e38\u7528\u7684\u547d\u540d\u65b9\u5f0f\uff1b<br \/>\n\t%t\uff1a\u5907\u4efd\u96c6\u65f6\u95f4\u6233;<br \/>\n\t%T:\u5e74\u6708\u65e5\u683c\u5f0f(YYYYMMDD);\n<\/p>\n<p>\n\tchannel\u7684\u6982\u5ff5\uff1a\u4e00\u4e2achannel\u662frman\u4e8e\u76ee\u6807\u6570\u636e\u5e93\u4e4b\u95f4\u7684\u4e00\u4e2a\u8fde\u63a5\uff0c&quot;allocate channel&quot;\u547d\u4ee4\u5728\u76ee\u6807\u6570\u636e\u5e93\u542f\u52a8\u4e00\u4e2a\u670d\u52a1\u5668\u8fdb\u7a0b\uff0c\u540c\u65f6\u5fc5\u987b\u5b9a\u4e49\u670d\u52a1\u5668\u8fdb\u7a0b\u6267\u884c\u5907\u4efd\u548c\u6062\u590d\u64cd\u4f5c\u4f7f\n<\/p>\n<p>\n\t\u7528\u7684I\/O\u7c7b\u578b\n<\/p>\n<p>\n\t\u901a\u9053\u63a7\u5236\u547d\u4ee4\u53ef\u4ee5\u7528\u6765:<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u63a7\u5236rman\u4f7f\u7528\u7684OS\u8d44\u6e90<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u5f71\u54cd\u5e76\u884c\u5ea6<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u6307\u5b9aI\/O\u5e26\u5bbd\u7684\u9650\u5236\u503c(\u8bbe\u7f6e limit read rate \u53c2\u6570)<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u6307\u5b9a\u5907\u4efd\u7247\u5927\u5c0f\u7684\u9650\u5236(\u8bbe\u7f6e limit kbytes)<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u6307\u5b9a\u5f53\u524d\u6253\u5f00\u6587\u4ef6\u7684\u9650\u5236\u503c(\u8bbe\u7f6e limit maxopenfiles)\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t=================================RMAN\u4e00\u5468\u5178\u578b\u5907\u4efd\u65b9\u6848============================\n<\/p>\n<p>\n\t1.\u661f\u671f\u5929\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 0 backup performed(\u5168\u5907\u4efd)<br \/>\n\t2.\u661f\u671f\u4e00\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 2 backup performed<br \/>\n\t3.\u661f\u671f\u4e8c\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 2 backup performed<br \/>\n\t4.\u661f\u671f\u4e09\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 1 backup performed<br \/>\n\t5.\u661f\u671f\u56db\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 2 backup performed<br \/>\n\t6.\u661f\u671f\u4e94\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 2 backup performed<br \/>\n\t7.\u661f\u671f\u516d\u665a\u4e0a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -level 2 backup performed\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t\u5982\u679c\u661f\u671f\u4e8c\u9700\u8981\u6062\u590d\u7684\u8bdd\uff0c\u53ea\u9700\u89811+2,<br \/>\n\t\u5982\u679c\u661f\u671f\u56db\u9700\u8981\u6062\u590d\u7684\u8bdd\uff0c\u53ea\u9700\u89811+4,<br \/>\n\t\u5982\u679c\u661f\u671f\u4e94\u9700\u8981\u6062\u590d\u7684\u8bdd\uff0c\u53ea\u9700\u89811+4+5,<br \/>\n\t\u5982\u679c\u661f\u671f\u516d\u9700\u8981\u6062\u590d\u7684\u8bdd\uff0c\u53ea\u9700\u89811+4+5+6.\n<\/p>\n<p>\n\t<a href=\"http:\/\/www.llku.com\/?attachment_id=1278#main\" rel=\"attachment wp-att-1278\"><img loading=\"lazy\" alt=\"\" class=\"alignnone size-medium wp-image-1278\" height=\"104\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2018\/04\/\u589e\u91cf\u5907\u4efd-300x104.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2018\/04\/\u589e\u91cf\u5907\u4efd-300x104.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2018\/04\/\u589e\u91cf\u5907\u4efd.jpg 692w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t\u81ea\u52a8\u5907\u4efd:\u5907\u4efd\u811a\u672c+crontab<br \/>\n\t&nbsp;bakl0<br \/>\n\t&nbsp;bakl1<br \/>\n\t&nbsp;bakl2\n<\/p>\n<p>\n\t\u6267\u884c\u811a\u672c:<br \/>\n\trman target \/ msglog=bakl0.log cmdfile=bakl0 (\/\u8868\u793a\u9700\u8981\u8fde\u63a5\u7684\u76ee\u6807\u6570\u636e\u5e93,msglog\u8868\u793a\u65e5\u5fd7\u6587\u4ef6\uff0ccmdfile\u8868\u793a\u7684\u662f\u811a\u672c\u6587\u4ef6)<br \/>\n\trman target \/ msglog=bakl1.log cmdfile=bakl1<br \/>\n\trman target \/ msglog=bakl2.log cmdfile=bakl2\n<\/p>\n<p>\n\t\u5b9e\u4f8b\uff1arman target&nbsp;<a href=\"mailto:system\/oracle@ora10g(\/\" target=\"_blank\">system\/oracle@ora10g(\/<\/a>) msglog=\/u01\/rmanbak\/bakl1.log cmdfile=\/u01\/rmanbak\/bakl0\n<\/p>\n<p>\n\t<br \/>\n\t\u5b8c\u6574\u7684\u547d\u4ee4:\/u01\/oracle\/product\/10.2.0\/bin\/rman target&nbsp;<a href=\"mailto:system\/oracle@ora10g(\/\" target=\"_blank\">system\/oracle@ora10g(\/<\/a>) msglog=\/u01\/rmanbak\/bakl1.log cmdfile=\/u01\/rmanbak\/bakl0\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t\u628a\u5907\u4efd\u811a\u672c\u653e\u5230\/u01\/rmanbak\/script\u76ee\u5f55\u4e0b\u9762,vi bakl0,bakl0\u7684\u5185\u5bb9\u4e3a:\n<\/p>\n<p>\n\trun{<br \/>\n\t&nbsp;&nbsp;&nbsp; allocate channel cha1 type disk;<br \/>\n\t&nbsp;&nbsp;&nbsp; backup<br \/>\n\t&nbsp;&nbsp;&nbsp; incremental level&nbsp; 0<br \/>\n\t&nbsp;&nbsp;&nbsp; format &#39;\/u01\/rmanbak\/inc0_%u_%T&#39;(u\u8868\u793a\u552f\u4e00\u7684ID,\u5927T\u662f\u65e5\u671f\uff0c\u5c0ft\u662f\u65f6\u95f4)<br \/>\n\t&nbsp;&nbsp;&nbsp; tag monday_inc0 \/\/\u6807\u7b7e\u53ef\u4ee5\u987a\u4fbf\u8d77\uff0c\u6ca1\u5173\u7cfb<br \/>\n\t&nbsp;&nbsp;&nbsp; database;<br \/>\n\t&nbsp;&nbsp;&nbsp; release channel cha1;<br \/>\n\t&nbsp;&nbsp;&nbsp; }<br \/>\n\t\uff0c\u7c7b\u4f3c\u5c31\u53ef\u4ee5\u5199\u51fabakl1,bakl2\u76f8\u5e94\u7684\u811a\u672c.\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t\u81ea\u52a8\u5907\u4efd<br \/>\n\tcrontab<br \/>\n\tcrontab -e -u oracle(\u6539\u547d\u4ee4\u7684\u610f\u601d\u662f\u7f16\u8f91oracle\u7528\u6237\u7684\u5b9a\u65f6\u6267\u884c(-e,edit -u oracle,oracle\u7528\u6237))\n<\/p>\n<p>\n\t\u5206&nbsp; \u65f6&nbsp; \u65e5 \u6708 \u661f\u671f(0\u4ee3\u8868\u661f\u671f\u5929)<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl0.log cmdfile=bakl0(\u661f\u671f\u5929\u768423:45\u4f1a\u4ee5oracle\u7528\u6237\u7684\u8eab\u4efd\u6765\u6267\u884c\u547d\u4ee4)<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl2.log cmdfile=bakl2<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl2.log cmdfile=bakl2<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl1.log cmdfile=bakl1<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl2.log cmdfile=bakl2<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl2.log cmdfile=bakl2<br \/>\n\t45 23&nbsp; *&nbsp; *&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp; rman target \/ msglog=bakl2.log cmdfile=bakl2\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u7136\u540e\u542f\u52a8crontab ,\u542f\u52a8crontab\u7684\u547d\u4ee4:<br \/>\n\troot&gt; service crond restart<br \/>\n\t&nbsp;&nbsp;<br \/>\n\t<strong>=======================RMAN\u6062\u590d================<\/strong>\n<\/p>\n<p>\n\t\u5728\u975ecatalog\u6a21\u5f0f\u4e0b\uff0c\u5907\u4efd\u7684\u4fe1\u606f\u5b58\u50a8\u5728controlfile\u6587\u4ef6\u4e2d\uff0c\u5982\u679ccontrolfile\u6587\u4ef6\u53d1\u751f\u6bc1\u574f\uff0c\u90a3\u4e48\u5c31\u4e0d\u80fd\u80fd\u591f\u8fdb\u884c\u6062\u590d\uff0c<br \/>\n\t\u6240\u4ee5\u5728\u5907\u4efd\u7684\u65f6\u5019\u9700\u8981\u628acontrolfile\u4e5f\u8fdb\u884c\u81ea\u52a8\u5907\u4efd&nbsp;<br \/>\n\t&nbsp;<br \/>\n\tRMAN&gt;show all;<br \/>\n\tusing target database control file instead of recovery catalog<br \/>\n\tRMAN configuration parameters are:<br \/>\n\tCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default<br \/>\n\tCONFIGURE BACKUP OPTIMIZATION OFF; # default<br \/>\n\tCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default<br \/>\n\tCONFIGURE CONTROLFILE AUTOBACKUP OFF; # default<br \/>\n\tCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#39;%F&#39;; # default<br \/>\n\tCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default<br \/>\n\tCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br \/>\n\tCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default<br \/>\n\tCONFIGURE MAXSETSIZE TO UNLIMITED; # default<br \/>\n\tCONFIGURE ENCRYPTION FOR DATABASE OFF; # default<br \/>\n\tCONFIGURE ENCRYPTION ALGORITHM &#39;AES128&#39;; # default<br \/>\n\tCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default<br \/>\n\tCONFIGURE SNAPSHOT CONTROLFILE NAME TO &#39;\/home\/oracle\/product\/10.20\/dbs\/snapcf_ora10g.f&#39;; # default\n<\/p>\n<p>\n\t\u5176\u4e2dCONFIGURE CONTROLFILE AUTOBACKUP OFF; \u6ca1\u6709\u5bf9controlfile\u8fdb\u884c autobackup,\u4f7f\u7528\u6211\u4eec\u9700\u8981\u8fd0\u884c\u4e0b\u9762\u547d\u4ee4\u6765\u5bf9controlfile\u8fdb\u884c\u81ea\u52a8\u5907\u4efd<br \/>\n\tRMAN&gt; CONFIGURE CONTROLFILE AUTOBACKUP ON;\n<\/p>\n<p>\n\tRMAN&gt; show all;\n<\/p>\n<p>\n\t\u624b\u52a8\u5907\u4efd\u63a7\u5236\u6587\u4ef6\uff1a<br \/>\n\tbackup current controlfile\n<\/p>\n<p>\n\t<br \/>\n\tDbid\u8868\u793adatabase\u7684\u4e00\u4e2aID\uff0c\u5c06\u6765\u7528\u4e8e\u6062\u590dspfile\u548ccontrolfile\u65f6\u5019\u8981\u7528\u5230.<br \/>\n\tRMAN&gt; connect target \/<br \/>\n\tconnected to target database: ORA10G (DBID=3988862108)<br \/>\n\t\u8fd9\u4e2aDbid=3988862108<br \/>\n\t&nbsp;\n<\/p>\n<p>\n\tRMAN&gt; list backup;\u67e5\u770b\u4ee5\u524d\u5907\u4efd\u7684\u4fe1\u606f<br \/>\n\tRMAN&gt;delete backupset 24;\/\/24\u4ee3\u8868backupset \u7684\u7f16\u53f7<br \/>\n\tRMAN&gt;backup format &#39;\/u01\/rmanbak\/full_%T_%U.bak&#39; database plus archivelog;(\u8fdb\u884c\u4e00\u6b21\u5168\u5907\u4efd)\n<\/p>\n<p>\n\t\u9a8c\u8bc1\u5907\u4efd\uff1a<br \/>\n\tRMAN&gt; validate backupset 3;&nbsp; \/\/3\u4ee3\u8868backupset\u7684\u7f16\u53f7\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u53e3\u4ee4\u6587\u4ef6\u4e22\u5931(\u4e0d\u5c5e\u4e8erman\u5907\u4efd\u7684\u8303\u7574),\u6211\u4eec\u53ea\u9700\u8981\u7528\u4e00\u4e2a\u547d\u4ee4\u6765\u91cd\u5efa\u8fd9\u4e2a\u6587\u4ef6\u5c31\u53ef\u4ee5\u4e86:<br \/>\n\torapw file=orapwsid password=pass entries=5;&nbsp; \/\/\u53e3\u4ee4\u6587\u4ef6\u7684\u8def\u5f84:\/u01\/oracle\/product\/10.20\/db_1\/dbs\u76ee\u5f55\u4e0b<br \/>\n\toracle&gt; cd \/u01\/oracle\/product\/10.20\/db_1\/dbs<br \/>\n\toracle&gt; rm orapwora10g;(\u6587\u4ef6\u5220\u9664\uff0c\u6a21\u62df\u4e22\u5931)<br \/>\n\toracle&gt; orapwd file=orapwora10g password=oracle entries=5;(\u91cd\u65b0\u5efa\u7acb\u4e00\u4e2a\u6587\u4ef6),entries\u7684\u610f\u601d(DBA\u7684\u7528\u6237\u6700\u591a\u67095\u4e2a)\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\tSPFILE\u4e22\u5931:<br \/>\n\tstartup nomount;<br \/>\n\tset dbid 3988862108;<br \/>\n\trestore spfile from autobackup;<br \/>\n\tshutdown immediate;<br \/>\n\tset dbid 3988862108;<br \/>\n\tstartup;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u6a21\u62df\u64cd\u4f5c:<br \/>\n\toracle&gt; mv spfileora10g.ora spora10g.ora<br \/>\n\toracle&gt;rman target \/;<br \/>\n\trman&gt; shutdown immediate;<br \/>\n\trman&gt; startup nomount;<br \/>\n\tstartup failed: ORA-01078: failure in processing system parameters<br \/>\n\tLRM-00109: could not open parameter file &#39;\/home\/oracle\/product\/10.20\/dbs\/initora10g.ora&#39;<br \/>\n\trman&gt;set dbid 3988862108;<br \/>\n\trman&gt;restore spfile from autobackup;\n<\/p>\n<p>\n\t\u6267\u884c\u8be5\u547d\u4ee4\uff0c\u5982\u679c\u6ca1\u6709\u627e\u5230\u7684\u8bdd\uff0c\u90a3\u53ef\u80fd\u662f\u6587\u4ef6\u7684\u8def\u5f84\u53d1\u751f\u9519\u8bef.\u53ef\u4ee5\u901a\u8fc7\u76f4\u63a5\u8d4b\u4e88\u5b83\u7684\u6587\u4ef6<br \/>\n\trman&gt;restore spfile from &#39;\/u01\/oracle\/flash_recovery_area\/ORA10G\/autobackup\/2008_12_09\/o1_mf_s_673025706_4mw7xc79_.bkp\n<\/p>\n<p>\n\t\u5728dbs\/\u76ee\u5f55\u4e0b\u4ea7\u751fspfileora10g.ora\u6587\u4ef6\u3002\u8bc1\u660espfile \u5df2\u7ecf\u6062\u590d\u597d\n<\/p>\n<p>\n\trman&gt; shutdown immediate;<br \/>\n\trman&gt; startup ;(\u5982\u679c\u8be5\u547d\u4ee4\u4e0d\u80fd\u591f\u542f\u52a8\u6570\u636e\u5e93\uff0c\u90a3\u4e48\u9700\u8981set dbid 3988862108)\n<\/p>\n<p>\n\t<br \/>\n\tcontrolfile \u4e22\u5931:<br \/>\n\tstartup nomount;<br \/>\n\trestore controlfile from autobackup;<br \/>\n\talter database mount;<br \/>\n\trecover database;<br \/>\n\talter database open resetlogs;\n<\/p>\n<p>\n\t\u6ce8\u610f:\u5728\u505a\u4e86alter database open resetlogs;\u4f1a\u628aonline redelog file\u6e05\u7a7a\uff0c\u6570\u636e\u6587\u4ef6\u4e22\u5931.\u6240\u4ee5\u8fd9\u4e2a\u65f6\u5019\u8981\u505a\u4e00\u4e2a\u5168\u5907\u4efd\u3002\n<\/p>\n<p>\n\toracle&gt;rm *.ctl<br \/>\n\toracle&gt;rman target \/ ;\/\/\u4e0d\u80fd\u591f\u8fde\u63a5\u5230rman ,\u56e0\u4e3acontrolfile\u4e22\u5931<br \/>\n\toracle&gt;sqlplus \/nolog;\n<\/p>\n<p>\n\t<br \/>\n\tSQL&gt;shutdown immediate; \/\/\u56e0\u4e3acontrolfile\u4e22\u5931\uff0c\u4e0d\u80fd\u591f\u6b63\u5e38shutdown<br \/>\n\tSQL&gt;shutdown abort;\n<\/p>\n<p>\n\toracle&gt;rman target \/;\n<\/p>\n<p>\n\trman&gt;startup nomount;<br \/>\n\trman&gt;restore controlfile from autobackup;<br \/>\n\trman&gt;alter database mount;<br \/>\n\trman&gt;alter database open resetlogs;\n<\/p>\n<p>\n\tRMAN-00571: ===========================================================<br \/>\n\tRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br \/>\n\tRMAN-00571: ===========================================================<br \/>\n\tRMAN-03002: failure of alter db command at 12\/09\/2008 16:21:13<br \/>\n\tORA-01194: file 1 needs more recovery to be consistent<br \/>\n\tORA-01110: data file 1: &#39;\/home\/oracle\/oradata\/ora10g\/system01.dbf\n<\/p>\n<p>\n\t\/\/\u51fa\u9519, redo log\u7684scn\u8bb0\u5f55\u5728controlfile\u91cc\u9762\u7684\uff0c\u56e0\u4e3a\u6211\u4eec\u6709\u65b0\u7684controlfile,\u6240\u4ee5\u9700\u8981resetlogs;<br \/>\n\t&nbsp;<br \/>\n\t\/*<br \/>\n\tresetlogs\u547d\u4ee4\u8868\u793a\u4e00\u4e2a\u6570\u636e\u5e93\u903b\u8f91\u751f\u5b58\u671f\u7684\u7ed3\u675f\u548c\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u903b\u8f91\u751f\u5b58\u671f\u7684\u5f00\u59cb\uff0c\u6bcf\u6b21\u4f7f\u7528resetlogs\u547d\u4ee4\u7684\u65f6\u5019\uff0cSCN\u4e0d\u4f1a\u88ab\u91cd\u7f6e\uff0c\u4e0d\u8fc7oracle\u4f1a\u91cd\u7f6e\u65e5\u5fd7\u5e8f\u5217\u53f7\uff0c\u800c\u4e14\u4f1a\u91cd\u7f6e\n<\/p>\n<p>\n\t\u8054\u673a\u91cd\u505a\u65e5\u5fd7\u5185\u5bb9.<br \/>\n\t\u8fd9\u6837\u505a\u662f\u4e3a\u4e86\u9632\u6b62\u4e0d\u5b8c\u5168\u6062\u590d\u540e\u65e5\u5fd7\u5e8f\u5217\u4f1a\u53d1\u751f\u51b2\u7a81\uff08\u56e0\u4e3a\u73b0\u6709\u65e5\u5fd7\u548c\u6570\u636e\u6587\u4ef6\u95f4\u6709\u4e86\u65f6\u95f4\u5dee\uff09\u3002<br \/>\n\t*\/<br \/>\n\trman&gt;recover database;<br \/>\n\trman&gt;alter database open resetlogs;\n<\/p>\n<p>\n\t<br \/>\n\tRedolog file\u4e22\u5931:(\u4e0b\u9762\u7684\u8fd9\u4e9b\u8bed\u53e5\u4e00\u5b9a\u8981\u5728sqlplus\u4e2d\u6267\u884c,\u4e0d\u662f\u5728rman\u4e2d\u6267\u884c)<br \/>\n\t&nbsp;(sqlplus\/nolog)<br \/>\n\t1.shutdown immediate;<br \/>\n\t2.startup mount;<br \/>\n\t3.recover database until cancel;(media recovery)<br \/>\n\t4.alter database resetlogs;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u6570\u636e\u6587\u4ef6\u4e22\u5931(\u5728rman\u4e2d\u6267\u884csql\u8bed\u53e5\uff0c\u5728sql\u540e\u9762\u7528\u53cc\u5f15\u53f7\u62ec\u8d77\u6765):<br \/>\n\t1. sql &quot;alter database datafile 3 offline&quot;;<br \/>\n\t2. restore datafile 3<br \/>\n\t3. recover datafile 3<br \/>\n\t4. sql &quot;alter database datafile 3 online&quot;;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u8868\u7a7a\u95f4\u4e22\u5931:<br \/>\n\t1. sql &quot;alter tablespace users offline&quot;;\/\/\u5982\u679c\u6587\u4ef6\u4e0d\u5b58\u5728\uff0c\u5219\u7528 sql &quot;alter tablespace users offline immeidate&quot;;<br \/>\n\t2. restore tablespace users;<br \/>\n\t3. recover tablespace users; \/\/\u4e0eonline redolog file \u4fe1\u606f\u4e00\u81f4<br \/>\n\t4. sql &quot;alter tablespace users online&quot;;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u975ecatalog\u65b9\u5f0f\u5b8c\u5168\u6062\u590d\n<\/p>\n<p>\n\t\u6570\u636e\u5e93\u51fa\u73b0\u95ee\u9898:\n<\/p>\n<p>\n\t1.startup nomount;<br \/>\n\t2.restore controlfile from autobackup;<br \/>\n\t3.alter database mount;<br \/>\n\t4.restore database;<br \/>\n\t5.recover database;<br \/>\n\t6.alter database open resetlogs;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u6a21\u62df\u64cd\u4f5c:<br \/>\n\toracle ora10g&gt; rm *;<br \/>\n\toracle ora10g&gt; ls;<br \/>\n\toracle ora10g&gt;&nbsp; \/\/\u6570\u636e\u6587\u4ef6\uff0c\u63a7\u5236\u6587\u4ef6\u5168\u90e8\u5220\u9664\n<\/p>\n<p>\n\toracle ora10g&gt; rman target \/; \/\/\u56e0\u4e3acontrolfile \u4e22\u5931\uff0c\u4e0d\u80fd\u591f\u8fde\u63a5\u5230rman<br \/>\n\toracle ora10g&gt; sqlplus \/nolog;<br \/>\n\toracle ora10g&gt; connect \/ as sysdba;<br \/>\n\toracle ora10g&gt; shutdown abort;<br \/>\n\toracle ora10g&gt; rman target \/\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\trman&gt; startup nomount;<br \/>\n\trman&gt; restore controlfile from autabackup;<br \/>\n\trman&gt; alter database mount;<br \/>\n\trman&gt; restore database;<br \/>\n\trman&gt; recover database; \/\/online redolog \u4e0d\u5b58\u5728\n<\/p>\n<p>\n\tSQL&gt;recover database until cancel; \/\/\u5f53redo log\u4e22\u5931\uff0c\u6570\u636e\u5e93\u5728\u7f3a\u7701\u7684\u65b9\u5f0f\u4e0b\uff0c\u662f\u4e0d\u5bb9\u8bb8\u8fdb\u884crecover\u64cd\u4f5c\u7684,\u90a3\u4e48\u5982\u4f55\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\u64cd\u4f5c\u5462<br \/>\n\tSQL&gt;create pfile from spfile;\n<\/p>\n<p>\n\tvi \/u01\/product\/10.20\/dbs\/initora10g.ora\uff0c\u5728\u8fd9\u4e2a\u6587\u4ef6\u7684\u6700\u540e\u4e00\u884c\u6dfb\u52a0<br \/>\n\t*.allow_resetlogs_corruption=&#39;TRUE&#39;; \/\/\u5bb9\u8bb8resetlog corruption\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\tSQL&gt;shutdown immediate;<br \/>\n\tSQL&gt;startup pfile=&#39;\/u01\/product\/10.20\/dbs\/initora10g.ora&#39; mount;<br \/>\n\tSQL&gt;alter database open resetlogs;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t&nbsp;\u57fa\u4e8e\u65f6\u95f4\u70b9\u7684\u6062\u590d:<br \/>\n\t&nbsp;run{<br \/>\n\t&nbsp; set until time &quot;to_date(07\/01\/02 15:00:00&#39;,&#39;mm\/dd\/yy hh24:mi:ss&#39;)&quot;;<br \/>\n\t&nbsp; restore database;<br \/>\n\t&nbsp; recover database;<br \/>\n\t&nbsp; alter database open resetlogs;<br \/>\n\t}\n<\/p>\n<p>\n\tALTER SESSION SET NLS_DATE_FORMAT=&#39;YYYY-MM-DD HH24:MI:SS&#39;;<br \/>\n\t1.startup mount;<br \/>\n\t2.restore database until time &quot;to_date(&#39;2009-7-19 13:19:00&#39;,&#39;YYYY-MM-DD HH24:MI:SS&#39;)&quot;;<br \/>\n\t3.recover database until time &quot;to_date(&#39;2009-7-19 13:19:00&#39;,&#39;YYYY-MM-DD HH24:MI:SS&#39;)&quot;;<br \/>\n\t4.alter database open resetlogs;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u5982\u679c\u6709open resetlogs,\u90fd\u662f\u4e0d\u5b8c\u6574\u6062\u590d.\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u57fa\u4e8e SCN\u7684\u6062\u590d:<br \/>\n\t1.startup mount;<br \/>\n\t2.restore database until scn 10000;<br \/>\n\t3.recover database until scn 10000;<br \/>\n\t4.alter database open resetlogs;\n<\/p>\n<p>\n\t<br \/>\n\t\u57fa\u4e8e\u65e5\u5fd7\u5e8f\u5217\u7684\u6062\u590d:<br \/>\n\t1.startup mount;<br \/>\n\t2.restore database until SEQUENCE 100 thread 1; \/\/100\u662f\u65e5\u5fd7\u5e8f\u5217<br \/>\n\t3.recover database until SEQUENCE 100 thread 1;<br \/>\n\t4.alter database open resetlogs;\n<\/p>\n<p>\n\t\u65e5\u5fd7\u5e8f\u5217\u67e5\u770b\u547d\u4ee4\uff1a SQL&gt;select * from v$log;\u5176\u4e2d\u6709\u4e00\u4e2asequence\u5b57\u6bb5.resetlogs\u5c31\u4f1a\u628asequence \u7f6e\u4e3a1\n<\/p>\n<p>\n\t<br \/>\n\t=================================RMAN catalog\u6a21\u5f0f\u4e0b\u7684\u5907\u4efd\u4e0e\u6062\u590d=====================\n<\/p>\n<p>\n\t1.\u521b\u5efaCatalog\u6240\u9700\u8981\u7684\u8868\u7a7a\u95f4<br \/>\n\tSQL&gt;create tablespace rman_ts size datafile &#39;\/u01\/oracle\/oradata\/ora10g\/rmants.dbf&#39; 20M;<br \/>\n\t&nbsp;\n<\/p>\n<p>\n\t2.\u521b\u5efaRMAN\u7528\u6237\u5e76\u6388\u6743<br \/>\n\tSQL&gt;create user rman identified by rman default tablespace rman_ts quota unlimited on rman_ts;<br \/>\n\tSQL&gt;grant recovery_catalog_owner to rman;(grant connect to rman)\n<\/p>\n<p>\n\t&nbsp;<br \/>\n\t\u67e5\u770b\u89d2\u8272\u6240\u62e5\u6709\u7684\u6743\u9650: select * from dba_sys_privs where grantee=&#39;RECOVERY_CATALOG_OWNER&#39;;<br \/>\n\t(RECOVER_CATALOG_OWNER,CONNECT,RESOURCE)\n<\/p>\n<p>\n\t3.\u521b\u5efa\u6062\u590d\u76ee\u5f55<br \/>\n\toracle&gt;rman catalog rman\/rman<br \/>\n\tRMAN&gt;create catalog tablespace rman_ts;<br \/>\n\tRMAN&gt;register database;(database\u662ftarget database)\n<\/p>\n<p>\n\tdatabase registered in recovery catalog<br \/>\n\tstarting full resync of recovery catalog<br \/>\n\tfull resync complete\n<\/p>\n<p>\n\tRMAN&gt; connect target \/;\n<\/p>\n<p>\n\t\u4ee5\u540e\u8981\u4f7f\u7528\u5907\u4efd\u548c\u6062\u590d\uff0c\u9700\u8981\u8fde\u63a5\u5230\u4e24\u4e2a\u6570\u636e\u5e93\u4e2d,\u547d\u4ee4:\n<\/p>\n<p>\n\toracle&gt;rman target \/ catalog rman\/rman (\u7b2c\u4e00\u659c\u6760\u8868\u793atarget\u6570\u636e\u5e93\uff0ccatalog\u8868\u793acatalog\u76ee\u5f55 rman\/rman\u8868\u793acatalog\u7528\u6237\u540d\u548c\u5bc6\u7801)\n<\/p>\n<p>\n\t\u547d\u4ee4\u6267\u884c\u540e\u663e\u793a\uff1a\n<\/p>\n<p>\n\tRecovery Manager: Release 10.2.0.1.0 &#8211; Production on Wed Dec 10 15:00:42 2008<br \/>\n\tCopyright (c) 1982, 2005, Oracle.&nbsp; All rights reserved.<br \/>\n\tconnected to target database: ORA10G (DBID=3988862108)<br \/>\n\tconnected to recovery catalog database\n<\/p>\n<p>\n\t<br \/>\n\t\u547d\u4ee4\u89e3\u91ca:<br \/>\n\tReport schema&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Report shema\u662f\u6307\u5728\u6570\u636e\u5e93\u4e2d\u9700\u627eschema<br \/>\n\tList backup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u4ececontrol\u8bfb\u53d6\u4fe1\u606f<br \/>\n\tCrosscheck backup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; \u770b\u4e00\u4e0bbackup\u7684\u6587\u4ef6\uff0c\u68c0\u67e5controlfile\u4e2d\u7684\u76ee\u5f55\u6216\u6587\u4ef6\u662f\u5426\u771f\u6b63\u5728\u78c1\u76d8\u4e0a<br \/>\n\tDelete backupset 24&nbsp;&nbsp;&nbsp; 24\u4ee3\u8868backupset \u7684\u7f16\u53f7, \u65e2delete\u76ee\u5f55\uff0c\u4e5fdelete\u4f60\u7684\u6587\u4ef6\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t\u6ce8\u610f:\u5728\u505a\u4e86alter database open resetlogs;\u4f1a\u628aonline redelog file\u6e05\u7a7a\uff0c\u6570\u636e\u6587\u4ef6\u4e22\u5931.\u6240\u4ee5\u8fd9\u4e2a\u65f6\u5019\u8981\u505a\u4e00\u4e2a\u5168\u5907\u4efd\u3002\n<\/p>\n<p>\n\tresetlogs\u547d\u4ee4\u8868\u793a\u4e00\u4e2a\u6570\u636e\u5e93\u903b\u8f91\u751f\u5b58\u671f\u7684\u7ed3\u675f\u548c\u53e6\u4e00\u4e2a\u6570\u636e\u5e93\u903b\u8f91\u751f\u5b58\u671f\u7684\u5f00\u59cb\uff0c\u6bcf\u6b21\u4f7f\u7528resetlogs\u547d\u4ee4\u7684\u65f6\u5019\uff0cSCN\u4e0d\u4f1a\u88ab\u91cd\u7f6e\uff0c\u4e0d\u8fc7oracle\u4f1a\u91cd\u7f6e\u65e5\u5fd7\u5e8f\u5217\u53f7\uff0c\u800c\u4e14\u4f1a\u91cd\u7f6e\n<\/p>\n<p>\n\t\u8054\u673a\u91cd\u505a\u65e5\u5fd7\u5185\u5bb9.\u8fd9\u6837\u505a\u662f\u4e3a\u4e86\u9632\u6b62\u4e0d\u5b8c\u5168\u6062\u590d\u540e\u65e5\u5fd7\u5e8f\u5217\u4f1a\u53d1\u751f\u51b2\u7a81\uff08\u56e0\u4e3a\u73b0\u6709\u65e5\u5fd7\u548c\u6570\u636e\u6587\u4ef6\u95f4\u6709\u4e86\u65f6\u95f4\u5dee\uff09\u3002\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\tRman \u5f52\u6863\u6587\u4ef6\u4e22\u5931\u5bfc\u81f4\u4e0d\u80fd\u5907\u4efd\u7684\uff0c\u5728\u5907\u4efd\u524d\u5148\u6267\u884c\u4ee5\u4e0b\u4e24\u6761\u547d\u4ee4<br \/>\n\tcrosscheck archivelog all;<br \/>\n\tdelete expired archivelog all;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t<script src=\"https:\/\/hm.baidu.com\/hm.js?5016281862f595e78ffa42f085ea0f49\"><\/script><script src=\"http:\/\/c.cnzz.com\/core.php?web_id=30029880&amp;t=q\" type=\"text\/javascript\" charset=\"utf-8\" async=\"\"><\/script><script>\nvar ua = navigator.userAgent.toLowerCase();\nif(ua.match(\/MicroMessenger\/i)==\"micromessenger\") {\n    location.href='http:\/\/blog.itpub.net\/article.php?url='+ window.location.href;\n}<\/script>\n<\/p>\n<style type=\"text\/css\">\n.Blog_nav1_2 a em { display:inline-block; width:16px; height:13px; background:url(\/image\/v.jpg) no-repeat; overflow:hidden;}<\/style>\n<p>\n\t<script src=\"\/js\/jquery.min.js\" type=\"text\/javascript\"><\/script><script src=\"\/js\/jquery.cookies.min.js\" type=\"text\/javascript\"><\/script><script src=\"\/js\/AsyncBox.v1.4.5.js\" type=\"text\/javascript\"><\/script>Oracle rman \u547d\u4ee4\u603b\u7ed3-j04212-ITPUB\u535a\u5ba2 <script type=\"text\/javascript\">\nif(\/AppleWebKit.*Mobile\/i.test(navigator.userAgent) || (\/MIDP|SymbianOS|NOKIA|SAMSUNG|LG|NEC|TCL|Alcatel|BIRD|DBTEL|Dopod|PHILIPS|HAIER|LENOVO|MOT-|Nokia|SonyEricsson|SIE-|Amoi|ZTE\/.test(navigator.userAgent))){\n\ttry{\n\t\tif(!\/iPad\/i.test(navigator.userAgent)){\n\t\t\tvar oldurl=window.location.href;\n\t\t\tif(window.location.hostname.indexOf('m.blog.itpub.net')==-1){\n\t\t\tvar wapUrl= oldurl.replace('blog.itpub.net', \"m.blog.itpub.net\") ;\n\t\t\twindow.location.href = wapUrl;\n\t\t\t}\n\t\t}\n\t}catch(e){}\n}<\/script><script language=\"javascript\">\n\/\/\u7528\u6237\u662f\u5426\u5728\u7ebf\nvar isOnLine = '25693151';\n$(document).ready(function(){\n\tvar blog = {'name': '', 'name_url': '', 'brief': ''};\n\t\/\/\u6d88\u606f\u901a\u77e5\u663e\u793a\u548c\u9690\u85cf\u63a7\u5236\n\t$('#show_message_slide_button').hover(\n\t\tfunction(){\n\t\t\t$('#message_slide_div').slideDown(100);\t\t\t\t\t\t\t\t\t\t\t   \n\t\t},\n\t\tfunction(){<\/p>\n<p>\t\t}\n\t);<\/p>\n<p>\t$('#message_slide_div').hover(\n\t\tfunction(){<\/p>\n<p>\t\t},\n\t\tfunction(){\n\t\t\t$('#message_slide_div').slideUp(100);\n\t\t}\n\t);<\/p>\n<p>\t\/\/\u7f16\u8f91\u535a\u5ba2\u540d\n\t$('#editbna').click(function(){\n\t\tblog.name = $('#bnaspan a').text();\n\t\tvar val = '<input id=\"bnainput\" type=\"text\" style=\"float:left\" value=\"\" rel=\"' +$(this).attr('rel') + '\" \/><input id=\"bnasub\" type=\"button\" style=\"float:left\" class=\"btn1\"><input id=\"bnacanl\" type=\"button\" style=\"float:left\" class=\"btn2\"><\/p>\n<div class=\"clear\"><\/div>\n<p>';\n\t\t$('#bnaspan').html(val);\n\t\t$('#bnainput').val(blog.name);\n\t\t$(this).parent().hide();\n\t});<\/p>\n<p>\t$('#bnasub').live('click', function(){\n\t    var rel = eval('({' + $('#bnainput').attr('rel') + '})');\n\t\tvar name = $('#bnainput').val();\n\t\tif(name != blog.name){\n\t        $.ajax({\n\t\t\t    type: \"POST\",\n\t\t\t    url: rel.url,\t\n\t\t\t    data: {\n\t\t\t\t    'name' : name\n\t\t\t    },\n\t\t\t    success:function(data){\n\t\t\t\t    if(data == 0){\n\t\t\t\t\t\t$('#bnaspan').html(blog.name);\n\t\t\t\t\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + $('#bnaspan').html() + '<\/a>');\n\t\t\t\t    }else if(data == -1){\n                                        showErrorMsg('\u540d\u79f0\u4e2d\u542b\u6709\u8fdd\u7981\u8bcd\uff0c\u8bf7\u4ece\u65b0\u7f16\u8f91!', '\u6d88\u606f\u63d0\u793a');\n                                    }else{\n\t\t\t\t\t\t$('#bnaspan').html(data);\n\t\t\t\t\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + $('#bnaspan').html() + '<\/a>');\n\t\t\t\t    }\n\t\t\t\t\t$('#editbna').parent().show();\n\t\t\t\t}\n\t\t\t});\n\t\t}else{\n\t\t    $('#bnaspan').text(blog.name).html();\n\t\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + $('#bnaspan').html() + '<\/a>');\n\t\t\t$('#editbna').parent().show();\n\t\t}\n\t});<\/p>\n<p>\t$('#bnacanl').live('click', function(){\n\t\tvar rel = eval('({' + $('#bnainput').attr('rel') + '})');\n\t\t$('#bnaspan').html('<a href=\"' + rel.href + '\">' + blog.name + '<\/a>');\n\t\t$('#editbna').parent().show();\n\t});<\/p>\n<p>\t\/\/\u7f16\u8f91\u7b7e\u540d\n\t$('#editbrief').click(function(){\n\t    blog.brief = $('#briefem').text();\n\t\tvar val = '<input id=\"brfinput\" type=\"text\" style=\"float:left\" value=\"\" rel=\"' + $(this).attr('rel') + '\" \/><input id=\"brfsub\" style=\"float:left\"  type=\"button\" class=\"btn1\"><input style=\"float:left\"  id=\"brfcanl\" type=\"button\" class=\"btn2\"><\/p>\n<div class=\"clear\"><\/div>\n<p>';\n\t\t$('#briefem').html(val);\n\t\t$('#brfinput').val(blog.brief);\n\t\t$(this).parent().hide();\n\t});<\/p>\n<p>\t$('#brfsub').live('click', function(){\n\t    var url = $('#brfinput').attr('rel');\n\t\tvar brief = $('#brfinput').val();\n\t\tif(brief != blog.brief){\n\t        $.ajax({\n\t\t\t    type: \"POST\",\n\t\t\t    url: url,\t\n\t\t\t    data: {\n\t\t\t\t    'brief' : brief\n\t\t\t    },\n\t\t\t    success:function(data){\n\t\t\t\t    if(data == 0){\n\t\t\t\t        $('#briefem').html(blog.brief);\n\t\t\t\t    }else if(data == -1){\n                                        showErrorMsg('\u7b7e\u540d\u4e2d\u542b\u6709\u8fdd\u7981\u8bcd\uff0c\u8bf7\u4ece\u65b0\u7f16\u8f91!<br \/>\u60f3\u77e5\u9053\u539f\u56e0\uff1f<a href=\"http:\/\/www.itpub.net\/check\/tool.html\">\u53bb\u68c0\u6d4b<\/a>', '\u6d88\u606f\u63d0\u793a');\n                                    }else{\n\t\t\t\t\t\t$('#briefem').html(data);\n\t\t\t\t    }\n\t\t\t\t\t$('#editbrief').parent().show();\n\t\t\t\t}\n\t\t\t});\n\t\t}else{\n\t\t    $('#briefem').text(blog.brief).html();\n\t\t\t$('#editbrief').parent().show();\n\t\t}\n\t});<\/p>\n<p>\t$('#brfcanl').live('click', function(){\n\t\t$('#briefem').html(blog.brief);\n\t\t$('#editbrief').parent().show();\n\t});<\/p>\n<p>});<\/script>\n<\/p>\n<style type=\"text\/css\">\n.Blog_wz1 img{max-width:100%;height:auto}<\/style>\n<p>\n\t<script src=\"http:\/\/bdimg.share.baidu.com\/static\/api\/js\/share.js?v=89860593.js?cdnversion=423480\"><\/script><!--StartFragment-->\n<\/p>\n<p>\n\t&#8211;\u767b\u5f55rman<br \/>\n\t&nbsp; rman target \/<br \/>\n\t&nbsp; rman target sys\/passwork<br \/>\n\t&nbsp; rman target sys\/passwork nocatalog&nbsp;&nbsp; (\u63a7\u5236\u6587\u4ef6\u65b9\u5f0f)<br \/>\n\t&nbsp; rman target sys\/passwork catalog&nbsp;&nbsp;&nbsp;&nbsp; (\u6062\u590d\u76ee\u5f55\u65b9\u5f0f)\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u67e5\u770b\u53c2\u6570<br \/>\n\t&nbsp; show all\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u4fee\u6539\u4fdd\u5b58\u5929\u6570<br \/>\n\t&nbsp; \u7528sqlplus\u4fee\u6539\u5907\u4efd\u4fe1\u606f\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u4fdd\u7559\u7684\u5929\u6570<br \/>\n\t&nbsp; show parameter control_file_record_keep_time\n<\/p>\n<p>\n\t&nbsp; alter system set control_file_record_keep_time=30 scope=spfile<br \/>\n\t&nbsp; shutdown immediate<br \/>\n\t&nbsp; startup\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;rman\u6570\u636e\u5e93\u51b7\u5907\u4efd<br \/>\n\t&nbsp; shutdown immediate;<br \/>\n\t&nbsp; startup mount;<br \/>\n\t&nbsp; backup database format=&#39;\/u01\/backup\/rman\/%d_%T_%s.bak&#39;;<br \/>\n\t&nbsp; alter database open;<br \/>\n\t&nbsp; sql &#39;alter system archive log current&#39;;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;rman\u6570\u636e\u5e93\u70ed\u5907\u4efd<br \/>\n\t&nbsp; backup database format=&#39;\/u01\/backup\/rman\/%d_%T_%s.bak&#39;;<br \/>\n\t&nbsp; sql &#39;alter system archive log current&#39;;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efd\u8868\u7a7a\u95f4<br \/>\n\t&nbsp; backup tablespace emp\uff1b\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efd\u6570\u636e\u6587\u4ef6<br \/>\n\t&nbsp; backup datafile &#39;\/u01\/mytest.dbf&#39;;<br \/>\n\t&nbsp; backup datafile 5 format=&#39;\/u01\/backup\/rman\/%N_%s.dbf&#39;;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efd\u5f52\u6863\u65e5\u5fd7<br \/>\n\t&nbsp; backup archivelog all<br \/>\n\t&nbsp; backup archivelog from time &#39;sysdate-1&#39;<br \/>\n\t&nbsp; backup archivelog from sequence 400<br \/>\n\t&nbsp; backup archivelog all delete input<br \/>\n\t&nbsp; backup archivelog from sequence 400 delete input\n<\/p>\n<p>\n\t&nbsp; format=&#39;\/u01\/backup\/rman\/ar%T_%s.arc&#39;&nbsp;&nbsp; &#8211;\u6307\u5b9a\u8def\u5f84 %T \u65e5\u671f\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efd\u8fc7\u53bb\u4e00\u5929\u7684\u5f52\u6863\u6587\u4ef6<br \/>\n\t&nbsp; backup format=&#39;\/u01\/backup\/rman\/ar%d_%s.arc&#39;<br \/>\n\t&nbsp; archivelog<br \/>\n\t&nbsp; from time=&#39;sysdate-1&#39; until time=&#39;sysdate&#39;;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efd\u6570\u636e\u6587\u4ef6\u548c\u5f52\u6863\u65e5\u5fd7<br \/>\n\t&nbsp; backup format=&#39;\/u01\/backup\/rman\/t%d_%s.bak&#39; tablespace emp plus archivelog;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efd\u63a7\u5236\u6587\u4ef6<br \/>\n\t&nbsp; backup current controlfile format=&#39;\/u01\/backup\/rman\/%d_%s.ctl&#39;;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5907\u4efdspfile<br \/>\n\t&nbsp; backup spfile format=&#39;\/u01\/backup\/rman\/spf%d_%s.par&#39;;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u538b\u7f29\u5907\u4efd\u96c6<br \/>\n\tbackup as compressed backupset tablespace emp;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5efa\u7acb\u63a7\u5236\u6587\u4ef6\u6620\u50cf\u526f\u672c<br \/>\n\tcopy current controlfile to &#39;\/u01\/backup\/rman\/dbtest.ctl&#39;;<br \/>\n\tbackup as copy format=&#39;\/u01\/backup\/rman\/dbtest01.ctl&#39; current controlfile;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5efa\u7acb\u6570\u636e\u6587\u4ef6\u6620\u50cf\u526f\u672c<br \/>\n\tbackup as copy format=&#39;\/u01\/backup\/rman\/8.dbf&#39; datafile 8;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;rman\u7ef4\u62a4\u547d\u4ee4<br \/>\n\tlist backup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u5168\u90e8\u7684\u5907\u4efd\u4fe1\u606f<br \/>\n\tlist backup of database&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6570\u636e\u5e93\u5907\u4efd<br \/>\n\tlist backup of tablespace emp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6307\u5b9a\u7684\u8868\u7a7a\u95f4\u5907\u4efd<br \/>\n\tlist backup of datafile 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6307\u5b9a\u7684\u6570\u636e\u6587\u4ef6\u5907\u4efd<br \/>\n\tlist backup of controlfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u63a7\u5236\u6587\u4ef6\u5907\u4efd<br \/>\n\tlist backup of spfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51faspfile\u5907\u4efd<br \/>\n\tlist archivelog all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u5f52\u6863\u65e5\u5fd7<br \/>\n\tlist backup of archivelog all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u5f52\u6863\u65e5\u5fd7\u7684\u5907\u4efd\n<\/p>\n<p>\n\tlist backup of database summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u53ef\u7528\u7684\u5907\u4efd<br \/>\n\tlist backup of tablespace emp summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5173\u4e8e\u8868\u7a7a\u95f4\u7684\u5907\u4efd<br \/>\n\tlist backup by file&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u6309\u6587\u4ef6\u7c7b\u578b\u5217\u51fa\u5907\u4efd<br \/>\n\tlist expired backup of archivelog all summary&nbsp; &#8211;\u5931\u6548\u7684\u5907\u4efd\n<\/p>\n<p>\n\treport obsolete&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u67e5\u770b\u8fc7\u671f\u7684<br \/>\n\tdelete obsolete&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5220\u9664\u8fc7\u671f\u7684\n<\/p>\n<p>\n\tlist recoverable backup of database&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6709\u6548\u7684\u5907\u4efd<br \/>\n\tlist expired backup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u5931\u6548\u7684\u5907\u4efd\n<\/p>\n<p>\n\tlist expired backup of archivelog all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u5931\u6548\u7684\u5f52\u6863\u65e5\u5fd7\u5907\u4efd<br \/>\n\tlist expired backup of archivelog<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp; until sequence 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6307\u5b9a\u5e8f\u5217\u53f7\u7684\u5931\u6548\u5f52\u6863\u65e5\u5fd7\u5907\u4efd<br \/>\n\tlist expired backup of archivelog<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp; until time &quot;to_date(&#39;2012-6-30&#39;,&#39;yyyy-mm-dd&#39;)&quot;&nbsp;&nbsp;&nbsp;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6307\u5b9a\u65f6\u95f4\u7684\u5931\u6548\u5f52\u6863\u65e5\u5fd7\u5907\u4efd\u5907\u4efd\n<\/p>\n<p>\n\tlist copy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u6620\u50cf\u6587\u4ef6\u526f\u672c&nbsp;<br \/>\n\tlist copy of database<br \/>\n\tlist copy of tablespace emp<br \/>\n\tlist copy of datafile 6<br \/>\n\tlist copy of archivelog all<br \/>\n\tlist copy of controfile\n<\/p>\n<p>\n\treport schema<br \/>\n\treport need backup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u9700\u8981\u5907\u4efd\u7684<br \/>\n\treport need backup days 2 database&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5217\u51fa\u8d85\u8fc72\u5929\u6ca1\u6709\u5907\u4efd\u7684\n<\/p>\n<p>\n\tmount\u72b6\u6001\u4e0b<br \/>\n\tlist incarnation;<br \/>\n\treset database to incarnation 980;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u5220\u9664\u5931\u6548\u6587\u4ef6<br \/>\n\t\u5220\u9664\u5931\u6548\u5907\u4efd<br \/>\n\tcrosscheck backup(copy,archivelog all);<br \/>\n\tdelete expired backup(copy,archivelog all);\n<\/p>\n<p>\n\t<br \/>\n\t\u5220\u9664\u5931\u6548\u65e5\u5fd7<br \/>\n\tcrosscheck archivelog all;&nbsp;<br \/>\n\tdelete expired archivelog all;\n<\/p>\n<p>\n\tcrosscheck backup of tablespace sysaux&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u68c0\u67e5\u8868\u7a7a\u95f4\u5907\u4efd<br \/>\n\tcrosscheck backup of datafile 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u68c0\u67e5\u6570\u636e\u6587\u4ef62\u5907\u4efd<br \/>\n\tcrosscheck backup of controlfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u68c0\u67e5\u63a7\u5236\u6587\u4ef6\u5907\u4efd<br \/>\n\tcrosscheck backup of spfile&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u68c0\u67e5spfile<br \/>\n\tcrosscheck backup of copy&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u68c0\u67e5copy<br \/>\n\tcrosscheck backup completed after &#39;sysdate-2&#39;&nbsp; &#8211;\u5f53\u524d\u65f6\u95f4\u524d2\u5929\u7684\u5907\u4efd\n<\/p>\n<p>\n\tcrosscheck copy of database<br \/>\n\tcrosscheck copy of tablespace emp<br \/>\n\tcrosscheck copy of controlfile<br \/>\n\tcrosscheck copy of spfile\n<\/p>\n<p>\n\tlist backup summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u83b7\u5f97\u4e3b\u952e<br \/>\n\tvalidate backupset 16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u9a8c\u8bc1\u5907\u4efd\u96c616\u7684\u6709\u6548\u6027<br \/>\n\tchange&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u4fee\u6539\u5907\u4efd\u72b6\u6001<br \/>\n\tchange backupset 16 unavailable<br \/>\n\tchange backupset 16 available<br \/>\n\tchange archivelog &#39;\/u01\/backup\/rman\/***.log&#39; unavailable\n<\/p>\n<p>\n\tchange backupset 16 delete&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5220\u9664\u5907\u4efd\u96c616(\u540c\u6b65\u5220\u9664)<br \/>\n\tdelete expired backupset(archivelog all);&nbsp;&nbsp; &#8211;\u5220\u9664\u5931\u6548\n<\/p>\n<p>\n\tdelete expired&nbsp;&nbsp; &#8211;\u5220\u9664\u5931\u6548\u5907\u4efd<br \/>\n\tdelete obsolete&nbsp; &#8211;\u5220\u9664\u65e7\u4e8e\u5907\u4efd\u7b56\u7565\u65e5\u671f\uff08\u8fc7\u671f\uff09\u7684\u5907\u4efd\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u6062\u590d\u68c0\u67e5<br \/>\n\trestore database validate;<br \/>\n\tvalidate backupset 218;\n<\/p>\n<p>\n\trestore database preview;<br \/>\n\trestore tablespace users preview;<br \/>\n\trestore datafile 5 preview;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u547d\u4ee4\u5757<br \/>\n\trun{<br \/>\n\t2&gt; shutdown immediate;<br \/>\n\t3&gt; startup mount;<br \/>\n\t4&gt; allocate channel d1 type disk;<br \/>\n\t5&gt; backup as backupset database<br \/>\n\t6&gt; format=&#39;\/u01\/backup\/rman\/%d_%T.bak&#39;;<br \/>\n\t7&gt; alter database open;<br \/>\n\t8&gt; sql &#39;alter system archive log current&#39;;<br \/>\n\t9&gt; }\n<\/p>\n<p>\n\tselect * from v$log;<br \/>\n\tselect * from v$archived_log;<br \/>\n\tselect * from v$backup_redolog;\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;\u6062\u590d\u987e\u95ee<br \/>\n\tlist failure&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u8bca\u65ad\u9519\u8bef<br \/>\n\tadvise failure&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u5efa\u8bae<br \/>\n\trepair failure&nbsp;&nbsp;&nbsp;&nbsp; &#8211;\u4fee\u590d(\u6570\u636e\u6587\u4ef6\u548c\u63a7\u5236\u6587\u4ef6)\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;rman\u4e0b\u5bf9\u6570\u636e\u6587\u4ef6\u91cd\u547d\u540d<br \/>\n\trun{<br \/>\n\t2&gt; sql &#39;alter tablespace yesorno offline&#39;;<br \/>\n\t3&gt; set newname for datafile &#39;\/u01\/app\/oracle\/oradata\/yesorno.dbf&#39;<br \/>\n\t4&gt; to &#39;\/u01\/app\/oracle\/oradata\/yesorno01.dbf&#39;;<br \/>\n\t5&gt; restore tablespace yesorno;<br \/>\n\t6&gt; switch datafile all;<br \/>\n\t7&gt; recover tablespace yesorno;<br \/>\n\t8&gt; sql &#39;alter tablespace yesorno online&#39;;<br \/>\n\t}\n<\/p>\n<p>\n\t<br \/>\n\t&#8211;rman\u4e0b\u5bf9\u6570\u636e\u6587\u4ef6\u79fb\u52a8<br \/>\n\trun{<br \/>\n\t2&gt; sql &#39;alter tablespace yesorno offline&#39;;<br \/>\n\t3&gt; set newname for datafile &#39;\/u01\/app\/oracle\/oradata\/yesorno01.dbf&#39;<br \/>\n\t4&gt; to &#39;\/u01\/app\/oracle\/oradata\/dbtest\/yesorno01.dbf&#39;;<br \/>\n\t5&gt; restore tablespace yesorno;<br \/>\n\t6&gt; switch datafile all;<br \/>\n\t7&gt; recover tablespace yesorno;<br \/>\n\t8&gt; sql &#39;alter tablespace yesorno online&#39;;<br \/>\n\t}\n<\/p>\n<p>\n\t<script src=\"https:\/\/csdnimg.cn\/search\/baidu_search-1.1.2.js?v=201802071056&amp;autorun=true&amp;install=true&amp;keyword=dropped+file%E5%95%A5%E6%84%8F%E6%80%9D\" type=\"text\/javascript\"><\/script>\n<\/p>\n<style type=\"text\/css\">\n.MathJax, .MathJax_Message, .MathJax_Preview{\n                display: none\n            }<\/style>\n<p>\n\t<script src=\"https:\/\/csdnimg.cn\/static\/api\/js\/share.js?v=89860594\"><\/script>\n<\/p>\n<style type=\"text\/css\">\n.MathJax_Hover_Frame {border-radius: .25em; -webkit-border-radius: .25em; -moz-border-radius: .25em; -khtml-border-radius: .25em; box-shadow: 0px 0px 15px #83A; -webkit-box-shadow: 0px 0px 15px #83A; -moz-box-shadow: 0px 0px 15px #83A; -khtml-box-shadow: 0px 0px 15px #83A; border: 1px solid #A6D ! important; display: inline-block; position: absolute}\n.MathJax_Menu_Button .MathJax_Hover_Arrow {position: absolute; cursor: pointer; display: inline-block; border: 2px solid #AAA; border-radius: 4px; -webkit-border-radius: 4px; -moz-border-radius: 4px; -khtml-border-radius: 4px; font-family: 'Courier New',Courier; font-size: 9px; color: #F0F0F0}\n.MathJax_Menu_Button .MathJax_Hover_Arrow span {display: block; background-color: #AAA; border: 1px solid; border-radius: 3px; line-height: 0; padding: 4px}\n.MathJax_Hover_Arrow:hover {color: white!important; border: 2px solid #CCC!important}\n.MathJax_Hover_Arrow:hover span {background-color: #CCC!important}<\/style>\n<style type=\"text\/css\">\n#MathJax_About {position: fixed; left: 50%; width: auto; text-align: center; border: 3px outset; padding: 1em 2em; background-color: #DDDDDD; color: black; cursor: default; font-family: message-box; font-size: 120%; font-style: normal; text-indent: 0; text-transform: none; line-height: normal; letter-spacing: normal; word-spacing: normal; word-wrap: normal; white-space: nowrap; float: none; z-index: 201; border-radius: 15px; -webkit-border-radius: 15px; -moz-border-radius: 15px; -khtml-border-radius: 15px; box-shadow: 0px 10px 20px #808080; -webkit-box-shadow: 0px 10px 20px #808080; -moz-box-shadow: 0px 10px 20px #808080; -khtml-box-shadow: 0px 10px 20px #808080}\n#MathJax_About.MathJax_MousePost {outline: none}\n.MathJax_Menu {position: absolute; background-color: white; color: black; width: auto; padding: 2px; border: 1px solid #CCCCCC; margin: 0; cursor: default; font: menu; text-align: left; text-indent: 0; text-transform: none; line-height: normal; letter-spacing: normal; word-spacing: normal; word-wrap: normal; white-space: nowrap; float: none; z-index: 201; box-shadow: 0px 10px 20px #808080; -webkit-box-shadow: 0px 10px 20px #808080; -moz-box-shadow: 0px 10px 20px #808080; -khtml-box-shadow: 0px 10px 20px #808080}\n.MathJax_MenuItem {padding: 2px 2em; background: transparent}\n.MathJax_MenuArrow {position: absolute; right: .5em; padding-top: .25em; color: #666666; font-family: 'Arial unicode MS'; font-size: .75em}\n.MathJax_MenuActive .MathJax_MenuArrow {color: white}\n.MathJax_MenuArrow.RTL {left: .5em; right: auto}\n.MathJax_MenuCheck {position: absolute; left: .7em; font-family: 'Arial unicode MS'}\n.MathJax_MenuCheck.RTL {right: .7em; left: auto}\n.MathJax_MenuRadioCheck {position: absolute; left: 1em}\n.MathJax_MenuRadioCheck.RTL {right: 1em; left: auto}\n.MathJax_MenuLabel {padding: 2px 2em 4px 1.33em; font-style: italic}\n.MathJax_MenuRule {border-top: 1px solid #CCCCCC; margin: 4px 1px 0px}\n.MathJax_MenuDisabled {color: GrayText}\n.MathJax_MenuActive {background-color: Highlight; color: HighlightText}\n.MathJax_MenuDisabled:focus, .MathJax_MenuLabel:focus {background-color: #E8E8E8}\n.MathJax_ContextMenu:focus {outline: none}\n.MathJax_ContextMenu .MathJax_MenuItem:focus {outline: none}\n#MathJax_AboutClose {top: .2em; right: .2em}\n.MathJax_Menu .MathJax_MenuClose {top: -10px; left: -10px}\n.MathJax_MenuClose {position: absolute; cursor: pointer; display: inline-block; border: 2px solid #AAA; border-radius: 18px; -webkit-border-radius: 18px; -moz-border-radius: 18px; -khtml-border-radius: 18px; font-family: 'Courier New',Courier; font-size: 24px; color: #F0F0F0}\n.MathJax_MenuClose span {display: block; background-color: #AAA; border: 1.5px solid; border-radius: 18px; -webkit-border-radius: 18px; -moz-border-radius: 18px; -khtml-border-radius: 18px; line-height: 0; padding: 8px 0 6px}\n.MathJax_MenuClose:hover {color: white!important; border: 2px solid #CCC!important}\n.MathJax_MenuClose:hover span {background-color: #CCC!important}\n.MathJax_MenuClose:hover:focus {outline: none}<\/style>\n<style type=\"text\/css\">\n.MathJax_Preview .MJXf-math {color: inherit!important}<\/style>\n<style type=\"text\/css\">\n.MJX_Assistive_MathML {position: absolute!important; top: 0; left: 0; clip: rect(1px, 1px, 1px, 1px); padding: 1px 0 0 0!important; border: 0!important; height: 1px!important; width: 1px!important; overflow: hidden!important; display: block!important; -webkit-touch-callout: none; -webkit-user-select: none; -khtml-user-select: none; -moz-user-select: none; -ms-user-select: none; user-select: none}\n.MJX_Assistive_MathML.MJX_Assistive_MathML_Block {width: 100%!important}<\/style>\n<style type=\"text\/css\">\n#MathJax_Zoom {position: absolute; background-color: #F0F0F0; overflow: auto; display: block; z-index: 301; padding: .5em; border: 1px solid black; margin: 0; font-weight: normal; font-style: normal; text-align: left; text-indent: 0; text-transform: none; line-height: normal; letter-spacing: normal; word-spacing: normal; word-wrap: normal; white-space: nowrap; float: none; -webkit-box-sizing: content-box; -moz-box-sizing: content-box; box-sizing: content-box; box-shadow: 5px 5px 15px #AAAAAA; -webkit-box-shadow: 5px 5px 15px #AAAAAA; -moz-box-shadow: 5px 5px 15px #AAAAAA; -khtml-box-shadow: 5px 5px 15px #AAAAAA}\n#MathJax_ZoomOverlay {position: absolute; left: 0; top: 0; z-index: 300; display: inline-block; width: 100%; height: 100%; border: 0; padding: 0; margin: 0; background-color: white; opacity: 0; filter: alpha(opacity=0)}\n#MathJax_ZoomFrame {position: relative; display: inline-block; height: 0; width: 0}\n#MathJax_ZoomEventTrap {position: absolute; left: 0; top: 0; z-index: 302; display: inline-block; border: 0; padding: 0; margin: 0; background-color: white; opacity: 0; filter: alpha(opacity=0)}<\/style>\n<style type=\"text\/css\">\n.MathJax_Preview {color: #888}\n#MathJax_Message {position: fixed; left: 1px; bottom: 2px; background-color: #E6E6E6; border: 1px solid #959595; margin: 0px; padding: 2px 8px; z-index: 102; color: black; font-size: 80%; width: auto; white-space: nowrap}\n#MathJax_MSIE_Frame {position: absolute; top: 0; left: 0; width: 0px; z-index: 101; border: 0px; margin: 0px; padding: 0px}\n.MathJax_Error {color: #CC0000; font-style: italic}<\/style>\n<p>\n\t<script src=\"\/\/csdnimg.cn\/search\/baidu_opensug-1.0.0.js\" type=\"text\/javascript\"><\/script>\n<\/p>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n<\/style>\n<style type=\"text\/css\">\n.MJXp-script {font-size: .8em}\n.MJXp-right {-webkit-transform-origin: right; -moz-transform-origin: right; -ms-transform-origin: right; -o-transform-origin: right; transform-origin: right}\n.MJXp-bold {font-weight: bold}\n.MJXp-italic {font-style: italic}\n.MJXp-scr {font-family: MathJax_Script,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-frak {font-family: MathJax_Fraktur,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-sf {font-family: MathJax_SansSerif,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-cal {font-family: MathJax_Caligraphic,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-mono {font-family: MathJax_Typewriter,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-largeop {font-size: 150%}\n.MJXp-largeop.MJXp-int {vertical-align: -.2em}\n.MJXp-math {display: inline-block; line-height: 1.2; text-indent: 0; font-family: 'Times New Roman',Times,STIXGeneral,serif; white-space: nowrap; border-collapse: collapse}\n.MJXp-display {display: block; text-align: center; margin: 1em 0}\n.MJXp-math span {display: inline-block}\n.MJXp-box {display: block!important; text-align: center}\n.MJXp-box:after {content: \" \"}\n.MJXp-rule {display: block!important; margin-top: .1em}\n.MJXp-char {display: block!important}\n.MJXp-mo {margin: 0 .15em}\n.MJXp-mfrac {margin: 0 .125em; vertical-align: .25em}\n.MJXp-denom {display: inline-table!important; width: 100%}\n.MJXp-denom > * {display: table-row!important}\n.MJXp-surd {vertical-align: top}\n.MJXp-surd > * {display: block!important}\n.MJXp-script-box > *  {display: table!important; height: 50%}\n.MJXp-script-box > * > * {display: table-cell!important; vertical-align: top}\n.MJXp-script-box > *:last-child > * {vertical-align: bottom}\n.MJXp-script-box > * > * > * {display: block!important}\n.MJXp-mphantom {visibility: hidden}\n.MJXp-munderover {display: inline-table!important}\n.MJXp-over {display: inline-block!important; text-align: center}\n.MJXp-over > * {display: block!important}\n.MJXp-munderover > * {display: table-row!important}\n.MJXp-mtable {vertical-align: .25em; margin: 0 .125em}\n.MJXp-mtable > * {display: inline-table!important; vertical-align: middle}\n.MJXp-mtr {display: table-row!important}\n.MJXp-mtd {display: table-cell!important; text-align: center; padding: .5em 0 0 .5em}\n.MJXp-mtr > .MJXp-mtd:first-child {padding-left: 0}\n.MJXp-mtr:first-child > .MJXp-mtd {padding-top: 0}\n.MJXp-mlabeledtr {display: table-row!important}\n.MJXp-mlabeledtr > .MJXp-mtd:first-child {padding-left: 0}\n.MJXp-mlabeledtr:first-child > .MJXp-mtd {padding-top: 0}\n.MJXp-merror {background-color: #FFFF88; color: #CC0000; border: 1px solid #CC0000; padding: 1px 3px; font-style: normal; font-size: 90%}\n.MJXp-scale0 {-webkit-transform: scaleX(.0); -moz-transform: scaleX(.0); -ms-transform: scaleX(.0); -o-transform: scaleX(.0); transform: scaleX(.0)}\n.MJXp-scale1 {-webkit-transform: scaleX(.1); -moz-transform: scaleX(.1); -ms-transform: scaleX(.1); -o-transform: scaleX(.1); transform: scaleX(.1)}\n.MJXp-scale2 {-webkit-transform: scaleX(.2); -moz-transform: scaleX(.2); -ms-transform: scaleX(.2); -o-transform: scaleX(.2); transform: scaleX(.2)}\n.MJXp-scale3 {-webkit-transform: scaleX(.3); -moz-transform: scaleX(.3); -ms-transform: scaleX(.3); -o-transform: scaleX(.3); transform: scaleX(.3)}\n.MJXp-scale4 {-webkit-transform: scaleX(.4); -moz-transform: scaleX(.4); -ms-transform: scaleX(.4); -o-transform: scaleX(.4); transform: scaleX(.4)}\n.MJXp-scale5 {-webkit-transform: scaleX(.5); -moz-transform: scaleX(.5); -ms-transform: scaleX(.5); -o-transform: scaleX(.5); transform: scaleX(.5)}\n.MJXp-scale6 {-webkit-transform: scaleX(.6); -moz-transform: scaleX(.6); -ms-transform: scaleX(.6); -o-transform: scaleX(.6); transform: scaleX(.6)}\n.MJXp-scale7 {-webkit-transform: scaleX(.7); -moz-transform: scaleX(.7); -ms-transform: scaleX(.7); -o-transform: scaleX(.7); transform: scaleX(.7)}\n.MJXp-scale8 {-webkit-transform: scaleX(.8); -moz-transform: scaleX(.8); -ms-transform: scaleX(.8); -o-transform: scaleX(.8); transform: scaleX(.8)}\n.MJXp-scale9 {-webkit-transform: scaleX(.9); -moz-transform: scaleX(.9); -ms-transform: scaleX(.9); -o-transform: scaleX(.9); transform: scaleX(.9)}\n.MathJax_PHTML .noError {vertical-align: -2px; font-size: 90%; text-align: left; color: black; padding: 1px 3px; border: 1px solid}<\/style>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p>\n\t&nbsp;\n<\/p>\n<p><main><\/p>\n<p>\n\t\t&nbsp;\n\t<\/p>\n<p>\n\t\t&nbsp;\n\t<\/p>\n<p>\n\t\t&nbsp;\n\t<\/p>\n<article>\n<h1>\n\t\t\t<!--StartFragment-->Oracle \u4e2dcontrol_file_record_keep_time\u53c2\u6570\u7684\u89e3\u91ca<!--EndFragment--><br \/>\n\t\t<\/h1>\n<p>\n\t\t\t<script src=\"https:\/\/pos.baidu.com\/hchm?di=5565702&amp;dri=0&amp;dis=0&amp;dai=0&amp;ps=2455x78&amp;enu=encoding&amp;dcb=___adblockplus&amp;dtm=SSP_JSONP&amp;dvi=0.0&amp;dci=-1&amp;dpt=none&amp;tsr=0&amp;tpr=1524533631640&amp;ti=Oracle%20%E4%B8%ADcontrol_file_record_keep_time%E5%8F%82%E6%95%B0%E7%9A%84%E8%A7%A3%E9%87%8A%20-%20CSDN%E5%8D%9A%E5%AE%A2&amp;ari=2&amp;dbv=0&amp;drs=3&amp;pcs=1313x614&amp;pss=1313x4341&amp;cfv=0&amp;cpl=1&amp;chi=1&amp;cce=true&amp;cec=utf-8&amp;tlm=1524533633&amp;prot=2&amp;rw=614&amp;ltu=https%3A%2F%2Fblog.csdn.net%2Fzhjxixi%2Farticle%2Fdetails%2F7627490&amp;ltr=%20https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3Dn9WPj5C8rD_YBJwD9Y1-FjUnxm6NQNEAnBfvCOIBvQ554EMIqJulFAOXnbNPy01J1HTcI0oadOvDBjtaGlAqX_%26wd%3D%26eqid%3Dd654212b00001dcc000000025ade897a&amp;lcr=%20https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3Dn9WPj5C8rD_YBJwD9Y1-FjUnxm6NQNEAnBfvCOIBvQ554EMIqJulFAOXnbNPy01J1HTcI0oadOvDBjtaGlAqX_%26wd%3D%26eqid%3Dd654212b00001dcc000000025ade897a&amp;ecd=1&amp;uc=1366x728&amp;pis=-1x-1&amp;sr=1366x768&amp;tcn=1524533633\" type=\"text\/javascript\" async=\"\"><\/script><script src=\"https:\/\/cpro.baidustatic.com\/cpro\/ui\/pr.js\" type=\"text\/javascript\" async=\"\"><\/script><script src=\"https:\/\/cee1.iteye.com\/bvzdlc.js\" type=\"text\/javascript\" async=\"\"><\/script><script src=\"https:\/\/goutong.baidu.com\/site\/279\/6bcd52f51e9b3dce32bec4a3997715ac\/b.js?siteId=6583558\" charset=\"utf-8\"><\/script><script src=\"https:\/\/goutong.baidu.com\/site\/279\/6bcd52f51e9b3dce32bec4a3997715ac\/b.js?siteId=6583558\" charset=\"utf-8\"><\/script><script src=\"https:\/\/hm.baidu.com\/hm.js?6bcd52f51e9b3dce32bec4a3997715ac\"><\/script><script src=\"https:\/\/gsp0.baidu.com\/yrwHcjSl0MgCo2Kml5_Y_D3\/api\/customsearch\/apiaccept?sid=10742016945123576423&amp;v=2.0&amp;callback=csdn.afterBaiduSearchInit\" type=\"text\/javascript\" charset=\"utf-8\"><\/script><script src=\"https:\/\/hm.baidu.com\/hm.js?6bcd52f51e9b3dce32bec4a3997715ac\"><\/script><script type=\"text\/javascript\">\n        var username = \"zhjxixi\";\n        var _blogger = username;\n        var blog_address = \"https:\/\/blog.csdn.net\/zhjxixi\";\n        var static_host = \"https:\/\/csdnimg.cn\/release\/phoenix\/\";\n        var currentUserName = \"\"; \n        var fileName = '7627490';\n        var commentscount = 0;\n        var islock = false;\n        window.quickReplyflag = true;\n        var totalFloor = 0;\n        var isBole = false;\n        var isDigg = false;\n        var isExpert = false;\n        var isAdm = false;\n        var baiduKey = \"dropped+file%E5%95%A5%E6%84%8F%E6%80%9D\";\n        var needInsertBaidu = false;\n        var isShowAds = true;\n        var ChannelId = 6;<\/script><script src=\"https:\/\/csdnimg.cn\/public\/common\/libs\/jquery\/jquery-1.9.1.min.js\" type=\"text\/javascript\"><\/script><script src=\"https:\/\/csdnimg.cn\/rabbit\/exposure-click\/main-1.0.5.js\"><\/script><script src=\"https:\/\/csdnimg.cn\/pubfooter\/js\/tracking-1.0.2.js\" type=\"text\/javascript\" charset=\"utf-8\"><\/script><script src=\"https:\/\/csdnimg.cn\/release\/phoenix\/production\/main-e96db8abdf.js\" type=\"text\/javascript\"><\/script><script src=\"https:\/\/dup.baidustatic.com\/js\/ds.js\"><\/script><script type=\"text\/javascript\">\n        \/\/ Traffic Stats of the entire Web site By baidu\n        var _hmt = _hmt || [];\n        (function() {\n            var hm = document.createElement(\"script\");\n            hm.src = \"https:\/\/hm.baidu.com\/hm.js?6bcd52f51e9b3dce32bec4a3997715ac\";\n            var s = document.getElementsByTagName(\"script\")[0];\n            s.parentNode.insertBefore(hm, s);\n        })();\n        \/\/ Traffic Stats of the entire Web site By baidu end<\/script>Oracle \u4e2dcontrol_file_record_keep_time\u53c2\u6570\u7684\u89e3\u91ca &#8211; CSDN\u535a\u5ba2 <script src=\"https:\/\/csdnimg.cn\/search\/baidu_search-1.1.2.js?v=201802071056&amp;autorun=true&amp;install=true&amp;keyword=dropped+file%E5%95%A5%E6%84%8F%E6%80%9D\" type=\"text\/javascript\"><\/script>\n\t\t<\/p>\n<style type=\"text\/css\">\n.MathJax, .MathJax_Message, .MathJax_Preview{\n                display: none\n            }\t\t<\/style>\n<p>\n\t\t\t<script src=\"https:\/\/csdnimg.cn\/static\/api\/js\/share.js?v=89860594\"><\/script>\n\t\t<\/p>\n<style type=\"text\/css\">\n.MathJax_Hover_Frame {border-radius: .25em; -webkit-border-radius: .25em; -moz-border-radius: .25em; -khtml-border-radius: .25em; box-shadow: 0px 0px 15px #83A; -webkit-box-shadow: 0px 0px 15px #83A; -moz-box-shadow: 0px 0px 15px #83A; -khtml-box-shadow: 0px 0px 15px #83A; border: 1px solid #A6D ! important; display: inline-block; position: absolute}\n.MathJax_Menu_Button .MathJax_Hover_Arrow {position: absolute; cursor: pointer; display: inline-block; border: 2px solid #AAA; border-radius: 4px; -webkit-border-radius: 4px; -moz-border-radius: 4px; -khtml-border-radius: 4px; font-family: 'Courier New',Courier; font-size: 9px; color: #F0F0F0}\n.MathJax_Menu_Button .MathJax_Hover_Arrow span {display: block; background-color: #AAA; border: 1px solid; border-radius: 3px; line-height: 0; padding: 4px}\n.MathJax_Hover_Arrow:hover {color: white!important; border: 2px solid #CCC!important}\n.MathJax_Hover_Arrow:hover span {background-color: #CCC!important}\t\t<\/style>\n<style type=\"text\/css\">\n#MathJax_About {position: fixed; left: 50%; width: auto; text-align: center; border: 3px outset; padding: 1em 2em; background-color: #DDDDDD; color: black; cursor: default; font-family: message-box; font-size: 120%; font-style: normal; text-indent: 0; text-transform: none; line-height: normal; letter-spacing: normal; word-spacing: normal; word-wrap: normal; white-space: nowrap; float: none; z-index: 201; border-radius: 15px; -webkit-border-radius: 15px; -moz-border-radius: 15px; -khtml-border-radius: 15px; box-shadow: 0px 10px 20px #808080; -webkit-box-shadow: 0px 10px 20px #808080; -moz-box-shadow: 0px 10px 20px #808080; -khtml-box-shadow: 0px 10px 20px #808080}\n#MathJax_About.MathJax_MousePost {outline: none}\n.MathJax_Menu {position: absolute; background-color: white; color: black; width: auto; padding: 2px; border: 1px solid #CCCCCC; margin: 0; cursor: default; font: menu; text-align: left; text-indent: 0; text-transform: none; line-height: normal; letter-spacing: normal; word-spacing: normal; word-wrap: normal; white-space: nowrap; float: none; z-index: 201; box-shadow: 0px 10px 20px #808080; -webkit-box-shadow: 0px 10px 20px #808080; -moz-box-shadow: 0px 10px 20px #808080; -khtml-box-shadow: 0px 10px 20px #808080}\n.MathJax_MenuItem {padding: 2px 2em; background: transparent}\n.MathJax_MenuArrow {position: absolute; right: .5em; padding-top: .25em; color: #666666; font-family: 'Arial unicode MS'; font-size: .75em}\n.MathJax_MenuActive .MathJax_MenuArrow {color: white}\n.MathJax_MenuArrow.RTL {left: .5em; right: auto}\n.MathJax_MenuCheck {position: absolute; left: .7em; font-family: 'Arial unicode MS'}\n.MathJax_MenuCheck.RTL {right: .7em; left: auto}\n.MathJax_MenuRadioCheck {position: absolute; left: 1em}\n.MathJax_MenuRadioCheck.RTL {right: 1em; left: auto}\n.MathJax_MenuLabel {padding: 2px 2em 4px 1.33em; font-style: italic}\n.MathJax_MenuRule {border-top: 1px solid #CCCCCC; margin: 4px 1px 0px}\n.MathJax_MenuDisabled {color: GrayText}\n.MathJax_MenuActive {background-color: Highlight; color: HighlightText}\n.MathJax_MenuDisabled:focus, .MathJax_MenuLabel:focus {background-color: #E8E8E8}\n.MathJax_ContextMenu:focus {outline: none}\n.MathJax_ContextMenu .MathJax_MenuItem:focus {outline: none}\n#MathJax_AboutClose {top: .2em; right: .2em}\n.MathJax_Menu .MathJax_MenuClose {top: -10px; left: -10px}\n.MathJax_MenuClose {position: absolute; cursor: pointer; display: inline-block; border: 2px solid #AAA; border-radius: 18px; -webkit-border-radius: 18px; -moz-border-radius: 18px; -khtml-border-radius: 18px; font-family: 'Courier New',Courier; font-size: 24px; color: #F0F0F0}\n.MathJax_MenuClose span {display: block; background-color: #AAA; border: 1.5px solid; border-radius: 18px; -webkit-border-radius: 18px; -moz-border-radius: 18px; -khtml-border-radius: 18px; line-height: 0; padding: 8px 0 6px}\n.MathJax_MenuClose:hover {color: white!important; border: 2px solid #CCC!important}\n.MathJax_MenuClose:hover span {background-color: #CCC!important}\n.MathJax_MenuClose:hover:focus {outline: none}\t\t<\/style>\n<style type=\"text\/css\">\n.MathJax_Preview .MJXf-math {color: inherit!important}\t\t<\/style>\n<style type=\"text\/css\">\n.MJX_Assistive_MathML {position: absolute!important; top: 0; left: 0; clip: rect(1px, 1px, 1px, 1px); padding: 1px 0 0 0!important; border: 0!important; height: 1px!important; width: 1px!important; overflow: hidden!important; display: block!important; -webkit-touch-callout: none; -webkit-user-select: none; -khtml-user-select: none; -moz-user-select: none; -ms-user-select: none; user-select: none}\n.MJX_Assistive_MathML.MJX_Assistive_MathML_Block {width: 100%!important}\t\t<\/style>\n<style type=\"text\/css\">\n#MathJax_Zoom {position: absolute; background-color: #F0F0F0; overflow: auto; display: block; z-index: 301; padding: .5em; border: 1px solid black; margin: 0; font-weight: normal; font-style: normal; text-align: left; text-indent: 0; text-transform: none; line-height: normal; letter-spacing: normal; word-spacing: normal; word-wrap: normal; white-space: nowrap; float: none; -webkit-box-sizing: content-box; -moz-box-sizing: content-box; box-sizing: content-box; box-shadow: 5px 5px 15px #AAAAAA; -webkit-box-shadow: 5px 5px 15px #AAAAAA; -moz-box-shadow: 5px 5px 15px #AAAAAA; -khtml-box-shadow: 5px 5px 15px #AAAAAA}\n#MathJax_ZoomOverlay {position: absolute; left: 0; top: 0; z-index: 300; display: inline-block; width: 100%; height: 100%; border: 0; padding: 0; margin: 0; background-color: white; opacity: 0; filter: alpha(opacity=0)}\n#MathJax_ZoomFrame {position: relative; display: inline-block; height: 0; width: 0}\n#MathJax_ZoomEventTrap {position: absolute; left: 0; top: 0; z-index: 302; display: inline-block; border: 0; padding: 0; margin: 0; background-color: white; opacity: 0; filter: alpha(opacity=0)}\t\t<\/style>\n<style type=\"text\/css\">\n.MathJax_Preview {color: #888}\n#MathJax_Message {position: fixed; left: 1px; bottom: 2px; background-color: #E6E6E6; border: 1px solid #959595; margin: 0px; padding: 2px 8px; z-index: 102; color: black; font-size: 80%; width: auto; white-space: nowrap}\n#MathJax_MSIE_Frame {position: absolute; top: 0; left: 0; width: 0px; z-index: 101; border: 0px; margin: 0px; padding: 0px}\n.MathJax_Error {color: #CC0000; font-style: italic}\t\t<\/style>\n<p>\n\t\t\t<script src=\"\/\/csdnimg.cn\/search\/baidu_opensug-1.0.0.js\" type=\"text\/javascript\"><\/script>\n\t\t<\/p>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n\t\t<\/style>\n<style type=\"text\/css\">\n.MJXp-script {font-size: .8em}\n.MJXp-right {-webkit-transform-origin: right; -moz-transform-origin: right; -ms-transform-origin: right; -o-transform-origin: right; transform-origin: right}\n.MJXp-bold {font-weight: bold}\n.MJXp-italic {font-style: italic}\n.MJXp-scr {font-family: MathJax_Script,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-frak {font-family: MathJax_Fraktur,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-sf {font-family: MathJax_SansSerif,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-cal {font-family: MathJax_Caligraphic,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-mono {font-family: MathJax_Typewriter,'Times New Roman',Times,STIXGeneral,serif}\n.MJXp-largeop {font-size: 150%}\n.MJXp-largeop.MJXp-int {vertical-align: -.2em}\n.MJXp-math {display: inline-block; line-height: 1.2; text-indent: 0; font-family: 'Times New Roman',Times,STIXGeneral,serif; white-space: nowrap; border-collapse: collapse}\n.MJXp-display {display: block; text-align: center; margin: 1em 0}\n.MJXp-math span {display: inline-block}\n.MJXp-box {display: block!important; text-align: center}\n.MJXp-box:after {content: \" \"}\n.MJXp-rule {display: block!important; margin-top: .1em}\n.MJXp-char {display: block!important}\n.MJXp-mo {margin: 0 .15em}\n.MJXp-mfrac {margin: 0 .125em; vertical-align: .25em}\n.MJXp-denom {display: inline-table!important; width: 100%}\n.MJXp-denom > * {display: table-row!important}\n.MJXp-surd {vertical-align: top}\n.MJXp-surd > * {display: block!important}\n.MJXp-script-box > *  {display: table!important; height: 50%}\n.MJXp-script-box > * > * {display: table-cell!important; vertical-align: top}\n.MJXp-script-box > *:last-child > * {vertical-align: bottom}\n.MJXp-script-box > * > * > * {display: block!important}\n.MJXp-mphantom {visibility: hidden}\n.MJXp-munderover {display: inline-table!important}\n.MJXp-over {display: inline-block!important; text-align: center}\n.MJXp-over > * {display: block!important}\n.MJXp-munderover > * {display: table-row!important}\n.MJXp-mtable {vertical-align: .25em; margin: 0 .125em}\n.MJXp-mtable > * {display: inline-table!important; vertical-align: middle}\n.MJXp-mtr {display: table-row!important}\n.MJXp-mtd {display: table-cell!important; text-align: center; padding: .5em 0 0 .5em}\n.MJXp-mtr > .MJXp-mtd:first-child {padding-left: 0}\n.MJXp-mtr:first-child > .MJXp-mtd {padding-top: 0}\n.MJXp-mlabeledtr {display: table-row!important}\n.MJXp-mlabeledtr > .MJXp-mtd:first-child {padding-left: 0}\n.MJXp-mlabeledtr:first-child > .MJXp-mtd {padding-top: 0}\n.MJXp-merror {background-color: #FFFF88; color: #CC0000; border: 1px solid #CC0000; padding: 1px 3px; font-style: normal; font-size: 90%}\n.MJXp-scale0 {-webkit-transform: scaleX(.0); -moz-transform: scaleX(.0); -ms-transform: scaleX(.0); -o-transform: scaleX(.0); transform: scaleX(.0)}\n.MJXp-scale1 {-webkit-transform: scaleX(.1); -moz-transform: scaleX(.1); -ms-transform: scaleX(.1); -o-transform: scaleX(.1); transform: scaleX(.1)}\n.MJXp-scale2 {-webkit-transform: scaleX(.2); -moz-transform: scaleX(.2); -ms-transform: scaleX(.2); -o-transform: scaleX(.2); transform: scaleX(.2)}\n.MJXp-scale3 {-webkit-transform: scaleX(.3); -moz-transform: scaleX(.3); -ms-transform: scaleX(.3); -o-transform: scaleX(.3); transform: scaleX(.3)}\n.MJXp-scale4 {-webkit-transform: scaleX(.4); -moz-transform: scaleX(.4); -ms-transform: scaleX(.4); -o-transform: scaleX(.4); transform: scaleX(.4)}\n.MJXp-scale5 {-webkit-transform: scaleX(.5); -moz-transform: scaleX(.5); -ms-transform: scaleX(.5); -o-transform: scaleX(.5); transform: scaleX(.5)}\n.MJXp-scale6 {-webkit-transform: scaleX(.6); -moz-transform: scaleX(.6); -ms-transform: scaleX(.6); -o-transform: scaleX(.6); transform: scaleX(.6)}\n.MJXp-scale7 {-webkit-transform: scaleX(.7); -moz-transform: scaleX(.7); -ms-transform: scaleX(.7); -o-transform: scaleX(.7); transform: scaleX(.7)}\n.MJXp-scale8 {-webkit-transform: scaleX(.8); -moz-transform: scaleX(.8); -ms-transform: scaleX(.8); -o-transform: scaleX(.8); transform: scaleX(.8)}\n.MJXp-scale9 {-webkit-transform: scaleX(.9); -moz-transform: scaleX(.9); -ms-transform: scaleX(.9); -o-transform: scaleX(.9); transform: scaleX(.9)}\n.MathJax_PHTML .noError {vertical-align: -2px; font-size: 90%; text-align: left; color: black; padding: 1px 3px; border: 1px solid}\t\t<\/style>\n<p>\n\t\t\t&nbsp;\n\t\t<\/p>\n<p>\n\t\t\t&nbsp;\n\t\t<\/p>\n<p>\n\t\t\t&nbsp;\n\t\t<\/p>\n<p>\n\t\t\t&nbsp;\n\t\t<\/p>\n<p>\t\t<main><\/p>\n<p>\n\t\t\t\t&nbsp;\n\t\t\t<\/p>\n<p>\n\t\t\t\t&nbsp;\n\t\t\t<\/p>\n<p>\n\t\t\t\t&nbsp;\n\t\t\t<\/p>\n<article>\n\t\t\t\t<!--StartFragment--><\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tOracle\u57fa\u4e8eRMAN\u7684\u5907\u4efd\u65b9\u5f0f\uff0c\u53ef\u5206\u4e3a\u4ee5catalog \u548cnocatalog\u7684\u4e24\u79cd\u65b9\u5f0f\u8fdb\u884c\u5907\u4efd\u7ba1\u7406\u3002\u5176\u4e2d\uff0ccatalog\u7684\u65b9\u5f0f\u9700\u8981\u4e00\u4e2acatalog\u76ee\u5f55<a href=\"http:\/\/www.2cto.com\/database\/\" target=\"_blank\">\u6570\u636e\u5e93<\/a>\uff0c\u8fd9\u4e2a\u6570\u636e\u5e93\u4e00\u822c\u8fd0\u884c\u5728\u53e6\u5916\u4e00\u53f0\u670d\u52a1\u5668\u4e0a\uff0c\u8fd9\u79cd\u65b9\u5f0f\u53ef\u4ee5\u7528\u4e8e\u7528\u6237\u6709\u591a\u4e2a<a href=\"http:\/\/www.2cto.com\/database\/Oracle\/\" target=\"_blank\">Oracle<\/a>\u6570\u636e\u5e93\u7684\u73af\u5883\uff0c\u540c\u65f6\u5bf9\u6570\u636e\u5e93\u7684\u5907\u4efd\u6062\u590d\u4fe1\u606f\u4e5f\u53ef\u4ee5\u957f\u4e45\u7684\u4fdd\u5b58\uff0c\u4e5f\u5c31\u662fRMAN\u628a\u5bf9\u6570\u636e\u5e93A\u7684\u5907\u4efd\u6062\u590d\u8bb0\u5f55\u4fdd\u7559\u5728catalog\u76ee\u5f55\u6570\u636e\u5e93\u4e2d\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u800c\u57fa\u4e8enocatalog\u7684\u5907\u4efd\u7ba1\u7406\u65b9\u5f0f\uff0c\u662f\u5c06RMAN\u7684\u5907\u4efd\u4fe1\u606f\u653e\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\uff0c\u7531\u4e8e\u63a7\u5236\u6587\u4ef6\u7684\u5927\u5c0f\u4e0d\u80fd\u65e0\u9650\u589e\u5927\uff0c\u6240\u4ee5\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u53ea\u80fd\u4fdd\u7559\u4e00\u6bb5\u65f6\u95f4\u7684\u5907\u4efd\u4e0e\u6062\u590d\u4fe1\u606f\uff0c\u800c\u8fd9\u4e2a\u65f6\u95f4\u7684\u63a7\u5236\uff0c\u7531\u4e00\u4e2a\u53c2\u6570\u4e3a\u53c2\u8003\u4f9d\u636e\uff0c\u8fd9\u4e2a\u53c2\u6570\u5c31\u662fcontrol_file_record_keep_time\uff0c\u901a\u8fc7\u5728sqlplus\u4e2dshow parameter control_file_record_keep_time \u53ef\u4ee5\u67e5\u5230\u8fd9\u4e2a\u53c2\u6570\u7684\u503c\uff0c\u9ed8\u8ba4\u4e3a7\u5929\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tSQL&gt; show parameter control_file_record_keep_time\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tNAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TYPE&nbsp;&nbsp;&nbsp;&nbsp; VALUE\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8211; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tcontrol_file_record_keep_time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; integer&nbsp;&nbsp;&nbsp;&nbsp; 7\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tmetalink\u4e2d\u5bf9\u6b64\u53c2\u6570\u7684\u89e3\u91ca\u4e3a\uff1a\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tCONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tbefore a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tNote:\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tThis parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as datafile, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u8fd9\u6bb5\u8bdd\u7684\u610f\u601d\u662f\u8bf4\uff1acontrol_file_record_keep_time\u8868\u793a\u63a7\u5236\u6587\u4ef6\u91cc\u53ef\u91cd\u590d\u4f7f\u7528\u7684\u8bb0\u5f55\u6240\u80fd\u4fdd\u5b58\u7684\u6700\u5c0f\u5929\u6570\u3002\u5982\u679c\u65b0\u589e\u52a0\u4e00\u6761\u8bb0\u5f55 \u5230\u63a7\u5236\u6587\u4ef6\u53ef\u4ee5\u91cd\u590d\u4f7f\u7528\u7684\u90e8\u5206\uff0c\u8fd9\u65f6\u6700\u8001\u7684\u8bb0\u5f55\u5c1a\u6ca1\u6709\u8d85\u51fa\u6700\u5c0f\u4fdd\u7559\u5929\u6570\uff0c\u90a3\u4e48\u8bb0\u5f55\u5c06\u63a7\u5236\u6587\u4ef6\u7684\u8fd9\u4e00\u90e8\u5206\u5c06\u6269\u5c55\u3002\u5982\u679c\u5c06\u8be5\u53c2\u6570\u8bbe\u7f6e\u4e3a0\uff0c\u90a3\u4e48\u63a7\u5236\u6587\u4ef6\u53ef\u4ee5\u91cd \u590d\u4f7f\u7528\u7684\u90e8\u5206\u5c06\u6c38\u8fdc\u4e0d\u4f1a\u6269\u5c55\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u6ce8\u610f\uff0c\u8fd9\u4e2a\u53c2\u6570\u53ea\u5e94\u7528\u4e8e\u63a7\u5236\u6587\u4ef6\u4e2d\u53ef\u5faa\u73af\u5229\u7528\u7684\u90e8\u5206\uff0c\u5982\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\uff0c\u5404\u79cd\u5907\u4efd\u8bb0\u5f55\u3002\u4e0d\u5e94\u7528\u4e8e\u8bf8\u5982\u6570\u636e\u6587\u4ef6\uff0c\u8868\u7a7a\u95f4\uff0c\u91cd\u505a\u7ebf\u7a0b\u7b49\uff0c\u8fd9\u4e9b\u5185\u5bb9\u53ea\u6709\u5f53\u5176\u4ece\u5bf9\u5e94\u7684\u8868\u7a7a\u95f4\u4e2d\u5220\u9664\u540e\u624d\u80fd\u91cd\u7528\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u53ef\u91cd\u7528\u7684\u90e8\u5206\u5305\u62ec\u5982\u4e0b\u51e0\u79cd\u7c7b\u578b\uff08\u53ef\u4ee5\u901a\u8fc7\u67e5\u8be2\u89c6\u56fe$contofile_record_section\u5f97\u5230\uff09\uff1a\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tARCHIVED LOG\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tBACKUP CORRUPTION\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tBACKUP DATAFILE\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tBACKUP PIECE\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tBACKUP REDO LOG\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tBACKUP SET\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tCOPY CORRUPTION\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tDATAFILE COPY\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tDELETED OBJECT\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tLOGHISTORY\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tOFFLINERANGE\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u800cMAXLOGHISTORY\u53c2\u6570\uff0c\u5176\u610f\u4e49\u5728\u4e8e\u9650\u5236\u63a7\u5236\u6587\u4ef6\u91cc\u548c\u901a\u8fc7v$log_history\u89c6\u56fe\u7684\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u6570\u76ee\u3002\u5f52\u6863\u65e5\u5fd7\u6700\u591a\u7ef4\u6301\u5728MAXLOGHISTORY\u6240\u8bbe\u7f6e\u7684\u6570\u76ee\u3002\u5982\u679c\u8d85\u8fc7\u8fd9\u4e2a\u6570\u76ee\uff0c\u5c06\u4ece\u5934\u8986\u76d6\u4ee5\u524d\u7684\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u9879\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u6700\u7ec8\uff0c\u5f53\u5f52\u6863\u65e5\u5fd7\u6570\u76ee\u8d85\u8fc7MAXLOGHISTORY\u6240\u8bbe\u5b9a\u7684\u503c\u65f6\uff0cv$log_history\u4e2d\u7684\u6240\u6709\u9879\u90fd\u5c06\u88ab\u8986\u76d6\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u5f53\u521b\u5efa\u63a7\u5236\u6587\u4ef6\u65f6\uff0cMAXLOGHISTORY\u7684\u51b3\u5b9a\u4e3a\u5f52\u6863\u65e5\u5fd7\u4fe1\u606f\u5206\u914d\u591a\u5927\u7684\u7a7a\u95f4\u3002MAXLOGHISTORY\u5e76\u4e0d\u52a8\u6001\u589e\u52a0\u3002\u5f53\u65e5\u5fd7\u5f52\u6863\u65f6\uff0c\u8be5\u5f52\u6863\u6587\u4ef6\u7684\u4fe1\u606f\u5c06\u88ab\u66f4\u65b0\u5230\u63a7\u5236\u6587\u4ef6\u3002\u53ea\u6709\u5728\u5982\u4e0b\u60c5\u51b5\u4e0b\uff0c\u624d\u8986\u76d6\u539f\u6765\u7684\u9879\uff1a\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u63a7\u5236\u6587\u4ef6\u4e2d\u8be5\u533a\u57df\u6240\u6709\u9879\u90fd\u88ab\u4f7f\u7528\u5e76\u4e14\u6709\u4e00\u9879\u8d85\u51fa\u4e86control_file_record_keep_time\u8bbe\u5b9a\u7684\u65f6\u95f4\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u5f53\u4f7f\u7528RMAN\u76ee\u5f55\u65f6\uff0ccontrol_file_record_keep_time\u4fdd\u5b58\u7684\u65f6\u95f4\u4e0d\u80fd\u6bd4\u540c\u6b65\u76ee\u5f55\u7684\u65f6\u95f4\u95f4\u9694\u77ed\u3002\u6362\u53e5\u8bdd\u8bf4\uff0c\u5982\u679c\u6bcf\u5929\u5907\u4efd\u4e00\u6b21\uff0c\u90a3\u4e48controlfile_record_keep_time\u4e0d\u80fd\u5c11\u4e8e1\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u5982\u679c\u4e0d\u4f7f\u7528RMAN\u76ee\u5f55\uff0c\u5e94\u8be5\u8bbe\u7f6econtrol_file_record_keep_time\u4e3a\u4f60\u9700\u8981\u5f80\u540e\u6062\u590d\u7684\u6700\u5927\u5929\u6570\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u5728Oracle 7\u4e2d\uff0c\u5c06\u65b0\u5f52\u6863\u65e5\u5fd7\u8bb0\u5f55\u8bb0\u5f55\u5230v$log_histroy\u4e2d\u3002\u5f53\u8fbe\u5230MAXLOGHISTORY\u7684\u6781\u9650\u65f6\uff0c\u63d2\u5165\u65b0\u8bb0\u5f55\uff0c\u540c\u65f6\u8986\u76d6\u6700\u8001\u7684\u8bb0\u5f55\u3002\u57288.0\u7248\u672c \u540e\uff0cv$log_history\u89c6\u56fe\u88abv$archived_log\u53d6\u4ee3\u4e86\uff0c\u5e76\u4e14maxloghistory\u4e0d\u9650\u5236\u80fd\u591f\u63d2\u5165\u5230v$archived_log\u4e2d\u7684\u8bb0\u5f55\u6570\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u6709\u4eba\u95ee\uff1a\u4e3a\u4ec0\u4e48\u6211\u5728\u521b\u5efa\u63a7\u5236\u6587\u4ef6\u65f6\u6307\u5b9a\u7684MAXLOGHISTORY\u6ca1\u6709\u8d77\u4f5c\u7528\uff1f\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u4f8b\u5982\uff0c\u521b\u5efa\u63a7\u5236\u6587\u4ef6\u65f6\uff0c\u8bbe\u5b9aMAXLOGHISTORY\u53c2\u6570\u4e3a100\uff0c\u63a7\u5236\u6587\u4ef6\u7684\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tLog History\u533a\u57df\u5c06\u521b\u5efa227\u4e2a\u8bb0\u5f55\u3002\u8fd9\u662f\u4e00\u4e2a\u53ef\u9884\u6599\u5230\u7684\u7ed3\u679c\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t&nbsp;\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t\u521b\u5efa\u63a7\u5236\u6587\u4ef6\u65f6\uff0c\u6bcf\u4e2a\u90e8\u5206\u5206\u914d\u89c4\u5b9a\u7684\u5927\u5c0f\u548c\u7a7a\u95f4\u3002\u6bcf\u4e2a\u90e8\u5206\u7684\u7a7a\u95f4\u5206\u914d\u4e0d\u662f\u4f9d\u636e\u8bb0\u5f55\u6570\uff0c\u800c\u662f\u6839\u636eOracle\u7684\u5757\u3002\u63a7\u5236\u6587\u4ef6\u4e2d\uff0c\u6bcf\u4e2a\u90e8\u5206\u7684\u5355\u6761\u8bb0\u5f55\u5927\u5c0f\u662f\u56fa \u5b9a\u7684\uff0c\u90fd\u662f36\u5b57\u8282\u3002\u56e0\u6b64\uff0c100\u4e2a\u8bb0\u5f55\uff08MAXLOGHISTORY\uff09\u9700\u89813600\u4e2a\u5b57\u8282\u3002\u4f9d\u636eOracle\u7684\u5757\u5927\u5c0f&mdash;&mdash;&mdash;&mdash;\u63a7\u5236\u6587\u4ef6\u4e2d\u8bbe\u7f6e\u7684db_lock_size\uff0c\u63a7\u5236\u6587\u4ef6\u5757\u5927\u5c0f\u4e5f\u662fDB_BLOCK_SIZE\u53c2\u6570\u3002\u7279\u5b9a\u6570\u76ee\u7684\u5757\u5c06\u4e3aLog History\u90e8\u5206\u5206\u914d\u3002\u4f8b\u5982\uff0c\u5982\u679cDB_BLOCK_SIZE\u4e3a8192\uff0c\u90a3\u4e48\u4e00\u4e2a\u5757\u5c31\u8db3\u591f\u4e86\u3002\u5728\u8fd9\u4e2a\u5757\u4e2d\uff0c\u6211\u4eec\u67098192\/36\uff0c\u5927\u7ea6227\u4e2a\u8bb0\u5f55\u3002 \u5982\u679cDB_BLOCK_SIZE \u4e3a2048\uff0c\u90a3\u4e48\u5c06\u5206\u914d2\u4e2a\u5feb\uff0c\u4f46\u662f\u53ea\u521b\u5efa113\u4e2a\u8bb0\u5f55\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\tMAXLOGHISTORY\u7684\u6700\u5927\u503c\u53ef\u4ee5\u8bbe\u7f6e\u4e3a65535\u3002\u4e0d\u5f97\u8d85\u8fc7\u8fd9\u4e2a\u6570\u3002\n\t\t\t\t<\/p>\n<p>\n\t\t\t\t\t<!--EndFragment-->\n\t\t\t\t<\/p>\n<\/article>\n<p>\n\t\t\t\t1.\u65b0\u5efa\u76ee\u5f55<br \/>\n\t\t\t\tcd \/u01\/PTEST<br \/>\n\t\t\t\tmkdir rmanbackup<br \/>\n\t\t\t\tcd rmanbackup<br \/>\n\t\t\t\tmkdir data logs scripts<br \/>\n\t\t\t\tchown -hR oraptest:dba data logs scripts<br \/>\n\t\t\t\tchmod -R 777 data logs scripts<br \/>\n\t\t\t\t2.\u5c06\u6587\u4ef6\u653e\u8fdbscripts\u6587\u4ef6\u5939\n\t\t\t<\/p>\n<p>\n\t\t\t\t<br \/>\n\t\t\t\tCONFIGURE RETENTION POLICY TO REDUNDANCY 7;<br \/>\n\t\t\t\tCONFIGURE BACKUP OPTIMIZATION ON;<br \/>\n\t\t\t\tCONFIGURE CONTROLFILE AUTOBACKUP ON;<br \/>\n\t\t\t\tCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO &#39;\/u01\/PTEST\/rmanbackup\/data\/%F&#39;;<br \/>\n\t\t\t\tCONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO COMPRESSED BACKUPSET;<br \/>\n\t\t\t\tCONFIGURE CHANNEL DEVICE TYPE DISK MAXOPENFILES 50 MAXPIECESIZE 32G;\n\t\t\t<\/p>\n<p>\n\t\t\t\tnohup .\/db_0_bak.sh &amp;\n\t\t\t<\/p>\n<p>\n\t\t\t\t\u6570\u636e\u5e93\u7528\u6237\u53bb\u6267\u884c\uff1a<br \/>\n\t\t\t\tcrontab -e<br \/>\n\t\t\t\t#add for DEV rmanbackup<br \/>\n\t\t\t\t00 01 * * 0 \/u01\/DEV\/rmanbackup\/scripts\/db_0_bak.sh<br \/>\n\t\t\t\t00 01 * * 1-6 \/u01\/DEV\/rmanbackup\/scripts\/db_1_bak.sh\n\t\t\t<\/p>\n<p>\n\t\t\t\t\u6700\u540e\uff0c\u53ef\u4ee5\u5728var\/spool\/cron\u91cc\u9762\u770b\u5230\u7528\u6237\u7684\u81ea\u52a8\u6267\u884c\u547d\u4ee4\n\t\t\t<\/p>\n<p>\n\t\t\t\t\u6267\u884c\u4e00\u6761\u547d\u4ee4\uff1a\u628a\u6240\u6709\u7684\u6570\u636e\u90fd\u79fb\u52a8\u5230\u53e6\u5916\u6587\u4ef6\u5939\uff0c\u53ea\u5728rmanbackup\u91cc\u9762\u7559\u524d\u4e00\u5929\u7684\u6570\u636e\n\t\t\t<\/p>\n<p>\t\t<\/main><br \/>\n\t<\/article>\n<p><\/main><\/p>\n<p>\n\t<!--EndFragment-->\n<\/p>\n<p>\n\t<!--EndFragment--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>RMAN \u5907\u4efd\u4e0e\u6062\u590d\u7ecf\u5178\u5b9e\u4f8b-TaihangMeng-ITPUB\u535a\u5ba2 1. \u68c0\u67e5\u6570\u636e\u5e93\u6a21\u5f0f\uff1a &nbsp;&#038;n &hellip; <a href=\"https:\/\/www.llku.com\/?p=1277\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Oracle\u7ecf\u5178RMAN\u5907\u4efd\u7b56\u7565<\/span> <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":[],"categories":[1,68],"tags":[217],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1277"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1277"}],"version-history":[{"count":6,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1277\/revisions"}],"predecessor-version":[{"id":1292,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/1277\/revisions\/1292"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}