\u58f9\uff09\u7528\u6236\u8868\u7a7a\u9593
\n\u932f\u8aa4: \u5728\u555f\u52d5\u6578\u64da\u5eab\u6642\u51fa\u73feORA-01157,ORA-01110\u6216\u64cd\u4f5c\u7cfb\u7d71\u7d1a\u932f\u8aa4\u4f8b\u5982ORA-07360, \u5728\u95dc\u9589\u6578\u64da\u5eab(\u4f7f\u7528shutdown normal\u6216shutdown immediate) \u6642\u5c07\u5c0e\u81f4\u932f\u8aa4ORA -01116,ORA-01110\u4ee5\u53ca\u64cd\u4f5c\u7cfb\u7d71\u7d1a\u932f\u8aa4ORA-07368
\n\u89e3\u6c7a: \u4ee5\u4e0b\u6709\u5169\u7a2e\u89e3\u6c7a\u65b9\u6848:
\n1.\u7528\u6236\u7684\u8868\u7a7a\u9593\u53ef\u4ee5\u88ab\u8f15\u6613\u5730\u91cd\u5efa
\n\u5373\u6700\u8fd1\u5c0e\u51fa\u7684\u5c0d\u8c61\u662f\u53ef\u7528\u7684\u6216\u8868\u7a7a\u9593\u4e2d\u7684\u5c0d\u8c61\u53ef\u4ee5\u88ab\u8f15\u6613\u5730\u91cd\u5efa\u7b49.
\n\u5728\u9019\u7a2e\u60c5\u6cc1\u4e0b,\u6700\u7c21\u55ae\u7684\u65b9\u6cd5\u662foffline\u4e26\u522a\u9664\u8a72\u6578\u64da\u6587\u4ef6,\u522a\u9664\u8868\u7a7a\u9593\u4e26\u91cd\u5efa\u8868\u7a7a\u9593\u4ee5\u53ca\u6240\u6709\u7684\u5c0d\u8c61.
\nsql> startup mount
\nsql> alter database datafile filename offline drop;
\nsql> alter database open;
\nsql> drop tablespace tablespace_name including contents;
\n\u91cd\u5efa\u8868\u7a7a\u9593\u53ca\u6240\u6709\u5c0d\u8c61.
\n\u3000\u3000
\n2.\u7528\u6236\u7684\u8868\u7a7a\u9593\u4e0d\u80fd\u5920\u88ab\u8f15\u6613\u5730\u91cd\u5efa
\n\u5728\u5927\u591a\u6578\u60c5\u6cc1\u4e0b,\u91cd\u5efa\u8868\u7a7a\u9593\u662f\u4e0d\u53ef\u80fd\u53ca\u592a\u8f9b\u82e6\u7684\u5de5\u4f5c.\u65b9\u6cd5\u662f\u5012\u5099\u4efd\u53ca\u505a\u4ecb\u6062\u5fa9.
\n\u5982\u679c\u60a8\u7684\u7cfb\u7d71\u904b\u884c\u5728NOARCHIVELOG\u6a21\u5f0f\u4e0b,\u5247\u53ea\u6709\u4e1f\u5931\u7684\u6578\u64da \u5728online redo log\u4e2d\u65b9\u53ef\u88ab\u6062\u5fa9\u3002\u6b65\u9a5f\u5982\u4e0b:
\n1)Restore the lost datafile from a backup
\n2)sql> startup mount
\n3)sql> select v1.group#,member,sequence#,first_change# > from v$log v1,v$logfile v2 > where v1.group#=v2.group#;
\n4)\u5982\u679c\u6578\u64da\u5eab\u904b\u884c\u5728NOARCHIVELOG\u6a21\u5f0f\u4e0b\u5247:
\nsql> select file#,change# from v$recover_file;
\n\u5982\u679c CHANGE# \u5927\u65bc\u6700\u5c0f\u7684FIRST_CHANGE#\u5247\u6578\u64da\u6587\u4ef6\u53ef\u4ee5\u88ab\u6062\u5fa9\u3002
\n\u5982\u679c CHANGE# \u5c0f\u65bc\u6700\u5c0f\u7684FIRST_CHANGE#\u5247\u6578\u64da\u6587\u4ef6\u4e0d\u53ef\u6062\u5fa9\u3002
\n\u6062\u5fa9\u6700\u8fd1\u58f9\u6b21\u7684\u5168\u5099\u4efd\u6216\u91c7\u7528\u65b9\u6848\u58f9.
\n5)sql> recover datafile filename;
\n6)\u78ba\u8a8d\u6062\u5fa9\u6210\u529f
\n7)sql> alter database open resetlogs;
\n\u3000\u3000
\n3.\u53ea\u8b80\u8868\u7a7a\u9593\u7121\u9700\u505a\u4ecb\u8cea\u6062\u5fa9,\u53ea\u8981\u5c07\u5099\u4efd\u6062\u5fa9\u5373\u53ef.\u552f\u58f9\u7684\u4f8b\u5916\u662f: \u8868\u7a7a\u9593\u5728\u6700\u5f8c\u58f9\u6b21\u5099\u4efd\u5f8c\u88ab\u6539\u70baread-write \u6a21\u5f0f \u8868\u7a7a\u9593\u5728\u6700\u5f8c\u58f9\u6b21\u5099\u4efd\u5f8c\u88ab\u6539\u70baread-only \u6a21\u5f0f \u5728\u9019\u7a2e\u60c5\u6cc1\u4e0b,\u5747\u9700\u9032\u884c\u4ecb\u8cea\u6062\u5fa9
\n\u3000\u3000\u3000\u3000
\n\u4e8c\uff09\u81e8\u6642\u8868\u7a7a\u9593
\n\u81e8\u6642\u8868\u7a7a\u9593\u4e26\u4e0d\u5305\u542b\u771f\u6b63\u7684\u6578\u64da,\u6062\u5fa9\u7684\u65b9\u6cd5\u662f\u522a\u9664\u81e8\u6642\u8868\u7a7a\u9593\u4e26\u91cd\u5efa\u5373\u53ef.
\n\u3000\u3000\u3000\u3000
\n\u4e09\uff09\u7cfb\u7d71\u8868\u7a7a\u9593
\n\u5982\u679c\u5099\u4efd\u4e0d\u53ef\u7528,\u5247\u53ea\u80fd\u91c7\u7528\u91cd\u5efa\u6578\u64da\u5eab\u7684\u65b9\u6cd5
\n\u3000\u3000
\n\u56db\uff09\u56de\u6efe\u8868\u7a7a\u9593 \u6709\u5169\u7a2e\u60c5\u6cc1:
\n1\u3001\u6578\u64da\u5eab\u5df2\u7d93\u5b8c\u5168\u95dc\u9589(\u4f7f\u7528shutdown immediate\u6216shutdown\u547d\u4ee4)
\n1) \u78ba\u8a8d\u6578\u64da\u5eab\u5b8c\u5168\u95dc\u9589
\n2) \u4fee\u6539init.ora\u6587\u4ef6,\u8a3b\u91cb”rollback-segment”
\n3) sql> startup restrict mount
\n4) sql> alter database datafile filename offline drop;
\n5) sql> alter database open; \u57fa\u65bc\u51fa\u73fe\u7684\u7d50\u679c: “statement processed” \u8f49(7) “ORA-00604,ORA-00376,ORA-01110″\u8f49(6)
\n6) sql> shutdown immediate \u4fee\u6539init.ora\u6587\u4ef6,\u589e\u52a0\u5982\u4e0b\u58f9\u884c: _corrupted_rollback_segments = (,…) sql> startup restrict
\n7) sql> drop tablespace tablespace_name including contents;
\n8)\u00a0 \u91cd\u5efa\u8868\u7a7a\u9593\u53ca\u56de\u6efe\u6bb5
\n9) sql> alter system disable restricted session;
\n10) \u4fee\u6539init.ora\u6587\u4ef6
\n\u3000\u3000
\n2\u3001\u6578\u64da\u5eab\u672a\u5b8c\u5168\u95dc\u9589(\u6578\u64da\u5eab\u5d29\u6f70\u6216\u4f7f\u7528shutdown abort\u547d\u4ee4\u95dc\u9589\u6578\u64da\u5eab)
\n1) \u6062\u5fa9\u5099\u4efd
\n2) sql> startup mount
\n3) sql> select file#,name,status from v$datafile; sql> alter database datafile filename online;
\n4) sql> select v1.group#,member,sequence#,first_change# > from v$log v1,v$logfile v2 > where v1.group#=v2.group#;
\n5) sql> select file#,change# from v$recover_file; \u898b\u58f9\u65b9\u68482-4
\n6) sql> recover datafile filename;
\n7) sql> alter database open;
\n\u3000\u3000
\n3\u3001\u6578\u64da\u5eab\u8655\u65bc\u6253\u958b\u72c0\u614b
\n1) \u522a\u9664\u56de\u6efe\u6bb5\u548c\u8868\u7a7a\u9593
\n2) \u91cd\u5efa\u8868\u7a7a\u9593\u548c\u56de\u6efe\u6bb5
\n\u3000\u3000
\n\u4e94\uff09\u63a7\u5236\u6587\u4ef6\u6062\u5fa9
\n1\uff0e\u6240\u6709\u7684\u63a7\u5236\u6587\u4ef6\u5747\u88ab\u7834\u58de \u5c07\u5099\u4efd\u7684\u63a7\u5236\u6587\u4ef6\u62f7\u8c9d\u81f3\u539f\u76ee\u9304\u4e0b \u5c0d\u65bcRAW DEVICE,\u5247: dd if=’con.bak’ of=’\/dev\/rdrd\/drd1′ seek=128
\n2\uff0e\u4e26\u975e\u6240\u6709\u7684\u63a7\u5236\u6587\u4ef6\u5747\u88ab\u7834\u58de \u7528\u5176\u4ed6\u7684\u63a7\u5236\u6587\u4ef6\u555f\u52d5\u6578\u64da\u5eab<\/p>\n","protected":false},"excerpt":{"rendered":"
\u58f9\uff09\u7528\u6236\u8868\u7a7a\u9593 \u932f\u8aa4: \u5728\u555f\u52d5\u6578\u64da\u5eab\u6642\u51fa\u73feORA-01157,ORA-01110\u6216\u64cd\u4f5c\u7cfb\u7d71\u7d1a\u932f\u8aa4\u4f8b\u5982ORA-07360, \u5728\u95dc\u9589\u6578\u64da\u5eab(\u4f7f\u7528shutdown normal\u6216shutdown immediate) \u6642\u5c07\u5c0e\u81f4\u932f\u8aa4ORA -01116,ORA-01110\u4ee5\u53ca\u64cd\u4f5c\u7cfb\u7d71\u7d1a\u932f\u8aa4ORA-07368 \u89e3\u6c7a: \u4ee5\u4e0b\u6709\u5169\u7a2e\u89e3\u6c7a\u65b9\u6848: 1.\u7528\u6236\u7684\u8868\u7a7a\u9593\u53ef\u4ee5\u88ab\u8f15\u6613\u5730\u91cd\u5efa \u5373\u6700\u8fd1\u5c0e\u51fa\u7684\u5c0d\u8c61\u662f\u53ef\u7528\u7684\u6216\u8868\u7a7a\u9593\u4e2d\u7684\u5c0d\u8c61\u53ef\u4ee5\u88ab\u8f15\u6613\u5730\u91cd\u5efa\u7b49. \u5728\u9019\u7a2e\u60c5\u6cc1\u4e0b,\u6700\u7c21\u55ae\u7684\u65b9\u6cd5\u662foffline\u4e26\u522a\u9664\u8a72\u6578\u64da\u6587\u4ef6,\u522a\u9664\u8868\u7a7a\u9593\u4e26\u91cd\u5efa\u8868\u7a7a\u9593\u4ee5\u53ca\u6240\u6709\u7684\u5c0d\u8c61. sql> startup mount sql> alter database datafile filename offline drop; sql> alter database open; sql> drop tablespace tablespace_name including contents; \u91cd\u5efa\u8868\u7a7a\u9593\u53ca\u6240\u6709\u5c0d\u8c61. \u3000\u3000 2.\u7528\u6236\u7684\u8868\u7a7a\u9593\u4e0d\u80fd\u5920\u88ab\u8f15\u6613\u5730\u91cd\u5efa \u5728\u5927\u591a\u6578\u60c5\u6cc1\u4e0b,\u91cd\u5efa\u8868\u7a7a\u9593\u662f\u4e0d\u53ef\u80fd\u53ca\u592a\u8f9b\u82e6\u7684\u5de5\u4f5c.\u65b9\u6cd5\u662f\u5012\u5099\u4efd\u53ca\u505a\u4ecb\u6062\u5fa9. \u5982\u679c\u60a8\u7684\u7cfb\u7d71\u904b\u884c\u5728NOARCHIVELOG\u6a21\u5f0f\u4e0b,\u5247\u53ea\u6709\u4e1f\u5931\u7684\u6578\u64da \u5728online redo log\u4e2d\u65b9\u53ef\u88ab\u6062\u5fa9\u3002\u6b65\u9a5f\u5982\u4e0b: 1)Restore the lost datafile from a backup 2)sql> startup mount 3)sql> select v1.group#,member,sequence#,first_change# > […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[387,3163],"class_list":["post-1214","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-1z0-047","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/1214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1214"}],"version-history":[{"count":4,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/1214\/revisions"}],"predecessor-version":[{"id":1217,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/1214\/revisions\/1217"}],"wp:attachment":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}