{"id":1000,"date":"2015-12-31T00:53:45","date_gmt":"2015-12-31T00:53:45","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1000"},"modified":"2015-12-31T00:53:45","modified_gmt":"2015-12-31T00:53:45","slug":"datafile-%ea%b2%bd%eb%a1%9c-%eb%b3%80%ea%b2%bd-%ec%a0%88%ec%b0%a8online-offline-file-system-asm","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1000","title":{"rendered":"Datafile \uacbd\ub85c \ubcc0\uacbd \uc808\ucc28(online, offline) File system, ASM"},"content":{"rendered":"

  <\/FONT><\/STRONG>   <\/SPAN><\/SPAN><\/SPAN><\/B>Datafile <\/SPAN><\/B>\uacbd\ub85c \ubcc0\uacbd \uc808\ucc28(online, offline) File system, ASM<\/SPAN><\/SPAN><\/B><\/FONT><\/P>
\n

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

(<\/SPAN><\/B>How to Rename or Move Datafiles and Logfiles (<\/SPAN><\/B>\ubb38\uc11c ID 115424.1),<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

How to move a datafile from a file system to ASM (<\/SPAN><\/B>\ubb38\uc11c ID 390274.1)<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

How to move ASM database files from one diskgroup to another ? (<\/SPAN><\/B>\ubb38\uc11c ID 330103.1))<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

\u00b2<\/FONT>  <\/SPAN><\/SPAN><\/SPAN>Datafile <\/SPAN>\uacbd\ub85c \ubc0f \uc774\ub984 \ubcc0\uacbd \uc2dc\uc5d0 \uac00\uc7a5 \uc911\uc694\ud55c point <\/SPAN>\ub294 Online\/Offline <\/SPAN>\uc5ec\ubd80\uc774\ub2e4.<\/SPAN><\/FONT><\/FONT><\/P>
\n

SYSTEM <\/SPAN>\uc774\ub098 SYSAUX<\/SPAN>\ub97c \ubcc0\uacbd\ud558\uae30 \uc704\ud574\uc11c\ub294 \ud544\ud788 Shutdown <\/SPAN>\uc774 \ud544\uc694\ud558\uace0 \uc774\uc678\uc758 Datafile <\/SPAN>\uc740 Online <\/SPAN>\uacfc Offline <\/SPAN>\ubaa8\ub450 \uac00\ub2a5\ud558\ub2e4.<\/SPAN><\/FONT><\/FONT><\/P>
\n

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

A.<\/FONT>     <\/SPAN><\/SPAN><\/SPAN>OPEN <\/SPAN>\uc0c1\ud0dc\uc5d0\uc11c Rename<\/SPAN><\/FONT><\/FONT><\/P>
\n

                         <\/SPAN>i.<\/FONT>         <\/SPAN><\/SPAN><\/SPAN>File system<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2460<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\ud604\uc7ac Datafile <\/SPAN>\uc704\uce58\uc640 \uc0c1\ud0dc \ud655\uc778<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2461<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>tablespace <\/SPAN>\ub97c read only <\/SPAN>\uc0c1\ud0dc\ub85c \ubcc0\uacbd(service <\/SPAN>\uc2dc\uac04 \ucd5c\ub300\ud654\ub97c \uc704\ud574)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uae30\uc874 \uacbd\ub85c\uc758 datafile <\/SPAN>\uc744 \uc0c8 \uacbd\ub85c\uc5d0 copy<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>tablespace <\/SPAN>\ub97c offline <\/SPAN>\uc0c1\ud0dc\ub85c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2464<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>tablespace Rename (<\/SPAN>\ub450\uac00\uc9c0 syntax <\/SPAN>\ubaa8\ub450 \uac00\ub2a5)<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2465<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>tablespace online <\/SPAN>\uc0c1\ud0dc\ub85c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2466<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>tablespace read write <\/SPAN>\uc0c1\ud0dc\ub85c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2467<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uc0c8\ub85c \ubcc0\uacbd\ud55c \uad6c\uc870\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574 control file trace file <\/SPAN>\ub85c backup<\/SPAN><\/FONT><\/FONT><\/P>
\n

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

\u2468<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uae30\uc874 \uacbd\ub85c\uc758 datafile <\/SPAN>\uc0ad\uc81c<\/SPAN><\/FONT><\/FONT><\/P>
\n
\n
\n
\n

\n

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


\n

SQL> select file_name, status from dba_data_files<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

where tablespace_name=\u2019EXAMPLES\u2019;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter tablespace EXAMPLES read only;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> select tablespace_name, status from dba_tablespaces;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

$ cp \/u01\/oradata\/example.dbf \/oradata\/datafile\/example.dbf<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter tablespace EXAMPLE offline;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter database rename file <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\u2018\/u01\/oradata\/example.dbf\u2019 to \u2018\/oradata\/datafile\/example.dbf\u2019<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\ub610\ub294<\/SPAN><\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter tablespace EXAMPLE rename datafile <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\u2018\/u01\/oradata\/example.dbf\u2019 to \u2018\/oradata\/datafile\/example.dbf\u2019<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter tablespace EXAMPLE online;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter tablespace EXAMPLE read write;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

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

$ rm \/u01\/oradata\/example.dbf<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

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

                        <\/SPAN>ii.<\/FONT>         <\/SPAN><\/SPAN><\/SPAN>ASM<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2460<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>move <\/SPAN>\ud560 datafile <\/SPAN>\uacbd\ub85c \ud655\uc778 \ud6c4 <\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2461<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>move <\/SPAN>\ud560 datafile <\/SPAN>\uc758 diskgroup <\/SPAN>\ud655\uc778<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Tablespace offline <\/SPAN>\uc0c1\ud0dc\ub85c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uac00) DBMS_FILE_TRANSFER Package <\/SPAN>\uc774\uc6a9 \ud574\uc11c \uc218\ud589<\/SPAN><\/FONT><\/FONT><\/P>
