{"id":1068,"date":"2015-11-06T14:05:40","date_gmt":"2015-11-06T06:05:40","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1068"},"modified":"2015-11-06T14:14:29","modified_gmt":"2015-11-06T06:14:29","slug":"dataguard%e4%b8%bb%e4%bb%8e%e4%b8%8d%e5%90%8c%e6%ad%a5%e6%a1%88%e4%be%8b%e5%a4%84%e7%90%86ora-01274","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1068","title":{"rendered":"DataGuard\u4e3b\u4ece\u4e0d\u540c\u6b65\u6848\u4f8b\u5904\u7406(ORA-01274)"},"content":{"rendered":"<p>\u95ee\u9898\u63cf\u8ff0:<br \/>\n1.Oracle11.2.0.3 DataGuard\u73af\u5883,\u4e3b\u5e93\u5728\u505a\u8868\u7a7a\u95f4\u6269\u5bb9\u65f6\u6dfb\u52a0\u4e86\u5f88\u591a\u6570\u636e\u6587\u4ef6,\u4f46\u662f\u5907\u673a\u7a7a\u95f4\u4e0d\u8db3,\u5bfc\u81f4\u6587\u4ef6\u521b\u5efa\u5931\u8d25,\u8fdb\u800c\u65e0\u6cd5\u6b63\u5e38\u540c\u6b65;<br \/>\n2.\u5728\u5907\u5e93\u7684alert\u6587\u4ef6\u4e2d\u62a5ORA-01274\u7684\u9519\u8bef,\u63d0\u793a\u521b\u5efa\u5931\u8d25\u7684\u6587\u4ef6\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u88ab\u91cd\u547d\u540d\u4e3a$ORACLE_HOME\/dbs\/UNNAMED0048,\u800c\u4e14MRP\u8fdb\u7a0b\u4e2d\u6b62;<\/p>\n<p><a href=\"http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/1358F88A-E519-4A0C-9CD4-9B109BE8CB4D.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/1358F88A-E519-4A0C-9CD4-9B109BE8CB4D-300x119.png\" alt=\"1358F88A-E519-4A0C-9CD4-9B109BE8CB4D\" width=\"300\" height=\"119\" class=\"alignnone size-medium wp-image-1069\" srcset=\"http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/1358F88A-E519-4A0C-9CD4-9B109BE8CB4D-300x119.png 300w, http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/1358F88A-E519-4A0C-9CD4-9B109BE8CB4D-1024x407.png 1024w, http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/1358F88A-E519-4A0C-9CD4-9B109BE8CB4D.png 1966w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/05F609D1-1955-449E-BF42-CE5A7639D32F.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/05F609D1-1955-449E-BF42-CE5A7639D32F-300x129.png\" alt=\"05F609D1-1955-449E-BF42-CE5A7639D32F\" width=\"300\" height=\"129\" class=\"alignnone size-medium wp-image-1070\" srcset=\"http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/05F609D1-1955-449E-BF42-CE5A7639D32F-300x129.png 300w, http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/05F609D1-1955-449E-BF42-CE5A7639D32F-1024x440.png 1024w, http:\/\/www.royalwzy.com\/wp-content\/uploads\/2015\/11\/05F609D1-1955-449E-BF42-CE5A7639D32F.png 1986w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u5904\u7406\u6b65\u9aa4:<br \/>\n1.\u4fee\u6539\u5907\u673a\u7ba1\u7406\u6a21\u5f0f\u4e3a\u624b\u52a8:ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT = MANUAL;<br \/>\n2.\u521b\u5efa\u4e22\u5931\u6587\u4ef6:ALTER DATABASE CREATE DATAFILE &#8216;\/oracle\/product\/11.2.0\/db_1\/dbs\/UNNAMED00048&#8217; AS &#8216;\/oradata\/htcwdb\/NNC_DATA0306.dbf&#8217;;<br \/>\n3.\u4fee\u6539\u5907\u673a\u7ba1\u7406\u6a21\u5f0f\u4e3a\u81ea\u52a8:ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT = AUTO;<br \/>\n4.\u6062\u590d\u65e5\u5fd7[\u5e76\u4ece\u4e3b\u673a\u63a5\u6536\u65e5\u5fd7]:RECOVER STANDBY DATABASE [DISCONNECT FROM SESSION];\u6216\u8005<br \/>\n5.\u63a5\u53d7\u65e5\u5fd7\u5e76\u5b9e\u65f6\u5e94\u7528:ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u95ee\u9898\u63cf\u8ff0: 1.Oracle11.2.0.3 DataGuard\u73af\u5883,\u4e3b\u5e93\u5728\u505a\u8868\u7a7a\u95f4\u6269\u5bb9\u65f6\u6dfb\u52a0\u4e86\u5f88\u591a\u6570\u636e\u6587\u4ef6, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34],"class_list":["post-1068","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1068"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1068\/revisions"}],"predecessor-version":[{"id":1071,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1068\/revisions\/1071"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1068"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}