{"id":931,"date":"2013-03-05T04:36:44","date_gmt":"2013-03-05T04:36:44","guid":{"rendered":"http:\/\/blog.yavor.info\/?p=931"},"modified":"2013-03-05T04:36:44","modified_gmt":"2013-03-05T04:36:44","slug":"ora-16631-operation-requires-shutdown-of-databaseinstance","status":"publish","type":"post","link":"http:\/\/blog.yavor.info\/?p=931","title":{"rendered":"ORA-16631: Operation requires shutdown of database\/instance &#8222;&#8220;"},"content":{"rendered":"<p>\u041e\u0449\u0435 \u0435\u0434\u043d\u0430 \u043c\u043e\u0442\u0438\u043a\u0430. \u0421\u043b\u0443\u0447\u0432\u0430 \u0441\u0435 \u0441\u043b\u0435\u0434\u043d\u043e\u0442\u043e<br \/>\n&#8211; \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043e\u0442 4 \u0411\u0414 (1 primary \u0438 3 standby)<br \/>\n&#8211; \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0438\u0440\u0430\u043c\u0435 \u0435\u0434\u0438\u043d\u0438\u044f standby. \u0412\u0441\u0438\u0447\u043a\u043e \u043c\u0438\u043d\u0430\u0432\u0430 \u043f\u043e \u043f\u043b\u0430\u043d<br \/>\n&#8211; dgmgrl \u043e\u0431\u0430\u0447\u0435 \u043c\u0438\u0441\u043b\u0438 \u0434\u0440\u0443\u0433\u043e:<\/p>\n<pre>DGMGRL> show configuration\n\nConfiguration - DG\n\n  Protection Mode: MaxAvailability\n  Databases:\n    primary  - Primary database\n    standby1 - Physical standby database\n    standby2 - Physical standby database (disabled)\n    standby3 - Logical standby database (disabled)\n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS<\/pre>\n<p><code>(disabled)<\/code> &#8211; WTF? \u0442\u0440\u044f\u0431\u0432\u0430 \u0434\u0430 \u0443\u0442\u043e\u0447\u043d\u044f, \u0447\u0435 \u0441\u043c\u0435 \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0438\u0440\u0430\u043b\u0438 standby1 &#8211; \u0434\u0440\u0443\u0433\u0438\u0442\u0435 \u043d\u0435 \u0441\u043c\u0435 \u0433\u0438 \u0438 \u043f\u0438\u043f\u0430\u043b\u0438.<\/p>\n<p>\u0425\u0430\u0439\u0434\u0435 \u0434\u0430 \u043e\u043f\u0438\u0442\u0430\u043c\u0435 \u043d\u0430\u0439-\u043b\u0435\u0441\u043d\u043e\u0442\u043e<\/p>\n<pre>\nDGMGRL> enable database standby2;\n<\/pre>\n<p>\u0421\u043b\u0435\u0434\u0432\u0430 \u0438\u0437\u043d\u0435\u043d\u0430\u0434\u0430:<\/p>\n<pre>\nORA-16631: Operation requires shutdown of database\/instance \"\"\n<\/pre>\n<p>\u042a\u044a\u044a&#8230; \u043a\u043e\u0439, \u0442\u043e\u0447\u043d\u043e, \u0438\u043d\u0441\u0442\u0430\u043d\u0441 \u0434\u0430 \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0438\u0440\u0430\u043c?<\/p>\n<p>\u0415\u0434\u0438\u043d\u0441\u0442\u0432\u0435\u043d\u043e\u0442\u043e \u0445\u0443\u0431\u0430\u0432\u043e \u043d\u0430 \u0442\u0430\u0437\u0438 \u0433\u0440\u0435\u0448\u043a\u0430 \u0435, \u0447\u0435 \u0432\u043e\u0434\u0438 \u0434\u043e \u043f\u0440\u0430\u0432\u0438\u043b\u043d\u0430\u0442\u0430 \u043d\u043e\u0442\u0430 \u0432 \u043c\u0435\u0442\u0430\u043b\u0438\u043d\u043a:<br \/>\nMetalink note <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/ui\/km\/SearchDocDisplay.jspx?id=1258074.1&#038;type=DOCUMENT&#038;displayIndex=1\" target=\"_blank\">1258074.1<\/a><\/p>\n<blockquote><p>\n<strong>Ora-16631: Operation Requires Shutdown Of Database Or Instance &#8222;&#8220; On Physical Standby<\/strong><\/p>\n<p><strong>Applies to:<\/strong><br \/>\n Oracle Server &#8211; Enterprise Edition &#8211; Version: 11.1.0.7 and later [Release: 11.1 and later ]<br \/>\n Information in this document applies to any platform.<\/p>\n<p><strong>Symptoms<\/strong><\/p>\n<p>ORA-16631: Operation requires shutdown of database\/instance &#8222;&#8220;<\/p>\n<p><strong>Cause<\/strong><br \/>\n Both the primary and standby were shutdown in an graceful fashion.<br \/>\n Since standby is shutdown before primary, standby is marked as shutdown disabled<br \/>\n standby is restarted first and then the primary.<br \/>\n standby sends a bootstrap request to the primary but since it&#8217;s not started yet,<br \/>\n it&#8217;s request goes unanswered. When primary is then started and as part of<br \/>\n its bootstrap processing the primary intentionally leaves the standby in a<br \/>\n shutdown disabled state. The FSFO state then transitions to an unsynchronized<br \/>\n state since the standby is not available. <\/p>\n<p><strong>Solution<\/strong><br \/>\n \u2014 on primary &#8211;- <\/p>\n<pre>\ndgmgrl \/\nedit database 'standby db unique name here' set state='ONLINE';\nshow configuration;\nexit\n<\/pre>\n<p>( or )<\/p>\n<p>&#8211;- on standby \u2014 <\/p>\n<pre>\nsqlplus \/ as sysdba\nshu immediate\nstartup mount\n<\/pre>\n<\/blockquote>\n<p>\u0415, \u0432\u044f\u0440\u043d\u043e, \u043f\u0440\u0438 \u043d\u0430\u0441 \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0430 \u0435 \u0438 \u043f\u0440\u0438 physical, \u0438 \u043f\u0440\u0438 logical standby. \u041e\u0441\u0432\u0435\u043d \u0442\u043e\u0432\u0430 \u043d\u0435 \u0441\u044a\u043c \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0438\u0440\u0430\u043b \u043d\u0438\u0442\u043e \u0442\u044f\u0445, \u043d\u0438\u0442\u043e primary \u0431\u0430\u0437\u0430\u0442\u0430. \u041c\u043e\u0433\u0430 \u0441\u0430\u043c\u043e \u0434\u0430 \u043f\u0440\u0435\u0434\u043f\u043e\u043b\u0430\u0433\u0430\u043c, \u0447\u0435 \u043a\u043e\u0433\u0430\u0442\u043e <code>standby1<\/code> \u0435 \u043a\u0430\u0437\u0430\u043b \u043d\u0430 <code>primary<\/code> <em>&#8222;\u0430\u0437 \u0441\u0438 \u0437\u0430\u043c\u0438\u043d\u0430\u0432\u0430\u043c&#8220;<\/em>, <code>primary<\/code> \u043d\u044f\u043a\u0430\u043a \u0441\u0435 \u0435 \u043e\u0431\u044a\u0440\u043a\u0430\u043b \u0438 \u0435 \u043e\u0442\u043f\u0438\u0441\u0430\u043b \u0432\u0441\u0438\u0447\u043a\u0438\u0442\u0435 \u0411\u0414. \u041f\u043e\u0441\u043b\u0435 <code>standby1<\/code> \u0435 \u0438\u0437\u0433\u0440\u044f\u043b \u0438 \u0435 \u0438\u0437\u043f\u0440\u0430\u0442\u0438\u043b <em>bootstrap<\/em> \u0441\u0438\u0433\u043d\u0430\u043b. \u0422\u043e\u0433\u0430\u0432\u0430 <code>primay<\/code> \u0433\u043e \u0435 \u0432\u043f\u0438\u0441\u0430\u043b \u0432 \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f\u0442\u0430, \u043e\u0441\u0442\u0430\u0432\u044f\u0439\u043a\u0438 \u0434\u0440\u0443\u0433\u0438\u0442\u0435 \u0434\u0432\u0430 \u043d\u0430 \u0441\u0443\u0445\u043e.<br \/>\n\u041d\u043e \u043f\u043e\u043d\u0435 Solution-\u0430 \u0440\u0430\u0431\u043e\u0442\u0438. \u0415\u0441\u0442\u0435\u0441\u0442\u0432\u0435\u043d\u043e \u0438\u0437\u0431\u0440\u0430\u0445 \u043f\u044a\u0440\u0432\u0438\u044f \u043a\u0430\u0442\u043e \u043c\u043d\u043e\u0433\u043e \u043f\u043e-\u043c\u0430\u043b\u043a\u043e \u0438\u043d\u0432\u0430\u0437\u0438\u0432\u0435\u043d. \u0427\u0435 \u0437\u043d\u0430\u043c \u043b\u0438 \u043a\u0430\u0442\u043e \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0438\u0440\u0430\u043c <code>standby2<\/code> \u043a\u0430\u043a\u0432\u043e \u0449\u0435 \u0441\u0442\u0430\u043d\u0435 \u0441\u044a\u0441 <code>standby1<\/code>&#8230; \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u041e\u0449\u0435 \u0435\u0434\u043d\u0430 \u043c\u043e\u0442\u0438\u043a\u0430. \u0421\u043b\u0443\u0447\u0432\u0430 \u0441\u0435 \u0441\u043b\u0435\u0434\u043d\u043e\u0442\u043e &#8211; \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u044f \u043e\u0442 4 \u0411\u0414 (1 primary \u0438 3 standby) &#8211; \u0440\u0435\u0441\u0442\u0430\u0440\u0442\u0438\u0440\u0430\u043c\u0435 \u0435\u0434\u0438\u043d\u0438\u044f standby. \u0412\u0441\u0438\u0447\u043a\u043e \u043c\u0438\u043d\u0430\u0432\u0430 \u043f\u043e \u043f\u043b\u0430\u043d &#8211; dgmgrl \u043e\u0431\u0430\u0447\u0435 \u043c\u0438\u0441\u043b\u0438 \u0434\u0440\u0443\u0433\u043e: DGMGRL> show configuration Configuration &#8211; DG Protection Mode: MaxAvailability Databases: primary &#8211; Primary database standby1 &#8211; Physical standby database standby2 &#8211; Physical standby database (disabled) standby3 <a href='http:\/\/blog.yavor.info\/?p=931' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/931"}],"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=931"}],"version-history":[{"count":7,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/931\/revisions"}],"predecessor-version":[{"id":938,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=\/wp\/v2\/posts\/931\/revisions\/938"}],"wp:attachment":[{"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=931"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.yavor.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}