\n

\ub098) RMAN <\/SPAN>\uc744 \uc774\uc6a9 \ud574\uc11c \uc218\ud589<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2464<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Datafile Recover<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2465<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Tablespace Online <\/SPAN>\uc0c1\ud0dc\ub85c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2466<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Rename <\/SPAN>\ud55c \uc704\uce58 \ud655\uc778<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2467<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uae30\uc874 \uc704\uce58\uc758 datafile <\/SPAN>\uc0ad\uc81c<\/SPAN><\/FONT><\/FONT><\/P>
\n
\n
\n
\n

\n

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


\n

SQL> select file_name from dba_data_files;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> select group_number, name from v$asm_diskgroup; (ASM Instance)<\/SPAN><\/B><\/SPAN><\/FONT><\/FONT><\/P>
\n

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

\u2018<\/SPAN>+ASMDISK2\/tech\/datafile\/users.256.565313\u2019 offline;<\/SPAN><\/B><\/SPAN><\/FONT><\/FONT><\/P>
\n

l<\/FONT>  <\/SPAN><\/SPAN><\/SPAN>DBMS_FILE_TRANSFER Package <\/SPAN>\uc774\uc6a9<\/B><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

SQL> create or replace directory tech1 as \u2018+ASMDISK1\/tech\/datafile\u2019;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter disgroup ASMDISK2 add directory \u2018+ASMDISK2\/test\u2019; <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

(ASM Instance)<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> create or replace directory tech2 as \u2018+ASMDISK2\/test\u2019;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> begin<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

DBMS_FILE_TRANSFER.COPY_FILE(<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

source_directory_object => \u2018TECH1\u2019,<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

source_file_name => \u2018USERS. users.256.565313\u2019,<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

destination_directory_object => \u2018TECH2\u2019,<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

destination_file_name => \u2018UGERS01.DBF\u2019);<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

END;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter database rename file <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\u2018+ASMDISK2\/tech\/datafile\/ users.256.565313\u2019 <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

to \u2018+ASMDISK1\/tech\/datafile\/ users.256.565313\u2019;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

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

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

l<\/FONT>  <\/SPAN><\/SPAN><\/SPAN>RMAN <\/SPAN><\/B>\uc744 \uc774\uc6a9<\/SPAN><\/SPAN><\/B><\/FONT><\/FONT><\/P>
\n

