{"id":92,"date":"2026-02-05T16:44:40","date_gmt":"2026-02-05T08:44:40","guid":{"rendered":"https:\/\/yuriblog.online\/?p=92"},"modified":"2026-02-05T16:45:33","modified_gmt":"2026-02-05T08:45:33","slug":"rman%e5%bc%82%e6%9c%ba%e6%81%a2%e5%a4%8d","status":"publish","type":"post","link":"https:\/\/yuriblog.online\/index.php\/2026\/02\/05\/rman%e5%bc%82%e6%9c%ba%e6%81%a2%e5%a4%8d\/","title":{"rendered":"rman\u5f02\u673a\u6062\u590d"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"iIEa2\">\u672c\u6b21\u6062\u590d\u9047\u5230\u7684\u95ee\u9898\uff1a<\/h4>\n\n\n\n<p id=\"u5496d5cb\">1.\u5907\u4efd\u6570\u636e\u5e93\u65f6\u6ca1\u6709\u540c\u65f6\u5907\u4efd\u63a7\u5236\u6587\u4ef6\uff0c\u5bfc\u5165\u65f6\u4f7f\u7528\u6700\u65b0\u7684\u5907\u4efd\u6587\u4ef6\uff0c\u6709\u65f6\u95f4\u5dee<\/p>\n\n\n\n<p id=\"u5c82de55\">2.\u5f52\u6863\u7f3a\u5931\u4e00\u90e8\u5206<\/p>\n\n\n\n<p id=\"u0c4209db\">3.\u5728\u521d\u6b21\u6062\u590d\u5931\u8d25\u540e\u6ca1\u6709\u5f7b\u5e95\u6e05\u7406\u5e72\u51c0\u73af\u5883<\/p>\n\n\n\n<p id=\"ue17071c3\">4.recover\u5f52\u6863\u4e4b\u524d\u4e5f\u9700\u8981catlog\u5f52\u6863\u76ee\u5f55<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"cRwqW\">\u4f7f\u7528rman\u5907\u4efd\u6e90\u7aef\u6570\u636e\u5e93\u5e76\u628a\u5907\u4efd\u4f20\u5230\u76ee\u6807\u7aef<\/h4>\n\n\n\n<pre id=\"ovMsI\" class=\"wp-block-code\"><code>run {\nallocate channel c1 device type disk;\nallocate channel c2 device type disk;\nallocate channel c3 device type disk;\nallocate channel c4 device type disk;\nallocate channel c5 device type disk;\nallocate channel c6 device type disk;\nBACKUP AS COMPRESSED BACKUPSET  database include current controlfile format '\/backup\/rman1204\/data_%d_%T_%t_%s_%p';\nrelease channel c1;\nrelease channel c2;\nrelease channel c3;\nrelease channel c4;\nrelease channel c5;\nrelease channel c6;\n}<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764828346507-71f51df1-6221-4581-9721-3102e7210856.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p id=\"ub3b78409\">\u68c0\u67e5\u5907\u4efd\u4e0e\u63a7\u5236\u6587\u4ef6\u53ef\u7528\u6027<\/p>\n\n\n\n<pre id=\"pMfj0\" class=\"wp-block-code\"><code>CROSSCHECK BACKUPSET;\nlist backup of controlfile; \nLIST BACKUP SUMMARY;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764828493888-ac11dc34-a976-4cc2-abb3-e696fd4a2c61.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764828598881-b97e1ba3-a0b0-4a20-bc24-b2336ae8c1c2.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764829036214-1a4f1b97-faee-4863-a034-b284f3f4d02b.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"KiAtH\">\u6e90\u7aef\u521b\u5efa pfile<\/h4>\n\n\n\n<pre id=\"GMuF4\" class=\"wp-block-code\"><code>create pfile='\/home\/oracle\/exitpfile_1204.ora' from spfile;\nstrings pfile1204.ora<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"Vtyf7\">\u6e90\u7aef\u62f7\u8d1d\u5bc6\u7801\u6587\u4ef6<\/h4>\n\n\n\n<pre id=\"Wjx3E\" class=\"wp-block-code\"><code>cd $ORACLE_HOME\/dbs\nscp orapwcwtest1 oracle@10.20.81.18:\/u01\/app\/oracle\/product\/11.2.0\/db\/dbs<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764830225970-897e8f98-db90-4aba-a957-aff60e89fdb0.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"BvuuX\">\u76ee\u6807\u7aef\u521b\u5efa pfile \u53c2\u6570\u6587\u4ef6<\/h4>\n\n\n\n<p id=\"u4764ce01\">\u9700\u8981\u67e5\u770b\u6240\u6709\u7684\u8def\u5f84\u662f\u5426\u5b58\u5728\uff0c\u5982\u679c\u4e0d\u5b58\u5728\u9700\u8981\u521b\u5efa<\/p>\n\n\n\n<pre id=\"ZRpwM\" class=\"wp-block-code\"><code>ll \/u01\/app\/oracle\/admin\/cwtest1\/adump\nmkdir -p \/u01\/app\/oracle\/admin\/cwtest1\/adump\nll \/backup\/archivelog\nmkdir -p \/backup\/archivelog\nll \/u01\/app\/oracle\/oradata\/cwtest1\/\nmkdir -p \/u01\/app\/oracle\/oradata\/cwtest1\/\nll \/u01\/app\/oracle\/fast_recovery_area\/cwtest1\/\nmkdir -p \/u01\/app\/oracle\/fast_recovery_area\/cwtest1\/<\/code><\/pre>\n\n\n\n<pre id=\"BBEtd\" class=\"wp-block-code\"><code>cwtest1.__db_cache_size=26709327872\ncwtest1.__java_pool_size=268435456\ncwtest1.__large_pool_size=536870912\ncwtest1.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\ncwtest1.__pga_aggregate_target=4294967296\ncwtest1.__sga_target=36507222016\ncwtest1.__shared_io_pool_size=0\ncwtest1.__shared_pool_size=8589934592\ncwtest1.__streams_pool_size=0\n*._clusterwide_global_transactions=FALSE\n*._gc_policy_time=0\n*._gc_undo_affinity=FALSE\n*._optimizer_connect_by_cost_based=FALSE\n*._optimizer_extended_cursor_sharing='NONE'\n*._optimizer_extended_cursor_sharing_rel='NONE'\n*._optimizer_join_elimination_enabled=FALSE\n*._PX_use_large_pool=TRUE\n*._serial_direct_read='NEVER'\n*._use_adaptive_log_file_sync='FALSE'\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/cwtest1\/adump'\n*.audit_trail='NONE'\n*.compatible='11.2.0.4.0'\n*.control_files='\/u01\/app\/oracle\/oradata\/cwtest1\/control01.ctl','\/u01\/app\/oracle\/fast_recovery_area\/cwtest1\/control02.ctl'\n*.db_block_size=8192\n*.db_cache_size=18253611008\n*.db_domain=''\n*.db_files=1024\n*.db_name='cwtest1'\n*.db_recovery_file_dest_size=4385144832\n*.db_recovery_file_dest=''\n*.deferred_segment_creation=FALSE\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=cwtest1XDB)'\n*.enable_ddl_logging=FALSE\n*.large_pool_size=536870912\n*.log_archive_dest_1='LOCATION=\/backup\/archivelog\/'\n*.log_archive_dest_state_1='ENABLE'\n*.log_buffer=209715200\n*.open_cursors=3500\n*.parallel_force_local=TRUE\n*.pga_aggregate_target=4294967296\n*.processes=4500\n*.recyclebin='OFF'\n*.remote_login_passwordfile='EXCLUSIVE'\n*.session_cached_cursors=350\n*.sga_max_size=36507222016\n*.sga_target=36507222016\n*.shared_pool_size=8589934592\n*.undo_retention=86400\n*.undo_tablespace='UNDOTBS1'<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764830218029-84a25693-41bb-40b8-a0ae-6c36c72389cb.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"ecsPc\">\u5220\u9664\u5b9e\u4f8b<\/h4>\n\n\n\n<pre id=\"HxaPd\" class=\"wp-block-code\"><code>dbca -silent -deleteDatabase -sourceDB orcl<\/code><\/pre>\n\n\n\n<p id=\"u84058b98\">\u5982\u679c\u5220\u9664\u5b9e\u4f8b\u5931\u8d25\uff0c\u5219\u6e05\u7406\u6570\u636e\u6587\u4ef6\u3001\u5feb\u901f\u95ea\u56de\u533a\u3001\u5f52\u6863\u76ee\u5f55\u3001\u8fd8\u6709redo.log\u7684\u76ee\u5f55<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764830252697-b39512ee-2a93-4048-8da2-7da2c34f29e6.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p id=\"u2105bf72\">\u9700\u8981\u67e5\u8be2\u5bf9\u5e94\u76ee\u7684\u5e93 \u7684\u5b9e\u9645\u76ee\u5f55<\/p>\n\n\n\n<pre id=\"Lhs5N\" class=\"wp-block-code\"><code>rm -f \/u01\/app\/oracle\/admin\/cwtest1\/adump\/\nrm -f \/u01\/app\/oracle\/oradata\/cwtest1\/\nrm -f \/backup\/archivelog\nrm -f \/u01\/app\/oracle\/admin\/cwtest1\/adump\nrm -f \/oradata\/*.dbf<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"MK5mf\">\u76ee\u6807\u7aef\u4f7f\u7528\u65b0\u5efa\u7684 pfile \u53c2\u6570\u6587\u4ef6\u5f00\u542f\u5230 mount \u6a21\u5f0f\uff1a<\/h4>\n\n\n\n<pre id=\"y37Vr\" class=\"wp-block-code\"><code>create spfile from pfile='\/home\/oracle\/pfile_1204.ora';\nstartup nomount<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764830269416-b9359b98-e87b-486f-885b-5fd4dda0da14.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"TH9bx\">\u76ee\u6807\u7aef\u6062\u590d\u63a7\u5236\u6587\u4ef6<\/h4>\n\n\n\n<p id=\"u01ca20b0\">\u6e90\u7aef\u67e5\u8be2\u548c\u6570\u636e\u5e93\u4e00\u8d77\u5907\u4efd\u7684\u63a7\u5236\u6587\u4ef6\u540d\u79f0<\/p>\n\n\n\n<pre id=\"fEl8k\" class=\"wp-block-code\"><code> list backup of controlfile; \n \u67e5\u627e\u4e0e\u5907\u4efd\u65f6\u95f4\u4e00\u81f4\u7684\u63a7\u5236\u6587\u4ef6<\/code><\/pre>\n\n\n\n<pre id=\"NorRp\" class=\"wp-block-code\"><code>rman target \/\nrestore controlfile from '\/backup\/rman1204\/data_CWTEST1_20251204_1218962694_30_1';\nalter database mount;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764830331324-22736c3e-061e-41f4-9e3a-ae5841cfeb56.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"hgyEW\">\u76ee\u6807\u7aef\u6ce8\u518c\u5907\u4efd\u96c6<\/h4>\n\n\n\n<pre id=\"Di6NT\" class=\"wp-block-code\"><code>catalog start with '\/backup\/rman1204';<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"p6Hnh\">\u5f00\u59cb\u6062\u590d\u6570\u636e<\/h4>\n\n\n\n<pre id=\"sDj0f\" class=\"wp-block-code\"><code>nohup rman target \/ log=\/backup\/rman1204\/full_$(date +%F).log &lt;&lt;EOF &amp;\nrun {\nallocate channel c1 device type disk;\nallocate channel c2 device type disk;\nallocate channel c3 device type disk;\nallocate channel c4 device type disk;\nrestore database;\nrecover database;\n}\nEOF<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764830447730-22bceae6-a558-4688-b869-3a092599cb95.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p id=\"u0696f65e\">\u5982\u679c\u9047\u5230\u4ee5\u4e0b\u4e0b\u62a5\u9519\u53ef\u4ee5\u7ee7\u7eed\u8fdb\u884c\u540e\u7eed\u6b65\u9aa4<\/p>\n\n\n\n<pre id=\"Umk1I\" class=\"wp-block-code\"><code>RMAN-00571\nRMAN-00569\nRMAN-00571\nRMAN-03002\nRMAN-06054:media recovery requesting unkonw archived log for thread 1 with sequence 20 andstarting scn of 17169684877399;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"f1O1W\">rename \u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\u548c\u4e34\u65f6\u6587\u4ef6\u540d\u79f0<\/h4>\n\n\n\n<pre id=\"VUs1C\" class=\"wp-block-code\"><code>set line222\nset pagesize1000\nselect 'alter database rename file '''|| member || ''' to ''' || member || ''';' from v$logfile\nunion all\nselect 'alter database rename file '''|| name || ''' to ''' || name || ''';' from v$tempfile;\n\n\n\u786e\u8ba4\u6587\u4ef6\nset line222\nset pagesize1000\nselect name from v$datafile\nunion all\nselect name from v$tempfile\nunion all\nselect member from v$logfile;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"k0Fo6\">\u5f00\u542f\u6570\u636e\u5e93<\/h4>\n\n\n\n<pre id=\"mPA3D\" class=\"wp-block-code\"><code>alter database open resetlogs;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764070613100-f3e0d4e8-78c9-4f9a-8d71-eb3857a77838.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p id=\"u0fbf51ae\">\u5982\u679c\u4e0a\u8ff0\u6267\u884c\u6253\u5f00\u76ee\u6807\u7aef\u6570\u636e\u5e93\u5230 resetlogs \u72b6\u6001\u6267\u884c\u62a5\u9519\uff0c\u8bf4\u660e\u9700\u8981\u624b\u52a8 recover \u5f52\u6863\u65e5\u5fd7\uff0c\u6e90\u7aef\u62f7\u8d1d\u6240\u9700\u5f52\u6863\u65e5\u5fd7\u81f3\u76ee\u6807\u7aef\uff0c\u5206\u4e3a\u4e24\u79cd\u60c5\u51b5\uff1a<\/p>\n\n\n\n<p id=\"u60718604\">\u5f52\u6863\u65e5\u5fd7\u5728\u6e90\u7aef\u5f52\u6863\u76ee\u5f55\u8fd8\u80fd\u627e\u5230<\/p>\n\n\n\n<p id=\"u9dc9fe82\">\u5f52\u6863\u65e5\u5fd7\u5df2\u7ecf\u88ab\u5907\u4efd\u540e\u5e76\u5728\u672c\u5730\u5220\u9664<\/p>\n\n\n\n<p id=\"u7c52f513\">\u6e90\u7aef\uff1a<\/p>\n\n\n\n<pre id=\"gGB01\" class=\"wp-block-code\"><code>cd \/backup\/archivelog\nscp * oracle@10.20.81.18:\/backup\/archivelog<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764832678977-bb51a47f-40fc-4d52-ae76-ad5410e249ea.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p id=\"u4d2f292d\">\u76ee\u6807\u7aef<\/p>\n\n\n\n<pre id=\"Sbykq\" class=\"wp-block-code\"><code>catalog start with '\/backup\/archivelog';\nrun {\nallocate channel c1 device type disk;\nallocate channel c2 device type disk;\nallocate channel c3 device type disk;\nrecover database;\n}\n\nalter database open resetlogs;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764832532674-90a22397-874d-4775-87a5-3360208974db.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"tRNeS\">\u67e5\u8be2\u8868\u7a7a\u95f4\u4f7f\u7528\u7387<\/h4>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764838014070-785ea70e-52c9-4268-a94e-c5fc58ac034d.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"HS7DL\">\u67e5\u8be2\u6570\u636e\u5e93\u72b6\u6001<\/h4>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764838035007-b4a6ba6e-eefe-4dae-aaf6-03c8e9744b31.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p id=\"u69cfd30c\">\u76d1\u542c\u6b63\u5e38<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/cdn.nlark.com\/yuque\/0\/2025\/png\/59814236\/1764838057697-40bcfa20-371b-42d6-82b0-fba67636db3d.png\" alt=\"\" title=\"\"\/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6b21\u6062\u590d\u9047\u5230\u7684\u95ee\u9898\uff1a 1.\u5907\u4efd\u6570\u636e\u5e93\u65f6\u6ca1\u6709\u540c\u65f6\u5907\u4efd\u63a7\u5236\u6587\u4ef6\uff0c\u5bfc\u5165\u65f6\u4f7f\u7528\u6700\u65b0\u7684\u5907\u4efd\u6587\u4ef6\uff0c\u6709\u65f6\u95f4\u5dee 2.\u5f52\u6863\u7f3a\u5931\u4e00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-92","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/posts\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":2,"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/posts\/92\/revisions"}],"predecessor-version":[{"id":95,"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/posts\/92\/revisions\/95"}],"wp:attachment":[{"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/media?parent=92"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/categories?post=92"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yuriblog.online\/index.php\/wp-json\/wp\/v2\/tags?post=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}