{"id":1006,"date":"2017-12-27T08:56:34","date_gmt":"2017-12-27T08:56:34","guid":{"rendered":"http:\/\/www.dbafox.com\/?p=1006"},"modified":"2017-12-28T07:27:21","modified_gmt":"2017-12-28T07:27:21","slug":"oracle-rman-drop-database","status":"publish","type":"post","link":"https:\/\/dbafox.com\/?p=1006","title":{"rendered":"Oracle – RMAN DROP DATABASE"},"content":{"rendered":"\n
-- set ORACLE env first\r\n\r\nexport ORACLE_SID=ORCL12\r\nexport ORACLE_HOME=\/oracle\/.....\r\n\r\noracle@oravm:~\/ [ORCL12] rman target \/\r\n\r\nRecovery Manager: Release 12.1.0.1.0 - Production on Wed Dec 27 09:45:33 2017\r\n\r\nCopyright (c) 1982, 2013, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database (not started)\r\n\r\nRMAN> startup force mount;\r\n\r\nOracle instance started\r\ndatabase mounted\r\n\r\nTotal System Global Area    4275781632 bytes\r\n\r\nFixed Size                     5218048 bytes\r\nVariable Size               2415919360 bytes\r\nDatabase Buffers            1845493760 bytes\r\nRedo Buffers                   9150464 bytes\r\n\r\nRMAN> show db_unique_name;\r\n\r\nusing target database control file instead of recovery catalog\r\nRMAN configuration parameters for database with db_unique_name ORCL12 are:\r\nRMAN configuration has no stored or default parameters\r\n\r\nRMAN> SQL 'ALTER SYSTEM ENABLE RESTRICTED SESSION';\r\n\r\nsql statement: ALTER SYSTEM ENABLE RESTRICTED SESSION\r\n\r\nRMAN> DROP DATABASE INCLUDING BACKUPS NOPROMPT;\r\n\r\ndatabase name is \"ORCL12\" and DBID is 2242343723\r\n\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=51 device type=DISK\r\nspecification does not match any backup in the repository\r\n\r\nreleased channel: ORA_DISK_1\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=51 device type=DISK\r\nspecification does not match any datafile copy in the repository\r\nspecification does not match any control file copy in the repository\r\nspecification does not match any control file copy in the repository\r\nList of Archived Log Copies for database with db_unique_name ORCL12\r\n=====================================================================\r\n\r\nKey     Thrd Seq     S Low Time\r\n------- ---- ------- - --------\r\n1       1    1       A 30.11.17\r\n        Name: +ORA_DATA\/ORCL12\/ARCHIVELOG\/2017_11_30\/thread_1_seq_1.407.961431639\r\n\r\n2       1    2       A 30.11.17\r\n        Name: +ORA_DATA\/ORCL12\/ARCHIVELOG\/2017_11_30\/thread_1_seq_2.414.961431685\r\n\r\n3       1    3       A 30.11.17\r\n        Name: +ORA_DATA\/ORCL12\/ARCHIVELOG\/2017_12_01\/thread_1_seq_3.316.961561207\r\n\r\ndeleted archived log\r\narchived log file name=+ORA_DATA\/ORCL12\/ARCHIVELOG\/2017_11_30\/thread_1_seq_1.407.961431639 RECID=1 STAMP=961431639\r\ndeleted archived log\r\narchived log file name=+ORA_DATA\/ORCL12\/ARCHIVELOG\/2017_11_30\/thread_1_seq_2.414.961431685 RECID=2 STAMP=961431684\r\ndeleted archived log\r\narchived log file name=+ORA_DATA\/ORCL12\/ARCHIVELOG\/2017_12_01\/thread_1_seq_3.316.961561207 RECID=3 STAMP=961561206\r\nDeleted 3 objects\r\n\r\n\r\ndatabase name is \"ORCL12\" and DBID is 2242343723\r\ndatabase dropped\r\n\r\nRMAN>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
— set ORACLE env first export ORACLE_SID=ORCL12 export ORACLE_HOME=\/oracle\/….. oracle@oravm:~\/ [ORCL12] rman target \/ Recovery Manager: Release 12.1.0.1.0 – Production on Wed Dec 27 09:45:33 2017 Copyright (c) 1982, 2013, Oracle and\/or its affiliates. All rights reserved. connected to target … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[49,43,28],"tags":[],"class_list":["post-1006","post","type-post","status-publish","format-standard","hentry","category-oracle-asm","category-oracle-rac","category-oracle-technical"],"yoast_head":"\nOracle - RMAN DROP DATABASE - dbafox<\/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:\/\/dbafox.com\/?p=1006\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle - RMAN DROP DATABASE - dbafox\" \/>\n<meta property=\"og:description\" content=\"-- set ORACLE env first export ORACLE_SID=ORCL12 export ORACLE_HOME=\/oracle\/..... oracle@oravm:~\/ [ORCL12] rman target \/ Recovery Manager: Release 12.1.0.1.0 - Production on Wed Dec 27 09:45:33 2017 Copyright (c) 1982, 2013, Oracle and\/or its affiliates. All rights reserved. connected to target … Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbafox.com\/?p=1006\" \/>\n<meta property=\"og:site_name\" content=\"dbafox\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-27T08:56:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-12-28T07:27:21+00:00\" \/>\n<meta name=\"author\" content=\"Ray Fox\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ray Fox\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbafox.com\/?p=1006\",\"url\":\"https:\/\/dbafox.com\/?p=1006\",\"name\":\"Oracle - RMAN DROP DATABASE - dbafox\",\"isPartOf\":{\"@id\":\"https:\/\/dbafox.com\/#website\"},\"datePublished\":\"2017-12-27T08:56:34+00:00\",\"dateModified\":\"2017-12-28T07:27:21+00:00\",\"author\":{\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\"},\"breadcrumb\":{\"@id\":\"https:\/\/dbafox.com\/?p=1006#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbafox.com\/?p=1006\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbafox.com\/?p=1006#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbafox.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle – RMAN DROP DATABASE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbafox.com\/#website\",\"url\":\"https:\/\/dbafox.com\/\",\"name\":\"dbafox\",\"description\":\"DBA Technical Information\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbafox.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\",\"name\":\"Ray Fox\",\"sameAs\":[\"http:\/\/www.dbafox.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle - RMAN DROP DATABASE - dbafox","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:\/\/dbafox.com\/?p=1006","og_locale":"en_GB","og_type":"article","og_title":"Oracle - RMAN DROP DATABASE - dbafox","og_description":"-- set ORACLE env first export ORACLE_SID=ORCL12 export ORACLE_HOME=\/oracle\/..... oracle@oravm:~\/ [ORCL12] rman target \/ Recovery Manager: Release 12.1.0.1.0 - Production on Wed Dec 27 09:45:33 2017 Copyright (c) 1982, 2013, Oracle and\/or its affiliates. All rights reserved. connected to target … Continue reading →","og_url":"https:\/\/dbafox.com\/?p=1006","og_site_name":"dbafox","article_published_time":"2017-12-27T08:56:34+00:00","article_modified_time":"2017-12-28T07:27:21+00:00","author":"Ray Fox","twitter_misc":{"Written by":"Ray Fox","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dbafox.com\/?p=1006","url":"https:\/\/dbafox.com\/?p=1006","name":"Oracle - RMAN DROP DATABASE - dbafox","isPartOf":{"@id":"https:\/\/dbafox.com\/#website"},"datePublished":"2017-12-27T08:56:34+00:00","dateModified":"2017-12-28T07:27:21+00:00","author":{"@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb"},"breadcrumb":{"@id":"https:\/\/dbafox.com\/?p=1006#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbafox.com\/?p=1006"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbafox.com\/?p=1006#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbafox.com\/"},{"@type":"ListItem","position":2,"name":"Oracle – RMAN DROP DATABASE"}]},{"@type":"WebSite","@id":"https:\/\/dbafox.com\/#website","url":"https:\/\/dbafox.com\/","name":"dbafox","description":"DBA Technical Information","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbafox.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb","name":"Ray Fox","sameAs":["http:\/\/www.dbafox.com"]}]}},"_links":{"self":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1006"}],"version-history":[{"count":2,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1006\/revisions"}],"predecessor-version":[{"id":1010,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/1006\/revisions\/1010"}],"wp:attachment":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}