{"id":1761,"date":"2011-03-02T23:26:18","date_gmt":"2011-03-03T03:26:18","guid":{"rendered":"http:\/\/www.killtest.hk\/?p=1761"},"modified":"2011-03-02T23:26:54","modified_gmt":"2011-03-03T03:26:54","slug":"standby","status":"publish","type":"post","link":"https:\/\/www.killtest.hk\/index.php\/unix\/standby\/","title":{"rendered":"\u7269\u7406standby failover"},"content":{"rendered":"<p>\u64cd\u4f5c\u7cfb\u7d71\uff1ared hat enterprise 5<br \/>\n\u00a0\u00a0\u00a0 ORACLE:\u00a0 11.2.0.1.0<br \/>\n\u00a0\u00a0\u00a0 ORACLE-DataGuard\u7cfb\u5217\u6587\u6a94\u521d\u59cb\u6e2c\u8a66\u74b0\u5883\uff08\u55ae\u5be6\u4f8b\u7269\u7406standby\uff09\uff1a<br \/>\n\u00a0\u00a0\u00a0 <a href=\"http:\/\/xin23.blog.51cto.com\/1827266\/504066\">http:\/\/xin23.blog.51cto.com\/1827266\/504066<\/a><br \/>\n\u00a0\u00a0\u00a0 \u6bcf\u6b21\u5be6\u9a57\u74b0\u5883\u5747\u57fa\u65bc\u4e0a\u6b21\u5be6\u9a57\u6539\u8b8a\u4e4b\u5f8c\u3002\u5982\u6709\u9700\u8981\u3002\u53ef\u6309\u6642\u9593\u5148\u5f8c\u9806\u5e8f\u67e5\u770b\u3002<br \/>\n\u00a0\u00a0\u00a0 1.\u6aa2\u67e5\u6b78\u6a94\u6587\u4ef6\u662f\u5426\u9023\u7e8c<br \/>\n\u00a0\u00a0\u00a0 SQL&gt; select * from v$archive_gap;<br \/>\n\u00a0\u00a0\u00a0 no rows selected<br \/>\n\u00a0\u00a0\u00a0 \u5982\u679c\u6709\u8fd4\u56de\u8a18\u9304\u3002\u5fa9\u5236\u76f8\u61c9\u6b78\u6a94\u6587\u4ef6\u5230\u5f85\u8f49\u63db\u7684standby\u670d\u52d9\u5668\u3002<br \/>\n\u00a0\u00a0\u00a0 \u4e26\u901a\u904ealter database register physical logfile &#8216;arcfile&#8217; \u547d\u4ee4\u5c07\u5176\u52a0\u5165\u6578\u64da\u5b57\u5178<br \/>\n\u00a0\u00a0\u00a0 2.\u6aa2\u67e5\u6b78\u6a94\u6587\u4ef6\u662f\u5426\u5b8c\u6574<br \/>\n\u00a0\u00a0\u00a0 primary&gt; select distinct thread#,max\uff08sequence#\uff09 over\uff08partition by thread#\uff09 max from v$archived_log;<br \/>\n\u00a0\u00a0\u00a0 THREAD#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MAX<br \/>\n\u00a0\u00a0\u00a0 &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 78<br \/>\n\u00a0\u00a0\u00a0 standby&gt; select distinct thread#,max\uff08sequence#\uff09 over\uff08partition by thread#\uff09 max from v$archived_log;<br \/>\n\u00a0\u00a0\u00a0 THREAD#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MAX<br \/>\n\u00a0\u00a0\u00a0 &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 77<br \/>\n\u00a0\u00a0\u00a0 \u5982\u679c\u6700\u5927\u5e8f\u865f\u4e0d\u540c\u3002\u5247\u9700\u8981\u5c07\u5c0d\u61c9\u6b78\u6a94\u6587\u4ef6\u5fa9\u5236\u5230\u5f85\u8f49\u63db\u7684standby\u670d\u52d9\u5668\u3002<br \/>\n\u00a0\u00a0\u00a0 \u7531\u65bc\u662f\u6e2c\u8a66\u3002\u6211\u76f4\u63a5\u901a\u904eprimary\u767c\u9001\u6b78\u6a94\u6587\u4ef6\u5f8c\u91cd\u65b0\u6aa2\u67e5<br \/>\n\u00a0\u00a0\u00a0 standby&gt; select distinct thread#,max\uff08sequence#\uff09 over\uff08partition by thread#\uff09 max from v$archived_log;<br \/>\n\u00a0\u00a0\u00a0 THREAD#\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MAX<br \/>\n\u00a0\u00a0\u00a0 &#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;-<br \/>\n\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 78<br \/>\n\u00a0\u00a0\u00a0 \u9019\u5c31OK\u4e86\u3002<br \/>\n\u00a0\u00a0\u00a0 3.\u555f\u52d5failover<br \/>\n\u00a0\u00a0\u00a0 standby&gt; alter database recover managed standby database finish force;<br \/>\n\u00a0\u00a0\u00a0 Database altered.<br \/>\n\u00a0\u00a0\u00a0 4.\u5207\u63db\u7269\u7406standby\u89d2\u8272\u70baprimary<br \/>\n\u00a0\u00a0\u00a0 standby&gt; alter database commit to switchover to primary;<br \/>\n\u00a0\u00a0\u00a0 Database altered.<br \/>\n\u00a0\u00a0\u00a0 5.\u555f\u52d5\u65b0\u7684primary\u6578\u64da\u5eab<br \/>\n\u00a0\u00a0\u00a0 standby&gt; alter database open;<br \/>\n\u00a0\u00a0\u00a0 Database altered.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u64cd\u4f5c\u7cfb\u7d71\uff1ared hat enterprise 5 \u00a0\u00a0\u00a0 ORACLE:\u00a0 11.2.0.1.0 \u00a0\u00a0\u00a0 O [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[531],"tags":[733,732],"class_list":["post-1761","post","type-post","status-publish","format-standard","hentry","category-unix","tag-failover","tag-standby"],"_links":{"self":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/comments?post=1761"}],"version-history":[{"count":0,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/posts\/1761\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/media?parent=1761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/categories?post=1761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.hk\/index.php\/wp-json\/wp\/v2\/tags?post=1761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}