Today, I was working with a code base still in development, but really wanted to use it against the latest production data. To achieve this, I used Oracle 11g’s Recovery Manager, “RMAN”, to duplicate the latest content of my production database onto a development Oracle server that I have set up to work with my development code. Let us assume that my production database name was “prodDb” residing on server “prodServer”, the database I was creating is “devDb” residing on “devServer”.<\/p>\n
First, I needed to create some directories on devServer.<\/p>\n
\nmkdir -p \/u01\/app\/oracle\/admin\/devDb\/adump\nmkdir -p \/u01\/app\/oracle\/flash_recovery_area\/devDb\nmkdir -p \/u01\/oradata\/devDb\n<\/pre>\nThen, on devServer, I used the scp command to copy the prodServer password file to devServer.<\/p>\n
\nscp prodServer:\/u01\/app\/oracle\/product\/ver_no\/db_1\/dbs\/orapwproddb $ORACLE_HOME\/dbs\/.\n<\/pre>\nNext, I created a dummy init file so we can mount this empty devDb database.<\/p>\n
\necho 'DB_NAME=devDb' > $ORACLE_HOME\/dbs\/initdevDb.ora\necho 'control_files=(\/u01\/oradata\/devDb\/control01.ctl,\/u01\/oradata\/devDb\/control02.ctl,\/u01\/oradata\/devDb\/control03.ctl)' >> $ORACLE_HOME\/dbs\/initdevDb.ora\n<\/pre>\nI mounted devDb, then restarted the listener.<\/p>\n
\n(From terminal prompt, log in to SQL*Plus as sysdba)\nsqlplus \/nolog\nconn \/ as sysdba\n\n(SQL*Plus command to mount database)\nstartup nomount pfile=$ORACLE_HOME\/dbs\/initdevDb.ora;\nexit;\n\n(Back in terminal prompt, restart the listener)\nlsnrctl stop\nlsnrctl start\n<\/pre>\nMy work on the devServer was then done. I moved on to the prodServer machine; from the terminal prompt of the prodServer, I started RMAN.<\/p>\n
\n(From terminal prompt, run \"rman\")\nrman\n\n(In RMAN prompt, connect to prodDb as target, and to devDb as the auxiliary)\nconnect target sys@prodDb\nconnect auxiliary sys@devDb\n\n(In RMAN, run the following script; you may wish to modify to suit your needs, of course)\nrun {\n duplicate target database to devDb from active database\n spfile\n parameter_value_convert 'prodDb','devDb'\n set db_unique_name='devDb'\n set service_names='devDb.mydomain.com'\n set log_file_name_convert='prodDb','devDb'\n set log_archive_config=''\n set fal_client=''\n set fal_server=''\n set log_archive_dest_1=''\n set memory_max_target='1200m'\n set memory_target='1200m'\n set sga_max_size='800m'\n set sga_target='800m'\n set db_recovery_file_dest_size = '20G'\n db_file_name_convert 'prodDb','devDb'\n ;\n }\n<\/pre>\n","protected":false},"excerpt":{"rendered":"This note illustrates how to use Oracle 11g’s RMAN utility to duplicate a database.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-126","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/posts\/126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/comments?post=126"}],"version-history":[{"count":0,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/posts\/126\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/media?parent=126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/categories?post=126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dev-notes.com\/blog\/wp-json\/wp\/v2\/tags?post=126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}