{"id":1526,"date":"2020-03-18T10:55:00","date_gmt":"2020-03-18T10:55:00","guid":{"rendered":"http:\/\/kb.esds.co.in\/?p=1526"},"modified":"2020-03-19T10:28:31","modified_gmt":"2020-03-19T10:28:31","slug":"unplug-and-plug-db","status":"publish","type":"post","link":"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/","title":{"rendered":"Unplugging and Plugging Database 18c"},"content":{"rendered":"

This article focuses on steps to unplug the database from the container database and then plugging it back to the same or another container.<\/p>\n

Here I have explained the method of using command prompt, whereas you can also manage the plugging and unplugging through Database Configuration Assistance (DBCA).<\/p>\n

Let\u2019s begin with Unplugging the Database.<\/p>\n

Unplugging Database<\/strong>:<\/strong><\/p>\n

Before unplugging database make sure that you are connected to an appropriate database and close the pluggable database.<\/p>\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Make a note, when we unplug the database, some repository needs to be created that will provide the metadata about the database when we wish to plug the same database back to the container database.
See the screenshot below to unplug the database generates XML file. This XML file stores the information about name, full paths of tablespaces and datafiles. <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Plugging Database:<\/strong><\/p>\n\n\n\n

Now, after unplugging DB, we are plugging back the unplugged database to the same container database. But in the case when you need to unplugged the database to another container database, it is always essential first to verify the compatibility of the pluggable database with a container database. The verification can be done with Oracle Package and Stored Procedure. <\/p>\n\n\n\n

\u201cDB_PDB.CHECK_PLUG_COMPATIBILITY\u201d.\u00a0<\/strong>This\u00a0can be simply verified using PL\/SQL code<\/strong> shown below: <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

As per the output results, we saw that the unplugged database is compatible and we can proceed further to plug it. <\/p>\n\n\n\n

Here the XML file will be generated while unplugging the database, for the creation and plugging the database. <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

Once the pluggable database is created and plugged in, you can see the newly created database is in mount<\/strong> state. <\/p>\n\n\n\n

Shift to the pluggable database and open it. <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

That\u2019s it! We are done with unplugging and plugging databases. <\/p>\n\n\n\n

To check the logs of the entire process from unplugging the database to plugging it back again, you can refer to the alert log file. This will help you clearly understand the internals of plugging and unplugging databases. <\/p>\n\n\n\n

I hope the article was helpful to you. To know more stay tuned with us. <\/p>\n","protected":false},"excerpt":{"rendered":"

This article focuses on steps to unplug the database from the container database and then plugging it back to the same or another container. Here I have explained the method of using command prompt, whereas you can also manage the plugging and unplugging through Database Configuration Assistance (DBCA). Let\u2019s begin with Unplugging the Database. Unplugging… <\/p>\n

<\/div>\n

Read More<\/a><\/p>\n","protected":false},"author":23,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[196],"tags":[969,603,968,602,967],"aioseo_notices":[],"yoast_head":"\nUnplug and Plug DB<\/title>\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.esds.co.in\/kb\/unplug-and-plug-db\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unplug and Plug DB\" \/>\n<meta property=\"og:description\" content=\"This article focuses on steps to unplug the database from the container database and then plugging it back to the same or another container. Here I have explained the method of using command prompt, whereas you can also manage the plugging and unplugging through Database Configuration Assistance (DBCA). Let\u2019s begin with Unplugging the Database. Unplugging... Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/\" \/>\n<meta property=\"og:site_name\" content=\"ESDS Official Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ESDSdc\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-18T10:55:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-19T10:28:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.esds.co.in\/kb\/wp-content\/uploads\/2020\/03\/1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ESDSDataCenter\" \/>\n<meta name=\"twitter:site\" content=\"@ESDSDataCenter\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"2 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#website\",\"url\":\"https:\/\/www.esds.co.in\/kb\/\",\"name\":\"ESDS Official Knowledgebase\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.esds.co.in\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.esds.co.in\/kb\/wp-content\/uploads\/2020\/03\/1.jpg\",\"width\":624,\"height\":247},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/#webpage\",\"url\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/\",\"name\":\"Unplug and Plug DB\",\"isPartOf\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/#primaryimage\"},\"datePublished\":\"2020-03-18T10:55:00+00:00\",\"dateModified\":\"2020-03-19T10:28:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/#\/schema\/person\/4344af4dd22cdad2ba4c1de386afe0bf\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/\",\"url\":\"https:\/\/www.esds.co.in\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/\",\"url\":\"https:\/\/www.esds.co.in\/kb\/unplug-and-plug-db\/\",\"name\":\"Unplugging and Plugging Database 18c\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#\/schema\/person\/4344af4dd22cdad2ba4c1de386afe0bf\",\"name\":\"Niteesha Birari\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.esds.co.in\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/93d45d75be857b4cc9726661e8429b97?s=96&d=mm&r=g\",\"caption\":\"Niteesha Birari\"},\"description\":\"Niteesha is a Senior Specialist at ESDS, working closely with the Governance Team to drive innovation, efficiency, and compliance across projects. With a strong passion for cloud technologies and digital innovation, she plays a key role in designing and maintaining the organization\\u2019s information architecture, ensuring seamless data accessibility and system efficiency. Known for her sharp analytical mindset and clear communication, Niteesha has extensive experience in crafting high-quality technical documentation\\u2014including articles, user guides, and service manuals\\u2014that simplify complex software products and services for diverse audiences.\",\"sameAs\":[\"https:\/\/esds.co.in\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/1526"}],"collection":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/comments?post=1526"}],"version-history":[{"count":8,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/1526\/revisions"}],"predecessor-version":[{"id":3961,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/posts\/1526\/revisions\/3961"}],"wp:attachment":[{"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/media?parent=1526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/categories?post=1526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.esds.co.in\/kb\/wp-json\/wp\/v2\/tags?post=1526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}