{"id":2645,"date":"2017-06-07T23:55:12","date_gmt":"2017-06-08T02:55:12","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=2645\/"},"modified":"2017-07-17T10:37:19","modified_gmt":"2017-07-17T13:37:19","slug":"ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/","title":{"rendered":"OCM 12c Preparation &#8211; Protect the database from loss of data due to any kind of failure"},"content":{"rendered":"<p>So, you need to know how to protect your database and how to resolve any kind of issue.<\/p>\n<p>How to protect is the easier part, you must ensure your environment will be prepared for a catastrophic event:<\/p>\n<ul>\n<li>Enable Archivelog<\/li>\n<li>Enable Flashback<\/li>\n<li>Add Supplemental Log<\/li>\n<\/ul>\n<p>Then perform a full backup of your CDB (including the PDBs)<\/p>\n<p>What you need to do here is do all kinds of complete restore\/recovery operations.<\/p>\n<p>Practice the following:<\/p>\n<ul>\n<li>Losing one or multiple logfiles (members or entire groups, active or inactive)<\/li>\n<li>Losing one or all controlfiles<\/li>\n<li>Losing one or all datafiles from CDB<\/li>\n<li>Losing one or all datafiles from PDB (with or without the PDB backup after its creation)<\/li>\n<li>Losing spfile<\/li>\n<li>Losing everything (including spfile)<\/li>\n<li>Database, PDB and Tablespace point in time recovery<\/li>\n<li>Drop a PDB and do a PDB PITR just before it was removed<\/li>\n<li>Using Restore Points to flashback your database<\/li>\n<li>New Table Point In Time Recovery (using also the REMAP or dump file features)<\/li>\n<\/ul>\n<p>I also recommend studying the situation where you have a data guard\u00a0environment and you need to restore missing controlfile\/datafiles on your primary using the standby (and vice versa).<\/p>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Oracle Database Backup and Recovery User\u2019s Guide -&gt; Performing RMAN Recovery: Advanced Scenarios<\/span><br \/>\n<span style=\"color: #800000;\"> Oracle Data Guard Concepts and Administration -&gt; 11 Using RMAN to Back Up and Restore Files<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 12c Preparation\" href=\"\/?page_id=2255\">Main OCM 12c Preparation<\/a> page.\r\n<br><br>\r\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-2645 jlk' href='javascript:void(0)' data-task='like' data-post_id='2645' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-2645 lc'>+3<\/span><\/a><\/div><\/div> <div class='status-2645 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>So, you need to know how to protect your database and how to resolve any kind of issue. How to protect is the easier part, you must ensure your environment will be prepared for a catastrophic event: Enable Archivelog Enable Flashback Add Supplemental Log Then perform a full backup of your CDB (including the PDBs) &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-2645","post","type-post","status-publish","format-standard","hentry","category-ocm12c-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OCM 12c Preparation - Protect the database from loss of data due to any kind of failure - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Protect the database from loss of data due to any kind of failure for Oracle OCM 12c Certification\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 12c Preparation &#8211; Protect the database from loss of data due to any kind of failure\",\"datePublished\":\"2017-06-08T02:55:12+00:00\",\"dateModified\":\"2017-07-17T13:37:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/\"},\"wordCount\":247,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 12c Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/\",\"name\":\"OCM 12c Preparation - Protect the database from loss of data due to any kind of failure - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2017-06-08T02:55:12+00:00\",\"dateModified\":\"2017-07-17T13:37:19+00:00\",\"description\":\"Protect the database from loss of data due to any kind of failure for Oracle OCM 12c Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 12c Preparation - Protect the database from loss of data due to any kind of failure\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OCM 12c Preparation - Protect the database from loss of data due to any kind of failure - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Protect the database from loss of data due to any kind of failure for Oracle OCM 12c Certification","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 12c Preparation &#8211; Protect the database from loss of data due to any kind of failure","datePublished":"2017-06-08T02:55:12+00:00","dateModified":"2017-07-17T13:37:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/"},"wordCount":247,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 12c Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/","url":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/","name":"OCM 12c Preparation - Protect the database from loss of data due to any kind of failure - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2017-06-08T02:55:12+00:00","dateModified":"2017-07-17T13:37:19+00:00","description":"Protect the database from loss of data due to any kind of failure for Oracle OCM 12c Certification","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-protect-the-database-from-loss-of-data-due-to-any-kind-of-failure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 12c Preparation - Protect the database from loss of data due to any kind of failure"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=2645"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2645\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=2645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=2645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=2645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}