{"id":1547,"date":"2013-10-17T21:58:20","date_gmt":"2013-10-17T19:58:20","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=1547"},"modified":"2013-10-17T22:10:05","modified_gmt":"2013-10-17T20:10:05","slug":"oracle-setup-archivelog-mode","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=1547","title":{"rendered":"Oracle : Setup ArchiveLOG mode"},"content":{"rendered":"<p><span style=\"color: #000000; font-family: Arial; font-size: small;\">Archive logging is essential for production databases where the loss of a transaction might be fatal. It is generally considered unnecessary in development and test environments.<\/span> A general view on a database oracle Instance is Like below :<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog01.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-1548 aligncenter\" alt=\"archivelog01\" src=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog01.jpg\" width=\"510\" height=\"523\" srcset=\"https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog01.jpg 510w, https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog01-292x300.jpg 292w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/a><\/p>\n<p style=\"text-align: center;\">Setup Destination Folders for Archivelog in Initialisation File :<\/p>\n<p style=\"text-align: center;\">\u00a0<a href=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog02.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-1549 aligncenter\" alt=\"archivelog02\" src=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog02.jpg\" width=\"636\" height=\"260\" srcset=\"https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog02.jpg 636w, https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog02-300x122.jpg 300w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Validate Parameters files by restarting the database :<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog03.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-1550 aligncenter\" alt=\"archivelog03\" src=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog03.jpg\" width=\"363\" height=\"335\" srcset=\"https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog03.jpg 363w, https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog03-300x276.jpg 300w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Now it is time to activate Archivelog Mode and verify that it is setup in place :<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog04.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-1551 aligncenter\" alt=\"archivelog04\" src=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog04.jpg\" width=\"549\" height=\"362\" srcset=\"https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog04.jpg 549w, https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog04-300x197.jpg 300w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/a><a href=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog05.jpg\"><img loading=\"lazy\" class=\"size-full wp-image-1552 aligncenter\" alt=\"archivelog05\" src=\"http:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog05.jpg\" width=\"492\" height=\"331\" srcset=\"https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog05.jpg 492w, https:\/\/www.extradrm.com\/wp-content\/uploads\/2013\/10\/archivelog05-300x201.jpg 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/a><\/p>\n<p style=\"text-align: left;\">Notice the oldest log sequence online after the switch command. In the destination files you see archive created by forcing alter switch on control log sequence Files.<\/p>\n<p style=\"text-align: left;\">Cheers<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Archive logging is essential for production databases where the loss of a transaction might be fatal. It is generally considered unnecessary in development and test environments. A general view on a database oracle Instance&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":2845,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[240],"tags":[248,249],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1547"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1547"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1547\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2845"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}