RMAN> copy datafile <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\u2018+ASMDISK2\/tech\/datafile\/users.256.565313\u2019 to  <\/SPAN>\u2018+ASMDISK1\u2019;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

RMAN> run { set newname for datafile <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\u2018+ASMDISK2\/tech\/datafile\/ users.256.565313\u2019<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

to \u2018+ASMDISK1\/tech\/datafile\/ users.256.565313\u2019;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

switch datafile all; }<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

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

SQL> recover datafile \u2018+ASMDISK1\/tech\/datafile\/ users.256.565313\u2019<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

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

\u2018+ASMDISK1\/tech\/datafile\/ users.256.565313\u2019 online<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> select file_name from dba_data_files;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter diskgroup ASMDISK2 drop file users.256.565313; <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

(ASM Instance)<\/SPAN><\/B><\/SPAN><\/B><\/FONT><\/FONT><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

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

B.<\/FONT>      <\/SPAN><\/SPAN><\/SPAN>Shutdown <\/SPAN>\uc0c1\ud0dc\uc5d0\uc11c Rename<\/SPAN><\/FONT><\/FONT><\/P>
\n

                         <\/SPAN>i.<\/FONT>         <\/SPAN><\/SPAN><\/SPAN>File system<\/FONT><\/FONT><\/SPAN><\/P>
\n

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

\u2461<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uae30\uc874 \uacbd\ub85c\uc758 datafile <\/SPAN>\uc744 \uc0c8 \uacbd\ub85c\uc5d0 copy<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Database Mount<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Datafile Rename<\/FONT><\/FONT><\/SPAN><\/P>
\n

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

\u2465<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uae30\uc874 \uacbd\ub85c\uc758 datafile <\/SPAN>\uc0ad\uc81c<\/SPAN><\/FONT><\/FONT><\/P>
\n
\n
\n
\n

\n

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


\n

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

$ cp \/u01\/oracle\/oradata\/system01.dbf \/oradata\/system01.dbf<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> startup mount<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

SQL> alter database rename file <\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

\u2018\/u01\/oracle\/oradata\/system01.dbf\u2019 to \u2018\/oradata\/system01.dbf;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

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

$ rm \/u01\/oracle\/oradata\/system01.dbf<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

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

                        <\/SPAN>ii.<\/FONT>         <\/SPAN><\/SPAN><\/SPAN>ASM<\/FONT><\/FONT><\/SPAN><\/P>
\n

\u2460<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>\uc0c8\ub85c\uc6b4 \uacbd\ub85c\uc5d0 Copy <\/SPAN>\ubcf8 \uc0dd\uc131<\/SPAN><\/FONT><\/FONT><\/P>
\n

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

\u2462<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Copy <\/SPAN>\ud574 \ub193\uc740 file <\/SPAN>\ub85c \ubcc0\uacbd<\/SPAN><\/FONT><\/FONT><\/P>
\n

\u2463<\/FONT>    <\/SPAN><\/SPAN><\/SPAN>Database recover<\/FONT><\/FONT><\/SPAN><\/P>
\n

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

\n

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


\n

RMAN> backup as copy tablespace system format \u2018<\/SPAN>\uc0c8\ub85c\uc6b4 \uacbd\ub85c\u2019;<\/SPAN><\/FONT><\/FONT><\/B><\/P>
\n

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

RMAN> startup mount<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

RMAN> switch tablespace system to copy;<\/FONT><\/FONT><\/SPAN><\/B><\/P>
\n

RMAN> recover database;<\/FONT><\/FONT><\/SPAN><\/B><\/P><\/TD><\/TR><\/TBODY><\/TABLE>
\n

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

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

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

     Datafile \uacbd\ub85c \ubcc0\uacbd \uc808\ucc28(online, offline) File system, ASM \ucc38\uc870\ubb38\uc11c (How to Rename or Move Datafiles and Logfiles (\ubb38\uc11c ID 115424.1), How to move a datafile from a file system to ASM (\ubb38\uc11c ID 390274.1) How to move ASM database files from one diskgroup to another ? (\ubb38\uc11c ID 330103.1)) \u00b2  Datafile \uacbd\ub85c \ubc0f […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[537,538],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1000"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1000"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1000\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1000"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}