{"id":458,"date":"2010-05-21T17:02:07","date_gmt":"2010-05-21T14:02:07","guid":{"rendered":"http:\/\/blog.yavor.info\/?p=458"},"modified":"2011-11-02T23:21:17","modified_gmt":"2011-11-02T20:21:17","slug":"dg-switchover-%d0%bc%d0%be%d1%82%d0%b8%d1%87%d0%ba%d0%b0","status":"publish","type":"post","link":"http:\/\/blog.yavor.info\/?p=458","title":{"rendered":"DG Switchover \u043c\u043e\u0442\u0438\u0447\u043a\u0430"},"content":{"rendered":"<p>\u041d\u0430\u043f\u043e\u0441\u043b\u0435\u0434\u044a\u043a \u0441\u044a\u043c \u0432\u043b\u044e\u0431\u0435\u043d \u0432 DataGuard Broker. \u0421\u0442\u0440\u0430\u0448\u043d\u043e \u043f\u043e\u043b\u0435\u0437\u0435\u043d \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442! \u0415, \u0438\u043c\u0430 \u0441\u0438 \u0441\u0432\u043e\u0438\u0442\u0435 \u0441\u0442\u0440\u0430\u043d\u043d\u043e\u0441\u0442\u0438, \u0432\u0441\u0435 \u043f\u0430\u043a&#8230;<\/p>\n<p>\u0414\u043d\u0435\u0441 \u0442\u0435\u0441\u0442\u0432\u0430\u0445 switcover \u043f\u0440\u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043e\u0442 \u0435\u0434\u043d\u0430 primary, \u0435\u0434\u0438\u043d physical \u0438 \u0435\u0434\u0438\u043d logical standby. \u041f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u043d\u043e \u0441\u0435 \u043f\u043e\u0434\u0433\u043e\u0442\u0432\u0438\u0445 \u0441 research \u043d\u0430 \u0432\u044a\u0437\u043c\u043e\u0436\u043d\u0438\u0442\u0435 \u0431\u044a\u0433\u043e\u0432\u0435 \u0438 \u0442\u0435\u0445\u043d\u0438\u0442\u0435 workarounds. \u0417\u0430 \u0449\u0430\u0441\u0442\u0438\u0435 \u0441\u043c\u0435 \u043d\u0430 \u0434\u043e\u0441\u0442\u0430 \u0441\u0442\u0430\u0431\u0438\u043b\u043d\u0430 \u0432\u0435\u0440\u0441\u0438\u044f. \u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0435\u0434\u043d\u0430 \u043e\u0442 \u0433\u0440\u043e\u0437\u043d\u0438\u0442\u0435 \u043c\u043e\u0442\u0438\u043a\u0438 \u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0430 \u0432 note 761661.1. \u0410\u0431\u0435 \u0443\u0431\u0438\u0445 \u0441\u0438 \u0435\u0434\u0438\u043d \u0434\u0435\u043d \u0440\u043e\u0432\u0435\u043d\u0435&#8230;<\/p>\n<p>\u0418 \u0432\u0441\u0435 \u043f\u0430\u043a \u043d\u0435 \u0431\u044f\u0445 \u0441\u044a\u0432\u0441\u0435\u043c \u0438\u0437\u0440\u044f\u0434\u0435\u043d. \u041a\u043e\u0433\u0430\u0442\u043e \u0441\u0435 \u0437\u0430\u0441\u0438\u043b\u0438\u0445 \u0434\u0430 \u043f\u0440\u0435\u0445\u0432\u044a\u0440\u043b\u044f\u043c, \u0441\u0435 \u0441\u043b\u0443\u0447\u0438 \u0441\u043b\u0435\u0434\u043d\u043e\u0442\u043e:<\/p>\n<blockquote><p>DGMGRL> connect \/<br \/>\nConnected.<br \/>\nDGMGRL> show configuration<\/p>\n<p>Configuration<br \/>\n  Name:                My_guard<br \/>\n  Enabled:             YES<br \/>\n  Protection Mode:     MaxPerformance<br \/>\n  Fast-Start Failover: DISABLED<br \/>\n  Databases:<br \/>\n    mydb_prim &#8211; Primary database<br \/>\n    mydb_lsby       &#8211; Logical standby database<br \/>\n    mydb_psby       &#8211; Physical standby database<\/p>\n<p>Current status for &#8222;My_guard&#8220;:<br \/>\nSUCCESS<\/p>\n<p>DGMGRL> switchover to mydb_psby<br \/>\nPerforming switchover NOW, please wait&#8230;<br \/>\nOperation requires shutdown of instance &#8222;mydb&#8220; on database &#8222;mydb_prim&#8220;<br \/>\nShutting down instance &#8222;mydb&#8220;&#8230;<br \/>\n<strong>ORA-01031: insufficient privileges<\/strong><\/p>\n<p>You are no longer connected to ORACLE<br \/>\nPlease connect again.<br \/>\nUnable to shut down instance &#8222;mydb&#8220;<br \/>\nYou must shut down instance &#8222;mydb&#8220; manually<br \/>\nOperation requires shutdown of instance &#8222;mydb&#8220; on database &#8222;mydb_psby&#8220;<br \/>\nYou must shut down instance &#8222;mydb&#8220; manually<br \/>\nOperation requires startup of instance &#8222;mydb&#8220; on database &#8222;mydb_prim&#8220;<br \/>\nYou must start instance &#8222;mydb&#8220; manually<br \/>\nOperation requires startup of instance &#8222;mydb&#8220; on database &#8222;mydb_psby&#8220;<br \/>\nYou must start instance &#8222;mydb&#8220; manually<br \/>\nSwitchover succeeded, new primary is &#8222;mydb_psby&#8220;<\/p><\/blockquote>\n<p>\u041f\u043e\u0441\u043b\u0435 \u043d\u0435\u0449\u0430\u0442\u0430 \u0441\u0430 \u043b\u0435\u0435\u0435\u043a\u043e \u043e\u043c\u0430\u0437\u0430\u043d\u0438, \u043d\u043e \u0441\u0435 \u043e\u043f\u0440\u0430\u0432\u044f\u0442 \u0441 \u0440\u0435\u0441\u0442\u0430\u0440\u0442 \u043d\u0430 <code>mydb_prim<\/code> (\u0434\u043e <code>MOUNT<\/code>) \u0438 \u043d\u0430 <code>mydb_psby<\/code>.<\/p>\n<p>\u0421\u0435\u0433\u0430, \u043d\u0435 \u0447\u0435 \u0435 \u0433\u043e\u043b\u044f\u043c\u0430 \u0434\u0440\u0430\u043c\u0430, \u0434\u0430\u0436\u0435 \u043c\u043e\u0436\u0435 \u0434\u0430 \u0441\u0435 \u043a\u0430\u0436\u0435, \u0447\u0435 \u0432\u0441\u0438\u0447\u043a\u043e \u0435 \u041e\u041a, \u043d\u0435\u0449\u0430\u0442\u0430 \u0441\u0435 \u043e\u043f\u0440\u0430\u0432\u044f\u0442 \u043b\u0435\u0441\u043d\u043e. \u0410\u043c\u0430 \u0432\u0441\u0435 \u043f\u0430\u043a \u043c\u0438 \u0441\u0442\u0430\u043d\u0430 \u0447\u0443\u0434\u043d\u043e \u043a\u0430\u043a\u0432\u043e \u043d\u0435 \u043c\u0443 \u0443\u0439\u0434\u0438\u0441\u0432\u0430. \u041d\u0430\u043b\u0438 \u0443\u0436 \u0432\u0441\u0438\u0447\u043a\u043e \u043f\u0440\u0430\u0432\u044f \u043a\u0430\u0442\u043e \u043f\u043e \u043a\u043d\u0438\u0433\u0438\u0442\u0435. \u041f\u044a\u043a \u0438, \u0434\u0430 \u0441\u0438 \u043a\u0430\u0436\u0430 \u0447\u0435\u0441\u0442\u043d\u043e, \u043d\u0435 \u043c\u043e\u0436\u0430\u0445 \u0434\u0430 \u043e\u0442\u043a\u0440\u0438\u044f \u043f\u0430\u0440\u0438\u0447\u043d\u0430\u0442\u0430 \u0437\u0430 \u0442\u043e\u0432\u0430 \u0433\u044a\u0440\u043c\u0435\u0436\u0447\u0435 \u0432 <del datetime=\"2010-05-21T13:14:47+00:00\">Metalink<\/del> My Oracle Support. \u041c\u043e\u0436\u0435 \u0431\u0438 \u0437\u0430\u0449\u043e\u0442\u043e \u0441\u0430\u043c\u043e \u0441\u0435 \u0447\u0443\u0434\u044f\u0442 \u043a\u0430\u043a\u0432\u0438 \u0431\u043e\u0437\u0438 \u0434\u0430 \u043f\u0440\u0430\u0432\u044f\u0442 \u043f\u043e \u0432\u0438\u0437\u0438\u044f\u0442\u0430, \u0430 \u0442\u0430\u043a\u0430 \u0438 \u043d\u0435 \u043c\u0443 \u043e\u043f\u0440\u0430\u0432\u0438\u0445\u0430 search-\u0430. <\/p>\n<p>\u0418 \u0432\u0441\u0435 \u043f\u0430\u043a, \u0434\u0430 \u0435 \u0436\u0438\u0432 \u0438 \u0437\u0434\u0440\u0430\u0432 \u0447\u0438\u0447\u043a\u043e \u0433\u0443\u0433\u044a\u043b, \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u0441\u0435 \u043d\u0430\u043c\u0435\u0440\u0438 <a href=\"http:\/\/www.izzysoft.de\/oracle\/ifaqmaker.php?id=7;toc=1#01031\">\u0442\u0443\u043a<\/a>. \u041e\u043a\u0430\u0437\u0432\u0430 \u0441\u0435, \u0447\u0435 \u0437\u0430 \u0432\u0440\u044a\u0437\u043a\u0430 \u043a\u044a\u043c \u0431\u0440\u043e\u043a\u0435\u0440\u0430 \u0442\u0440\u044f\u0431\u0432\u0430 \u0434\u0430 \u0441\u0435 \u0438\u0437\u043f\u043e\u043b\u0437\u0432\u0430 <code>connect sys\/password<\/code>, \u0432\u043c\u0435\u0441\u0442\u043e <code>connect \/<\/code>. \u0418\u0434\u0438 \u0433\u0438 \u0440\u0430\u0437\u0431\u0435\u0440\u0438.<\/p>\n<blockquote><p>DGMGRL> connect sys<br \/>\nPassword:<br \/>\nConnected.<br \/>\nDGMGRL> show configuration<\/p>\n<p>Configuration<br \/>\n  Name:                My_guard<br \/>\n  Enabled:             YES<br \/>\n  Protection Mode:     MaxPerformance<br \/>\n  Fast-Start Failover: DISABLED<br \/>\n  Databases:<br \/>\n    mydb_prim &#8211; Physical standby database<br \/>\n    mydb_lsby      &#8211; Logical standby database<br \/>\n    mydb_psby     &#8211; Primary database<\/p>\n<p>Current status for &#8222;My_guard&#8220;:<br \/>\nSUCCESS<\/p>\n<p>DGMGRL> switcover to mydb_prim<br \/>\nUnrecognized command &#8222;switcover&#8220;, try &#8222;help&#8220;<br \/>\nDGMGRL> switchover to mydb_prim<br \/>\nPerforming switchover NOW, please wait&#8230;<br \/>\nOperation requires shutdown of instance &#8222;mydb&#8220; on database &#8222;mydb_psby&#8220;<br \/>\nShutting down instance &#8222;mydb&#8220;&#8230;<br \/>\nORA-01109: database not open<\/p>\n<p>Database dismounted.<br \/>\nORACLE instance shut down.<br \/>\nOperation requires shutdown of instance &#8222;mydb&#8220; on database &#8222;mydb_prim&#8220;<br \/>\nShutting down instance &#8222;mydb&#8220;&#8230;<br \/>\nORA-01109: database not open<\/p>\n<p>Database dismounted.<br \/>\nORACLE instance shut down.<br \/>\nOperation requires startup of instance &#8222;mydb&#8220; on database &#8222;mydb_psby&#8220;<br \/>\nStarting instance &#8222;mydb&#8220;&#8230;<br \/>\nORACLE instance started.<br \/>\nDatabase mounted.<br \/>\nOperation requires startup of instance &#8222;mydb&#8220; on database &#8222;mydb_prim&#8220;<br \/>\nStarting instance &#8222;mydb&#8220;&#8230;<br \/>\nORACLE instance started.<br \/>\nDatabase mounted.<br \/>\nSwitchover succeeded, new primary is &#8222;mydb_prim&#8220;<br \/>\nDGMGRL> show configuration<\/p>\n<p>Configuration<br \/>\n  Name:                My_guard<br \/>\n  Enabled:             YES<br \/>\n  Protection Mode:     MaxPerformance<br \/>\n  Fast-Start Failover: DISABLED<br \/>\n  Databases:<br \/>\n    mydb_prim &#8211; Primary database<br \/>\n    mydb_lsby      &#8211; Logical standby database<br \/>\n    mydb_psby      &#8211; Physical standby database<\/p>\n<p>Current status for &#8222;My_guard&#8220;:<br \/>\nSUCCESS<\/p><\/blockquote>\n<p>\u0410 \u0441\u0435\u0433\u0430 \u0441\u0438 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0435\u0442\u0435 \u0430\u043a\u043e \u043d\u0435 \u0435 \u0431\u0440\u043e\u043a\u0435\u0440\u0430, \u043a\u043e\u043b\u043a\u043e \u043a\u044a\u0440\u0442\u043e\u0432\u0441\u043a\u0438 \u0442\u0440\u0443\u0434 \u0435 \u0442\u043e\u0432\u0430. \u041f\u044a\u0440\u0432\u043e \u043d\u0430\u043f\u0440\u0430\u0432\u0438 \u0435\u0434\u0438-\u043a\u0430\u043a\u0432\u043e-\u0441\u0438 \u043d\u0430 \u0435\u0434\u043d\u0430\u0442\u0430 \u0431\u0430\u0437\u0430, \u043f\u043e\u0441\u043b\u0435 \u043d\u0430 \u0434\u0440\u0443\u0433\u0430\u0442\u0430, \u0434\u0430 \u043d\u0435 \u0437\u0430\u0431\u0440\u0430\u0432\u044f\u043c\u0435 \u043f\u0440\u0435\u043d\u0430\u0441\u0442\u0440\u043e\u0439\u0432\u0430\u043d\u0435\u0442\u043e \u043d\u0430 \u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0442\u0430&#8230; \u0412\u043c\u0435\u0441\u0442\u043e 5 \u043c\u0438\u043d\u0443\u0442\u0438 \u043e\u0442\u0438\u0432\u0430 \u043d\u0430 \u043a\u044a\u043c 25, \u0430\u043a\u043e \u0435 \u0434\u043e\u0431\u0440\u0430 \u043f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u043d\u0430\u0442\u0430 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430.<br \/>\n\u0410\u0431\u0435 \u0435\u0434\u0432\u0430 \u043b\u0438 \u0432\u0435\u0447\u0435 \u0449\u0435 \u043f\u0443\u0441\u043d\u0430 Data Guard \u0431\u0435\u0437 Broker.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041d\u0430\u043f\u043e\u0441\u043b\u0435\u0434\u044a\u043a \u0441\u044a\u043c \u0432\u043b\u044e\u0431\u0435\u043d \u0432 DataGuard Broker. \u0421\u0442\u0440\u0430\u0448\u043d\u043e \u043f\u043e\u043b\u0435\u0437\u0435\u043d \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442! \u0415, \u0438\u043c\u0430 \u0441\u0438 \u0441\u0432\u043e\u0438\u0442\u0435 \u0441\u0442\u0440\u0430\u043d\u043d\u043e\u0441\u0442\u0438, \u0432\u0441\u0435 \u043f\u0430\u043a&#8230;<\/p>\n<p>\u0414\u043d\u0435\u0441 \u0442\u0435\u0441\u0442\u0432\u0430\u0445 switcover \u043f\u0440\u0438 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043e\u0442 \u0435\u0434\u043d\u0430 primary, \u0435\u0434\u0438\u043d physical \u0438 \u0435\u0434\u0438\u043d logical standby. \u041f\u0440\u0435\u0434\u0432\u0430\u0440\u0438\u0442\u0435\u043b\u043d\u043e \u0441\u0435 \u043f\u043e\u0434\u0433\u043e\u0442\u0432\u0438\u0445 \u0441 research \u043d\u0430 \u0432\u044a\u0437\u043c\u043e\u0436\u043d\u0438\u0442\u0435 \u0431\u044a\u0433\u043e\u0432\u0435 \u0438 \u0442\u0435\u0445\u043d\u0438\u0442\u0435 workarounds. \u0417\u0430 \u0449\u0430\u0441\u0442\u0438\u0435 \u0441\u043c\u0435 \u043d\u0430 \u0434\u043e\u0441\u0442\u0430 \u0441\u0442\u0430\u0431\u0438\u043b\u043d\u0430 \u0432\u0435\u0440\u0441\u0438\u044f. \u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0435\u0434\u043d\u0430 \u043e\u0442 \u0433\u0440\u043e\u0437\u043d\u0438\u0442\u0435 \u043c\u043e\u0442\u0438\u043a\u0438 \u0435 \u043e\u043f\u0438\u0441\u0430\u043d\u0430 \u0432 note 761661.1. \u0410\u0431\u0435 \u0443\u0431\u0438\u0445 \u0441\u0438 \u0435\u0434\u0438\u043d \u0434\u0435\u043d \u0440\u043e\u0432\u0435\u043d\u0435&#8230;<\/p>\n<p>\u0418 \u0432\u0441\u0435 \u043f\u0430\u043a \u043d\u0435 \u0431\u044f\u0445 \u0441\u044a\u0432\u0441\u0435\u043c \u0438\u0437\u0440\u044f\u0434\u0435\u043d. \u041a\u043e\u0433\u0430\u0442\u043e \u0441\u0435 \u0437\u0430\u0441\u0438\u043b\u0438\u0445 \u0434\u0430 \u043f\u0440\u0435\u0445\u0432\u044a\u0440\u043b\u044f\u043c, \u0441\u0435 \u0441\u043b\u0443\u0447\u0438 \u0441\u043b\u0435\u0434\u043d\u043e\u0442\u043e:<\/p>\n<p>(<a href=\"http:\/\/blog.yavor.info\/?p=458\">A\u043a\u043e \u0442\u0438 \u0435 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e, \u0447\u0435\u0442\u0438 \u043d\u0430\u0442\u0430\u0442\u044a\u043a&#8230;<\/a>)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/458"}],"collection":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=458"}],"version-history":[{"count":2,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions"}],"predecessor-version":[{"id":617,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/458\/revisions\/617"}],"wp:attachment":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=458"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}