{"id":113,"date":"2012-05-15T12:50:10","date_gmt":"2012-05-15T12:50:10","guid":{"rendered":"http:\/\/tomas.papp.me.uk\/?p=113"},"modified":"2012-05-15T12:50:59","modified_gmt":"2012-05-15T12:50:59","slug":"manualny-switchover-medzi-primarnou-a-dr-oracle-databazou","status":"publish","type":"post","link":"https:\/\/tomas.papp.me.uk\/?p=113","title":{"rendered":"Manualny switchover medzi primarnou a DR oracle databazou"},"content":{"rendered":"<p><span style=\"text-decoration: underline;\">Primarna strana:<\/span><\/p>\n<div>1;) zhodit vsetky RAC instancie na PRI a DR strane okrem jednej<\/div>\n<div>2;)\u00a0alter database commit to switchover to physical standby with session shutdown;<\/div>\n<div>3;)\u00a0shutdown immediate;<\/div>\n<div>4;)\u00a0startup nomount;<\/div>\n<div>5;) alter database mount standby database;<\/div>\n<div>6;) alter database recover managed standby database\u00a0disconnect;<\/div>\n<div><\/div>\n<p><span style=\"text-decoration: underline;\">DR strana<\/span><\/p>\n<div><\/div>\n<div>7:)\u00a0alter database recover managed standby database cancel;<\/div>\n<div>8:) ak pouzivame delayed apply je dobre urobit toto:\u00a0alter database recover managed standby database nodelay disconnect from session through last switchover;<\/div>\n<div>9;) \u00a0alter database commit to switchover to primary with session shutdown;<\/div>\n<div>10;) alter database open;<\/div>\n<div><\/div>\n<div><\/div>\n<div>potom uz len otvorit ostatne instancie v stave aby reflektovali svoje cluster protikusy<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Primarna strana: 1;) zhodit vsetky RAC instancie na PRI a DR strane okrem jednej 2;)\u00a0alter database commit to switchover to physical standby with session shutdown; 3;)\u00a0shutdown immediate; 4;)\u00a0startup nomount; 5;) alter database mount standby database; 6;) alter database recover managed standby database\u00a0disconnect; DR strana 7:)\u00a0alter database recover managed standby database cancel; 8:) ak pouzivame delayed [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-113","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=113"}],"version-history":[{"count":3,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":115,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/113\/revisions\/115"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}