{"id":2684,"date":"2011-07-06T10:20:08","date_gmt":"2011-07-06T15:20:08","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=2684"},"modified":"2011-07-06T10:20:08","modified_gmt":"2011-07-06T15:20:08","slug":"recreate-oracle-database-with-full-expimp","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=2684","title":{"rendered":"Recreate Oracle Database with Full Exp\/Imp"},"content":{"rendered":"

Full Database Export<\/h2><\/span>\n

Start Database<\/h3><\/span>\n

* Start up database and listener if they are not already started.
\n* tnsping db instance to make sure it’s started.<\/p>\n

\r\nC:\\TEMP>tnsping orcl\r\n...\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my.com)(PORT = 1521))\r\n(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))\r\nOK (40 msec)\r\n<\/pre>\n
Full Export<\/h3><\/span>\n
* Export database in full mode.<\/p>\n
\r\nC:\\TEMP>exp system\/orcl@orcl full=y file=fullexp.dump log=fullexp.log\r\n...\r\nAbout to export the entire database ...\r\n. exporting tablespace definitions\r\n....\r\nExport terminated successfully with warnings.\r\n<\/pre>\n
Remove Database<\/h2><\/span>\n
* Start Database Configuration Assistant.
\n* Click Next on Welcome page.
\n* Select “Delete a Database” and click Next.
\n* Select database instance to be removed, e.g. ORCL
\n* Click Finish.
\n* Click Yes on “Do you want to proceed?” warning dialog.
\n* Click No on “Do you want to perform another operation?” dialog.<\/p>\n
Create a New Database<\/h2><\/span>\n
* Start Database Configuration Assistant.
\n* Click Next on Welcome page.
\n* Select Create a Database and click Next.
\n* Select General Purpose and click Next.
\n* Enter
\n– Global Database Name: orcl.world
\n– SID: orcl
\n– Click Next
\n* On Step 4 of 12: Management Options, accept defaults and click Next
\nChecked:
\n– Configure the Database with Enterprise manager
\n– Use Database Control for Database Management
\n* On Step 5 of 12: Database Credentials screen,
\n– Select use the Same Password for All Accounts
\n– Password: orcl
\n– Confirm Password: orcl
\n– Click Next
\n* Select File System on Storage Options screen. Click Next.
\n* On Database File Locations screem,
\n– Select “Use Common Location for All Database Files” and enter
\n– Database Files Location: C:\\prog\\oracle\\product\\10.2.0\\oradata
\n– Click Next
\n* On Recovery Configuration screen, accept default and click Next.
\n* Click Next on Database Content screen and click Next.
\n* On Initialization Parameters screen,
\n– Memory Tab
\n~ Typical -> Percentage: 40
\n– Sizing Tab
\n~ Processes: 150
\n– Character Sets Tab
\n~ Use Unicode (AL32UTF8)
\n~ National Character Set: AL16UTF16
\n~ Default Language: American
\n~ Default Date Format: United States
\n– Connection Mode Tab
\n~ Dedicated Server Mode
\n* Click Next on Step 11 of 12: Database Storage screen.
\n* On Step 12 of 12: Creation Options screen,
\n– Select Create Database
\n– Select Generate Database Create Scripts
\n~ Destination Directory: C:\\prog\\oracle\\product\\10.2.0\\admin\\orcl\\scripts
\n* Click Finish.
\n* Click OK on confirmation screen.
\n* Click OK on script generation successful dialog.
\n* Click Exit when finished.<\/p>\n
Full Import<\/h2><\/span>\n
* Start newly created database.<\/p>\n
\r\nC:\\TEMP>tnsping orcl\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = my.com)(PORT = 1521))\r\n(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.world)))\r\nOK (30 msec)\r\n<\/pre>\n
* Import<\/p>\n
\r\nimp system\/orcl@orcl full=y file=fullexp.dump log=fullimp.log\r\n\r\n...\r\nImport terminated successfully with warnings.\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Full Database Export Start Database * Start up database and listener if they are not already started. * tnsping db instance to make sure it’s started. C:\\TEMP>tnsping orcl … Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION … 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":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[35],"tags":[],"class_list":["post-2684","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-Hi","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2684"}],"version-history":[{"count":5,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2684\/revisions"}],"predecessor-version":[{"id":2700,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/2684\/revisions\/2700"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}