{"id":993,"date":"2015-12-31T00:12:54","date_gmt":"2015-12-31T00:12:54","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=993"},"modified":"2015-12-31T00:12:54","modified_gmt":"2015-12-31T00:12:54","slug":"db-name-%eb%b3%80%ea%b2%bd-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=993","title":{"rendered":"DB Name \ubcc0\uacbd \ubc29\ubc95"},"content":{"rendered":"

DB Name \ubcc0\uacbd \uc808\ucc28<\/SPAN><\/B><\/FONT><\/P>
\n

– <\/SPAN><\/B><\/FONT>\ucc38\uc870 \ubb38\uc11c <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

(<\/SPAN><\/B>How to Change the DBID and the DBNAME by using NID (<\/SPAN><\/B>\ubb38\uc11c ID 224266.1), <\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

How to Rename Database\/Change DB_NAME or ORACLE_SID\/Instance Name <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

(<\/SPAN><\/B>\ubb38\uc11c ID 15390.1))<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

 <\/P>
\n

 <\/FONT><\/SPAN><\/P>
\n

<\/FONT> <\/P>
\n

                         <\/SPAN>i.<\/FONT>         <\/SPAN><\/SPAN><\/SPAN>NID <\/SPAN>\uc0ac\uc6a9<\/FONT><\/FONT><\/P>
\n

\u2460<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uc791\uc5c5\uc744 \ud558\uae30 \uc804\uc5d0 Backup <\/SPAN>\uc744 \ubc1b\uc544 \ub193\ub294\ub2e4.<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2461<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>db_name <\/SPAN>\ubcc0\uacbd\uc744 \uc704\ud55c pfile (initSID) <\/SPAN>\uc0dd\uc131<\/FONT><\/FONT><\/P>
\n

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Instance Shutdown & Database mount<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>NID utility <\/SPAN>\ub97c \uc774\uc6a9\ud574 DB Name <\/SPAN>\ubcc0\uacbd<\/FONT><\/FONT><\/P>
\n

\u2464<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Instance Shutdown<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2465<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>pfile (initTECH.ora) <\/SPAN>\uc744 \uc5f4\uc5b4 \u2018db_name=test\u2019 <\/SPAN>\ub85c \uc218\uc815<\/FONT><\/FONT><\/P>
\n

(SID <\/SPAN>\ubcc0\uacbd \uc2dc \ud30c\uc77c\uba85\ub3c4 \uac19\uc774 \uc218\uc815)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2466<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>password file <\/SPAN>\uc0dd\uc131(SID<\/SPAN>\ub3c4 \ud568\uaed8 \ubcc0\uacbd \uc2dc)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2467<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Database mount<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2468<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Database RESETLOGS <\/SPAN>\ub85c Open<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2469<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\ud655\uc778\uc791\uc5c5\uc744 \ud1b5\ud574 \ub9c8\ubb34\ub9ac<\/FONT><\/FONT><\/P>
\n
\n
\n
\n

\n

\uba85\ub839\uc5b4<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD>
\n


\n

SQL> create pfile from spfile;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> shutdown immediate<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> startup mount pfile=\u2019$ORACLE_HOME\/dbs\/initTECH.ora\u2019<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ nid target=sys\/oracle@tech<\/A> dbname=test logfile=\/u01\/app\/nidlog<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> shutdown immediate<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ vi $ORACLE_HOME\/dbs\/initTECH.ora<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ cp initTECH.ora inittest.ora (SID <\/SPAN><\/B>\ub3c4 \ubcc0\uacbd\uc2dc)<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

$ orapwd file=orapwtest password=oracle entires=5<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> startup mount pfile=\u2019$ORACLE_HOME\/dbs\/inittest.ora<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter database open;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> select dbid, name, open_mode, activation#, created from v$database;<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

                        <\/SPAN>ii.<\/FONT>         <\/SPAN><\/SPAN><\/SPAN>Controlfile <\/SPAN>\uc7ac\uc0dd\uc131\uc744 \ud1b5\ud55c DB Name <\/SPAN>\ubcc0\uacbd<\/FONT><\/FONT><\/P>
\n

\u2460<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Controlfile <\/SPAN>\uc744 \uc7ac\uc0dd\uc131 \ud558\uae30 \uc704\ud574 Trace file <\/SPAN>\uc0dd\uc131<\/FONT><\/FONT><\/P>
\n

\u2461<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>db_name <\/SPAN>\ubcc0\uacbd\uc744 \uc704\ud574 pfile(init.ora) <\/SPAN>\uc0dd\uc131<\/FONT><\/FONT><\/P>
\n

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Instance Shutdown<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>pfile <\/SPAN>\uc744 \uc5f4\uc5b4\uc11c \u2018db_name=TEST2\u2019 <\/SPAN>\ub85c \uc218\uc815 (SID <\/SPAN>\ud568\uaed8 \ubcc0\uacbd \uc2dc \ud30c\uc77c\uba85\ub3c4 \uc218\uc815)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2464<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>control_files <\/SPAN>\uc758 \uac12\uc744 \uc0c8\ub85c\uc6b4 Controlfile <\/SPAN>\uba85\uc73c\ub85c \ubcc0\uacbd(<\/SPAN>\uc911\ubcf5 \uc2dc Error <\/SPAN>\ubc1c\uc0dd)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2465<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>1<\/SPAN>\ubc88\uc5d0\uc11c \uc0dd\uc131\ud55c Trace file <\/SPAN>\uc744 \uc5f4\uc5b4 Controlfile <\/SPAN>\uc7ac\uc0dd\uc131 \ubd80\ubd84\uc744 \ubcf5\uc0ac\ud574\uc11c script <\/SPAN>\uc791\uc131 (REUSE => SET, DB Name <\/SPAN>\uc218\uc815)<\/SPAN><\/FONT><\/FONT><\/P>
\n

<\/SPAN><\/FONT><\/FONT><\/P>
\n

<\/v:rect><\/v:rect><\/v:stroke><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:f><\/v:formulas><\/v:path><\/o:lock><\/v:shapetype><\/SPAN><\/P>
\n

\u2466<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Script <\/SPAN>\uc2e4\ud589 \uc2dc mount <\/SPAN>\uc0c1\ud0dc\uae4c\uc9c0 \uc9c4\ud589<\/FONT><\/FONT><\/P>
\n

\u2467<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Open <\/SPAN>\uc744 \uc704\ud574 Recover Database <\/SPAN>\uc9c4\ud589<\/FONT><\/FONT><\/P>
\n

\u2468<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Database Open<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2469<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\ud655\uc778\uc791\uc5c5\uc744 \ud1b5\ud574 \ub9c8\ubb34\ub9ac<\/FONT><\/FONT><\/P>
\n
\n
\n
\n

\n

\uba85\ub839\uc5b4<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD>
\n


\n

SQL> alter database backup controlfile to trace;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> create pfile from spfile;<\/SPAN><\/B> <\/SPAN><\/FONT><\/FONT><\/P>
\n

SQL> shutdown immediate<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ vi $ORACLE_HOME\/dbs\/initTECH.ora<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ vi cre_con.sql <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> @cre_con.sql<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> recover database using controlfile until cancel<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter database open resetlogs;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> select dbid, name, open_mode, activation#, created from v$database;<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

 <\/FONT><\/SPAN><\/P>
\n

 <\/P><\/o:p><\/p>\n","protected":false},"excerpt":{"rendered":"

DB Name \ubcc0\uacbd \uc808\ucc28 – \ucc38\uc870 \ubb38\uc11c (How to Change the DBID and the DBNAME by using NID (\ubb38\uc11c ID 224266.1), How to Rename Database\/Change DB_NAME or ORACLE_SID\/Instance Name (\ubb38\uc11c ID 15390.1))                                i.         NID \uc0ac\uc6a9 \u2460    \uc791\uc5c5\uc744 \ud558\uae30 \uc804\uc5d0 Backup \uc744 \ubc1b\uc544 \ub193\ub294\ub2e4. \u2461    db_name \ubcc0\uacbd\uc744 \uc704\ud55c pfile (initSID) \uc0dd\uc131 \u2462    […]<\/p>\n","protected":false},"author":1,"featured_media":994,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[531,532],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile3.uf.2442AE3F568472B2039986.jpg?fit=465%2C422&ssl=1","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/993"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=993"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/993\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/994"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}