{"id":4872,"date":"2023-04-20T10:30:14","date_gmt":"2023-04-20T01:30:14","guid":{"rendered":"http:\/\/oracledba.zapto.org\/wordpress\/?p=4872"},"modified":"2023-04-20T11:11:45","modified_gmt":"2023-04-20T02:11:45","slug":"db-migration-using-tts","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4872","title":{"rendered":"DB Migration Using TTS"},"content":{"rendered":"

==============================================================================================<\/p>\n

\uc21c\uc11c<\/span><\/p>\n

\u00a0<\/span><\/p>\n

1.CRS \ubc0f Oracle install<\/strong><\/span><\/p>\n

1.1.CRS requirement<\/span><\/p>\n

1.1.1.OS requirement
\n1.1.2.Oracle requirement
\n1.1.3.CRS install & Oracle install<\/span><\/p>\n

2.To IBM From HP<\/strong><\/span><\/p>\n

2.1.Pre-Migration Check(HP)<\/span><\/p>\n

2.1.1.HP \uc11c\ubc84\uc758 TTS \ub300\uc0c1 Tablespace \ud655\uc778
\n2.1.2.TTS \ub300\uc0c1 Tablespace \uc758 Violation Check<\/span><\/p>\n

2.2.TTS Migration On HP<\/span><\/p>\n

2.2.1.Tablespace Read Only \ubcc0\uacbd
\n2.2.2.TTS \uc774\uc804\uc744 \uc704\ud55c Meta Data Export \uc2e4\ud589
\n2.2.3.TTS plug-in \ud6c4 object \uc0dd\uc131\uc6a9 norows Export \uc2e4\ud589
\n2.2.4.Oracle datafile copy<\/span><\/p>\n

2.3.TTS Migration On IBM<\/span><\/p>\n

2.3.1.\uc784\uc2dc Tablespace \uc0dd\uc131
\n2.3.2.TSD_PROD_IMSI Tablespace \uc0dd\uc131
\n2.3.3.TTS \ub300\uc0c1 \uc720\uc800 \uc0dd\uc131
\n2.3.4.Meta Data Import \uc2e4\ud589
\n2.3.5.Tablespace Read-Write \ubaa8\ub4dc\ub85c \ubcc0\uacbd<\/span><\/p>\n

2.4.TTS Migration \ub9c8\ubb34\ub9ac<\/span><\/p>\n

2.4.1.\uc720\uc800\uc815\ubcf4 \ubcc0\uacbd
\n2.4.2.TTS \uc81c\uc57d\uc0ac\ud56d Object \ub4f1\ub85d<\/span><\/p>\n

3.Tablespace Re-Org<\/strong><\/span><\/p>\n

3.1.LOB Table Move<\/span><\/p>\n

3.1.1.TSD_PROD Rename To LOB_DATA
\n3.1.2.TSD_PROD_IMSI Rename To TSD_PROD
\n3.1.3.TSI_PROD_IMG01 Tabelspace Re-size
\n3.1.4.LOB_DATA \uc77c\ubc18\ud14c\uc774\ube14\uc744 TSD_PROD \ub85c \uc774\uc804<\/span><\/p>\n

3.2.Long Table Move<\/span><\/p>\n

3.2.1.long type export
\n3.2.2.drop long type table
\n3.2.3.create long type table(tablespace \ubcc0\uacbd)
\n3.2.4.long type import<\/span><\/p>\n

3.3.Partition Table Move<\/span><\/p>\n

3.3.1.LOB_DATA \uc5d0 \uc874\uc7ac\ud558\ub294 partition \ud14c\uc774\ube14 TSD_PROD \ub85c \uc774\uc804<\/span><\/p>\n

3.4.Tablespace Re-Org \ub9c8\ubb34\ub9ac<\/span><\/p>\n

3.4.1.logging, noparallel \uc124\uc815
\n3.4.2.\ucd5c\uc885 \uad8c\ud55c \uc124\uc815 <\/span><\/p>\n

\u00a0<\/span><\/p>\n

=====================================================================================<\/span><\/p>\n

1.CRS\ubc0f Oracle install<\/span><\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0 1.1. CRS requirement<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.1.OS requirement<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.1.1 \/etc\/hosts<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.1.2 dba, Oracle user add<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.1.3 file descriptor \ubcc0\uacbd<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.1.4 Network tunning parameter \ubcc0\uacbd<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.1.5 CRS \uc6a9 vote,crs raw device \uc0dd\uc131 \ubc0f permission \ubcc0\uacbd<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.2. Oracle requirement<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.2.1 Oracle \ud658\uacbd\ubcc0\uc218 \uc124\uc815<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.1.3.CRS install & Oracle install
\n1.1.2.1 CRS install\u00a0 (\ud55c\ucabd \ub178\ub4dc\uc5d0\uc11c\ub9cc \uc218\ud589, oracle user)<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\"image\"<\/span><\/a><\/p>\n

1.1.2.2 Oracle S\/W install (\ud55c\ucabd \ub178\ub4dc\uc5d0\uc11c\ub9cc
\n\uc218\ud589, oracle user)<\/span><\/p>\n

\"image\"<\/span><\/a><\/p>\n

\"image\"<\/span><\/a><\/p>\n

 <\/p>\n

2<\/span>.To IBM From HP<\/span><\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0 2.1.Pre-Migration Check(HP)<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.1.1.HP \uc11c\ubc84\uc758 TTS \ub300\uc0c1 Tablespace \ud655\uc778<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ( Oracle 10g \uc5d0\uc11c\ub294 system, undotbs, sysaux, temp \ub294 TTS \uc758 \uae30\ub2a5\uc73c\ub85c \uc774\uc804\uc774 \ubd88\uac00\ub2a5 \ud568)<\/span><\/strong><\/p>\n


\nSYS>select name from v$tablespace;
\nNAME
\n——————————
\nSYSTEM
\nUNDOTBS1
\nSYSAUX
\nUNDOTBS2
\nUSERS
\nTSD_COMM
\nTSD_MARKET
\nTSD_PROD
\nTSD_TRADE
\nTSD_TNS
\nTSD_MEMBER
\nTSD_SYS
\nTSD_TANAL
\nCYBER_DATA
\nTBS_TINSP_DAT
\nTSI_COMM
\nTSI_PROD
\nTSI_TRADE
\n….
\n<\/span><\/p><\/blockquote>\n

2.1.2.TTS \ub300\uc0c1 Tablespace \uc758 Violation Check<\/strong><\/span><\/p>\n


\nSQL> exec dbms_tts.transport_set_check<\/strong>( ‘TSD_COMM, TSD_MARKET, TSD_PROD,
\nTSD_TRADE, TSD_TNS, TSD_MEMBER, TSD_SYS, TSD_TANAL, CYBER_DATA,
\nTBS_TINSP_DAT, TSI_COMM, TSI_PROD, TSI_TRADE, TSI_TNS, TSI_MEMBER, TSI_SYS,
\nTSI_TANAL, CYBER_INDX, TBS_TINSP_IDX, TSD_MPV2, TSI_MPV2, TSD_SHPLNK,
\nTSI_SHPLNK, TSI_PROD_01, TSI_MARKET, TSD_2K_BLOCK, TSI_2K_BLOCK,
\nTSD_PROD_02, TSI_PROD_02, TSI_PROD_03, TSI_PROD_IMG_01, TSI_CUPN_01,
\nTSD_AMAIL, TSI_AMAIL, TSD_LIVEPROD, TSI_LIVEPROD, TPA_TS’,TRUE);
\nPL\/SQL procedure successfully completed.<\/span><\/p><\/blockquote>\n


\n\u25b2 TTS \ub300\uc0c1 \uc720\uc800\uc758 object \uac00 TTS \uc81c\uc678 \ub300\uc0c1\uc758 Tablespace \uc5d0 \ud3ec\ud568\ub41c \uacbd\uc6b0\ub294 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd!<\/span><\/strong><\/p>\n


\nSQL> select * from sys.transport_set_violation;<\/strong><\/span><\/p>\n

no rows selected<\/span><\/p><\/blockquote>\n

\u00a0<\/span><\/p>\n

2.2.TTS Migration On HP<\/span><\/p>\n

\u00a0\u00a0\u00a0\u00a0 2.2.1.Tablespace Read Only \ubcc0\uacbd<\/span><\/p>\n

SQL> alter tablespace USERS read only;
\nSQL> alter tablespace TSD_COMM read only;
\nSQL> alter tablespace TSD_MARKET read only;
\nSQL> alter tablespace TSD_PROD read only;
\nSQL> alter tablespace TSD_TRADE read only;
\nSQL> alter tablespace TSD_TNS read only;
\nSQL> alter tablespace TSD_MEMBER read only;
\nSQL> alter tablespace TSD_SYS read only;
\nSQL> alter tablespace TSD_TANAL read only;
\nSQL> alter tablespace CYBER_DATA read only;
\nSQL> alter tablespace TBS_TINSP_DAT read only;
\nSQL> alter tablespace TSI_COMM read only;
\nSQL> alter tablespace TSI_PROD read only;
\nSQL> alter tablespace TSI_TRADE read only;
\nSQL> alter tablespace TSI_TNS read only;
\nSQL> alter tablespace TSI_MEMBER read only;
\nSQL> alter tablespace TSI_SYS read only;
\nSQL> alter tablespace TSI_TANAL read only;
\nSQL> alter tablespace CYBER_INDX read only;
\nSQL> alter tablespace TBS_TINSP_IDX read only;
\nSQL> alter tablespace TSD_MPV2 read only;
\nSQL> alter tablespace TSI_MPV2 read only;
\nSQL> alter tablespace TSD_SHPLNK read only;
\n….<\/span><\/p><\/blockquote>\n

\u00a0<\/span><\/p>\n

\u25b2 Tablespace \ubcc0\uacbd \ud6c4\uc5d0 \uc815\uc0c1\uc801\uc73c\ub85c \ubcc0\uacbd\uc774 \ub418\uc5c8\ub294\uc9c0 alert \ub85c\uadf8\ud30c\uc77c\uc744 \ud1b5\ud574\uc11c \ud655\uc778 !!!<\/span><\/strong><\/p>\n

\u00a0<\/span><\/p>\n

SQL> select tablespace_name, status from dba_tablespaces;
\nTABLESPACE_NAME STATUS
\n—————————— ———
\nSYSTEM ONLINE
\nUNDOTBS1 ONLINE
\nSYSAUX ONLINE
\nUNDOTBS2 ONLINE
\nUSERS READ ONLY
\nTSD_COMM READ ONLY
\nTSD_MARKET READ ONLY
\nTSD_PROD READ ONLY
\nTSD_TRADE READ ONLY
\nTSD_TNS READ ONLY
\nTSD_MEMBER READ ONLY
\nTSD_SYS READ ONLY
\nTSD_TANAL READ ONLY
\nCYBER_DATA READ ONLY
\nTBS_TINSP_DAT READ ONLY
\nTSI_COMM READ ONLY
\nTSI_PROD READ ONLY
\nTSI_TRADE READ ONLY
\nTSI_TNS READ ONLY
\nTSI_MEMBER READ ONLY
\nTSI_SYS READ ONLY
\nTSI_TANAL READ ONLY
\nCYBER_INDX READ ONLY
\nTBS_TINSP_IDX READ ONLY
\nTSD_MPV2 READ ONLY<\/span><\/p>\n

….
\n<\/span><\/p><\/blockquote>\n

 <\/p>\n

2.2.2. TTS \uc774\uc804\uc744 \uc704\ud55c Meta Data Export \uc2e4\ud589<\/p>\n

exp \\’sys\/oracle as sysdba\\’ file=meta.dmp log=meta.log transport_tablespace=y
\ntablespaces=USERS, TSD_COMM, TSD_MARKET, TSD_PROD, TSD_TRADE, TSD_TNS,
\nTSD_MEMBER, TSD_SYS, TSD_TANAL, CYBER_DATA, TBS_TINSP_DAT, TSI_COMM,
\nTSI_PROD, TSI_TRADE, TSI_TNS, TSI_MEMBER, TSI_SYS, TSI_TANAL, CYBER_INDX,TBS_TINSP_IDX, TSD_MPV2, TSI_MPV2, TSD_SHPLNK, TSI_SHPLNK, TSI_PROD_01,
\nTSI_MARKET, TSD_2K_BLOCK, TSI_2K_BLOCK, TSD_PROD_02, TSI_PROD_02,
\nTSI_PROD_03, TSI_PROD_IMG_01, SI_CUPN_01, TSD_AMAIL, TSI_AMAIL, TSD_LIVEPROD,
\nTSI_LIVEPROD, TPA_TS buffer=20480000<\/p><\/blockquote>\n

 <\/p>\n

2.2.3. TTS plug-in \ud6c4object \uc0dd\uc131\uc6a9 norows Export \uc2e4\ud589<\/p>\n

exp system\/oracle#ora2 file=rows_n.dmp log=rows_n.log full=y rows=n buffer=10240000<\/p>\n

 <\/p><\/blockquote>\n

2.2.4. Oracle datafile copy<\/p>\n

remsh(rsh) & dd \uba85\ub839\uc5b4\ub97c \ud1b5\ud55c HP \uc11c\ubc84\uc5d0\uc11c IBM \uc73c\ub85c\uc758 rawdevice copy IBM \ucabd rawdevice \ub294 dd \uc2e4\ud589\uc804 \uc0dd\uc131\uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/p>\n

200 \uac1c\uc758 rawdevice \ub97c 8 \uac1c\uc758 \uae30\uac00\ube44\ud2b8\ub77c\uc778(\ub178\ub4dc\ub2f9 4 \uac1c)\uacfc \uac01 \ub77c\uc778\uc5d0 \ud574\ub2f9\ud558\ub294 script \uc791\uc131<\/p>\n

 <\/p>\n

\u25b2 I\/O \ubcd1\ubaa9\uc0c1\ud0dc \uc81c\uac70 \uc2dc\uac04 \ub2e8\ucd95\uc744 \uc704\ud574 IP\ubd80\uc5ec\ud55c\u00a0 \ub79c\uce74\ub4dc 8\uc7a5 2 node RAC 1 \uc11c\ubc84\ub2f9 4\uc7a5 \uc529 \ubcd1\ub82c dd \uce74\ud53c <\/span><\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/p>\n

<1node 1script><\/span><\/p>\n

dd if=\/dev\/vg07\/rlvol19 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol19
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol20 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol20
\nbs=8192k” &
\ndd if=\/dev\/vg01\/rlvol32 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg01_rlvol32
\nbs=8192k”
\ndd if=\/dev\/vg20\/rlvol10 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg20_rlvol10
\nbs=8192k” &
\ndd if=\/dev\/vg20\/rlvol14 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg20_rlvol14
\nbs=8192k” &
\ndd if=\/dev\/vg20\/rlvol17 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg20_rlvol17
\nbs=8192k”<\/span><\/p>\n

dd if=\/dev\/vg22\/rlvol32 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg22_rlvol32
\nbs=8192k” &
\ndd if=\/dev\/vg22\/rlvol10 bs=8192k | remsh 110.110.110.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg22_rlvol10
\nbs=8192k” &<\/p>\n

 <\/p>\n

\u2026\u2026<\/p><\/blockquote>\n

<1node 2script>
\ndd if=\/dev\/vg07\/rlvol11 bs=8192k | remsh 110.110.111.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol11
\nbs=8192k” &
\ndd if=\/dev\/vg03\/rlvol3 bs=8192k | remsh 110.110.111.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg03_rlvol3
\nbs=8192k” &
\ndd if=\/dev\/vg14\/rlvol2 bs=8192k | remsh 110.110.111.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg14_rlvol2
\nbs=8192k”
\ndd if=\/dev\/vg16\/rlvol14 bs=8192k | remsh 110.110.111.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg16_rlvol14
\nbs=8192k” &
\ndd if=\/dev\/vg22\/rlvol11 bs=8192k | remsh 110.110.111.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg22_rlvol11
\nbs=8192k” &
\ndd if=\/dev\/vg22\/rlvol2 bs=8192k | remsh 110.110.111.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg22_rlvol2
\nbs=8192k”<\/span><\/p>\n

\u2026…<\/span><\/p>\n

<1node 3script><\/span><\/p>\n

dd if=\/dev\/vg02\/rlvol3 bs=8192k | remsh 110.110.112.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg02_rlvol3
\nbs=8192k” &
\ndd if=\/dev\/vg04\/rlvol3 bs=8192k | remsh 110.110.112.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg04_rlvol3bs=8192k” &
\ndd if=\/dev\/vg07\/rlvol16 bs=8192k | remsh 110.110.112.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol16
\nbs=8192k”
\ndd if=\/dev\/vg07\/rlvol3 bs=8192k | remsh 110.110.112.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol3
\nbs=8192k” &
\ndd if=\/dev\/vg10\/rlvol1 bs=8192k | remsh 110.110.112.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg10_rlvol1
\nbs=8192k” &
\ndd if=\/dev\/vg11\/rlvol1 bs=8192k | remsh 110.110.112.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg11_rlvol1
\nbs=8192k” & <\/span><\/p>\n

\u2026\u2026<\/span><\/p><\/blockquote>\n

<1node 4script>
\ndd if=\/dev\/vg07\/rlvol21 bs=8192k | remsh 110.110.113.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol21
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol17 bs=8192k | remsh 110.110.113.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol17
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol18 bs=8192k | remsh 110.110.113.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol18
\nbs=8192k”
\ndd if=\/dev\/vg03\/rlvol1 bs=8192k | remsh 110.110.113.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg03_rlvol1
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol4 bs=8192k | remsh 110.110.113.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol4
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol6 bs=8192k | remsh 110.110.113.2 “\/usr\/bin\/dd of=\/dev\/rtd_vg07_rlvol6
\nbs=8192k” &<\/p>\n

\u2026\u2026.\uc911\ub7b5<\/p>\n

<2node 1script>
\ndd if=\/dev\/vg16\/rlvol17 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg16_rlvol17
\nbs=8192k” &
\ndd if=\/dev\/vg23\/rlvol10 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg23_rlvol10
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol14 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol14
\nbs=8192k”
\ndd if=\/dev\/vg17\/rlvol7 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol7
\nbs=8192k” &
\ndd if=\/dev\/vg08\/rlvol1 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg08_rlvol1
\nbs=8192k” &
\ndd if=\/dev\/vg08\/rlvol5 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg08_rlvol5
\nbs=8192k” &
\ndd if=\/dev\/vg15\/rlvol7 bs=8192k | remsh 120.120.120.2 “\/usr\/bin\/dd of=\/dev\/rti_vg15_rlvol7
\nbs=8192k” &<\/span><\/p>\n

\u2026\u2026.\uc911\ub7b5<\/p>\n

<2node 2script>
\ndd if=\/dev\/vg15\/rlvol4 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg15_rlvol4
\nbs=8192k” &
\ndd if=\/dev\/vg21\/rlvol15 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg21_rlvol15
\nbs=8192k” &
\ndd if=\/dev\/vg08\/rlvol12 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg08_rlvol12
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol2 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol2
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol16 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol16
\nbs=8192k” &
\ndd if=\/dev\/vg14\/rlvol9 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg14_rlvol9
\nbs=8192k” &
\ndd if=\/dev\/vg21\/rlvol11 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg21_rlvol11
\nbs=8192k” &
\ndd if=\/dev\/vg21\/rlvol2 bs=8192k | remsh 120.120.121.2 “\/usr\/bin\/dd of=\/dev\/rti_vg21_rlvol2
\nbs=8192k” &<\/p>\n

\u2026\u2026\u2026.\uc911\ub7b5<\/p>\n

<2node 3script>
\ndd if=\/dev\/vg05\/rlvol4 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg05_rlvol4
\nbs=8192k” &
\ndd if=\/dev\/vg12\/rlvol6 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg12_rlvol6
\nbs=8192k” &
\ndd if=\/dev\/vg23\/rlvol16 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg23_rlvol16
\nbs=8192k”
\ndd if=\/dev\/vg13\/rlvol1 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg13_rlvol1
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol9 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol9
\nbs=8192k” &
\ndd if=\/dev\/vg12\/rlvol4 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg12_rlvol4
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol12 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol12
\nbs=8192k” &
\ndd if=\/dev\/vg15\/rlvol5 bs=8192k | remsh 120.120.122.2 “\/usr\/bin\/dd of=\/dev\/rti_vg15_rlvol5
\nbs=8192k” &<\/p>\n

\u2026\u2026\u2026\uc911\ub7b5<\/p>\n

<2node 4script>
\ndd if=\/dev\/vg07\/rlvol31 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg07_rlvol31
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol24 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg07_rlvol24
\nbs=8192k” &
\ndd if=\/dev\/vg07\/rlvol27 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg07_rlvol27
\nbs=8192k”
\ndd if=\/dev\/vg07\/rlvol29 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg07_rlvol29
\nbs=8192k” &
\ndd if=\/dev\/vg12\/rlvol1 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg12_rlvol1
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol17 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol17
\nbs=8192k”
\ndd if=\/dev\/vg13\/rlvol5 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg13_rlvol5
\nbs=8192k” &
\ndd if=\/dev\/vg13\/rlvol2 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg13_rlvol2
\nbs=8192k” &
\ndd if=\/dev\/vg17\/rlvol15 bs=8192k | remsh 120.120.123.2 “\/usr\/bin\/dd of=\/dev\/rti_vg17_rlvol15
\nbs=8192k” &<\/p>\n

\u2026\u2026.\uc911\ub7b5<\/p>\n

 <\/p><\/blockquote>\n

2.3.TTS Migration On IBM<\/strong><\/p>\n

2.3.1.\uc784\uc2dc Tablespace \uc0dd\uc131<\/p>\n

TTS \uc9c4\ud589\uc2dc\uc5d0 \uc4f0\uc5ec\uc9c0\ub294 \uc784\uc2dc \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131(Tablespace \uba85: TTS)<\/p>\n

SQL> create tablespace TTS datafile ‘\/dev\/rdata04_01’ size 100m;<\/p>\n

alter database default tablespace TTS;<\/p><\/blockquote>\n

 <\/p>\n

2.3.2.TSD_PROD_IMSI Tablespace \uc0dd\uc131<\/p>\n

Re-Org \uc9c4\ud589\uc2dc TSD_PROD \ub85c \ubcc0\uacbd\ub420 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131<\/p>\n

(\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ud06c\uae30\uac00 \ud06c\uae30 \ub54c\ubb38\uc5d0 \uc0ac\uc804\uc5d0 \ubbf8\ub9ac \uc0dd\uc131)<\/p>\n

SQL> create tablespace TSD_PROD_IMSI datafile
\n‘\/dev\/rdata16_01’ size 16000M,
\n‘\/dev\/rdata16_02’ size 16000M,
\n‘\/dev\/rdata16_03’ size 16000M,
\n‘\/dev\/rdata16_04’ size 16000M,
\n‘\/dev\/rdata16_05’ size 16000M,
\n‘\/dev\/rdata16_06’ size 16000M,
\n‘\/dev\/rdata16_07’ size 16000M,
\n‘\/dev\/rdata16_08’ size 16000M,
\n‘\/dev\/rdata16_09’ size 16000M,
\n‘\/dev\/rdata16_10’ size 16000M,
\n‘\/dev\/rdata16_11’ size 16000M,
\n‘\/dev\/rdata16_12’ size 16000M,
\n‘\/dev\/rdata16_13’ size 16000M,
\n‘\/dev\/rdata16_14’ size 16000M,
\n‘\/dev\/rdata16_15’ size 16000M,
\n‘\/dev\/rdata16_16’ size 16000M,
\n‘\/dev\/rdata16_17’ size 16000M,
\n‘\/dev\/rdata16_18’ size 16000M,
\n‘\/dev\/rdata16_19’ size 16000M,
\n‘\/dev\/rdata16_20’ size 16000M;<\/p><\/blockquote>\n

 <\/p>\n

2.3.3. TTS \ub300\uc0c1 \uc720\uc800 \uc0dd\uc131<\/p>\n

\ubaa8\ub4e0 \uc720\uc800\uac00 \ub300\uc0c1\uc774 \ub418\uae30 \ub54c\ubb38\uc5d0 \uc544\ub798\uc640 \uac19\uc774 \uc0dd\uc131<\/p>\n

TTS \uc644\ub8cc\uc804\uc5d0\ub294 \uc544\ub798\uc640 \uac19\uc774 \ubaa8\ub4e0 \uc720\uc800\uc758 default tablespace \ub97c TTS \ub85c \uc124\uc815<\/p>\n

SQL> create user MPV2 identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user TANALADMIN identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user INSPADMIN identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user TANAL identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user SVCOP identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user SVCADMIN identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user SVCMCHT identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user TPA identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user AMAILADMIN identified by oracle default tablespace TTS temporary tablespace temp;
\nSQL> create user SHOPLINKER identified by oracle default tablespace TTS temporary tablespace temp;<\/p>\n

\u2026\u2026..<\/p><\/blockquote>\n

 <\/p>\n

2.3.4. Meta Data Import \uc2e4\ud589<\/p>\n

HP \uc11c\ubc84\uc5d0\uc11c \uc2e4\ud589\ub41c datafile copy \uac00 \uc885\ub8cc\ub418\uba74 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\uc774 \ub418\uc5c8\ub294\uc9c0 \ud655\uc778 \ud6c4\uc5d0 \uc544\ub798\uc640 \uac19\uc774 meta data \ub97c import \ud55c\ub2e4.<\/p>\n

 <\/p>\n

$:> imp parfile=meta.parfile<\/p>\n

=======meta.parfile =========
\nUSERID=’sys\/oracle as sysdba’
\nfile=meta.dmp
\nlog=meta_imp.log
\ntransport_tablespace=y
\nbuffer=102400000
\nignore=y
\ndatafiles=(
\n‘\/dev\/rtd_vg07_rlvol19’,
\n‘\/dev\/rtd_vg07_rlvol20’,
\n‘\/dev\/rtd_vg01_rlvol32’,
\n‘\/dev\/rtd_vg20_rlvol10’,
\n‘\/dev\/rtd_vg20_rlvol14’,
\n‘\/dev\/rtd_vg20_rlvol17’,
\n‘\/dev\/rtd_vg21_rlvol16’,
\n‘\/dev\/rtd_vg20_rlvol4’,
\n‘\/dev\/rtd_vg20_rlvol8’,
\n‘\/dev\/rtd_vg20_rlvol20’,
\n‘\/dev\/rtd_vg22_rlvol18’,
\n‘\/dev\/rtd_vg22_rlvol1’,
\n‘\/dev\/rtd_vg22_rlvol32’,
\n‘\/dev\/rtd_vg22_rlvol10’,
\n‘\/dev\/rtd_vg22_rlvol15’,
\n‘\/dev\/rtd_vg16_rlvol12′,\u2026\u2026\u2026\uc911\ub7b5<\/p>\n

\u2019dev\/rti_vg11_rlvol5’,
\n‘\/dev\/rti_vg21_rlvol17’,
\n‘\/dev\/rti_vg21_rlvol3’,
\n‘\/dev\/rti_vg21_rlvol9’,
\n‘\/dev\/rti_vg21_rlvol20’,
\n‘\/dev\/rti_vg21_rlvol4’,
\n‘\/dev\/rti_vg21_rlvol5’,
\n‘\/dev\/rti_vg08_rlvol4’,
\n‘\/dev\/rti_vg08_rlvol3’,
\n‘\/dev\/rti_vg07_rlvol2’,
\n‘\/dev\/rti_vg12_rlvol3’,
\n‘\/dev\/rti_vg21_rlvol13’,
\n‘\/dev\/rti_vg21_rlvol19’,
\n‘\/dev\/rti_vg23_rlvol19’
\n)
\nConnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining
\nand Real Application Testing options
\nExport file created by EXPORT:V10.02.01 via conventional path
\nAbout to import transportable tablespace(s) metadata…
\nimport done in KO16KSC5601 character set and AL16UTF16 NCHAR character set
\n. importing SYS’s objects into SYS
\n. importing SYS’s objects into SYS
\n. importing TANAL’s objects into TANAL
\n. . importing table “TEST”
\n. importing TANALADMIN’s objects into TANALADMIN
\n. . importing table “ST_CI_HOUR”
\n. importing TMALL’s objects into TMALL
\n. . importing table “TMALL_USER_STATS_BK”
\n. . importing table “TMALL_USER_STATS”
\n. . importing table “SE_FEE_STL_OBJ_BK”
\n. . importing table “BEGIN_SYSTEM_EVENT”
\n. . importing table “END_SYSTEM_EVENT”<\/p>\n

\u2026.. \uc911\ub7b5<\/p><\/blockquote>\n


\n\u25b2 table \ub2e8\uc704\ub85c import \ub97c \uc9c4\ud589\ud55c\ub2e4.<\/strong><\/p>\n

 <\/p>\n

alert \ub85c\uadf8\ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 plug-in \ub41c \uc815\ubcf4\uc758 \ud655\uc778\uc774 \uac00\ub2a5<\/p>\n

=====================================
\nSat Mar 28 05:50:53 2009
\nPlug in tablespace USERS with datafile
\n‘\/dev\/rtd_vg07_rlvol34’
\n‘\/dev\/rtd_vg01_rlvol33’
\nPlug in tablespace TSD_COMM with datafile
\n‘\/dev\/rtd_vg22_rlvol17’
\n‘\/dev\/rtd_vg16_rlvol2’
\n‘\/dev\/rtd_vg07_rlvol7’
\n‘\/dev\/rtd_vg07_rlvol32’
\n‘\/dev\/rtd_vg07_rlvol10’
\nPlug in tablespace TSD_MARKET with datafile
\n‘\/dev\/rtd_vg22_rlvol2’
\n‘\/dev\/rtd_vg22_rlvol11’
\n‘\/dev\/rtd_vg16_rlvol14’
\n‘\/dev\/rtd_vg14_rlvol2’
\n‘\/dev\/rtd_vg03_rlvol3’
\n‘\/dev\/rtd_vg07_rlvol11’
\nPlug in tablespace TSD_PROD with datafile
\n‘\/dev\/rtd_vg22_rlvol14’
\n‘\/dev\/rtd_vg22_rlvol13’ \u2026\u2026..<\/p><\/blockquote>\n

 <\/p>\n

2.3.5. Tablespace Read-Write \ubaa8\ub4dc\ub85c \ubcc0\uacbd<\/p>\n

 <\/p>\n

meta data import \uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc885\ub8cc\uac00 \ub418\uba74 Tablespace \ub97c Online \uc0c1\ud0dc\ub85c \ubcc0\uacbd<\/p>\n

 <\/p>\n

SQL> alter tablespace TSD_TNS read write;
\nSQL> alter tablespace TSD_MEMBER read write;
\nSQL> alter tablespace TSD_SYS read write;
\nSQL> alter tablespace TSD_TANAL read write;
\nSQL> alter tablespace CYBER_DATA read write;
\nSQL> alter tablespace TBS_TINSP_DAT read write;
\nSQL> alter tablespace TSI_COMM read write;
\nSQL> alter tablespace TSI_PROD read write;
\nSQL> alter tablespace TSI_TRADE read write;
\nSQL> alter tablespace TSI_TNS read write;
\nSQL> alter tablespace TSI_MEMBER read write;
\nSQL> alter tablespace TSI_SYS read write;
\nSQL> alter tablespace TSI_TANAL read write;
\nSQL> alter tablespace CYBER_INDX read write;
\nSQL> alter tablespace TBS_TINSP_IDX read write;
\nSQL> alter tablespace TSD_MPV2 read write;
\nSQL> alter tablespace TSI_MPV2 read write;
\nSQL> alter tablespace TSD_SHPLNK read write;
\nSQL> alter tablespace TSI_SHPLNK read write;
\nSQL> alter tablespace SHAREPLEX read write;
\nSQL> alter tablespace TSI_PROD_01 read write;<\/p>\n

\u2026\u2026<\/p><\/blockquote>\n

 <\/p>\n

\u25b2 Online \uc0c1\ud0dc \ud655\uc778<\/p>\n

SQL> select tablespace_name, status from dba_tablespaces;<\/p>\n

 <\/p>\n

2.4. TTS Migration \ub9c8\ubb34\ub9ac<\/strong><\/p>\n

TTS \uc758 \ub9c8\ubb34\ub9ac \ub2e8\uacc4\uc5d0\uc11c\ub294 \uc784\uc2dc\ub85c \ubcc0\uacbd\ud588\ub358 default tablespace \ubc0f temp tablespace \ub97c HP \uc11c\ubc84 \uc640 \ub3d9\uc77c\ud558\uac8c \ubcc0\uacbd\uc744 \ud558\uace0,<\/p>\n

TTS \uc218\ud589\uc911 \ubcc0\uacbd\ud55c \ud328\uc2a4\uc6cc\ub4dc \ubc0f TTS \uc758 \uc81c\uc57d\uc0ac\ud56d\uc73c\ub85c \uc774\uc804\uc774 \ub418\uc9c0 \uc54a\ub294 procedure, package, db_link, view \ub4f1 \ucd94\uac00 object \ub97c \uc0dd\uc131 \ud574\uc57c \ud55c\ub2e4.<\/p>\n

 <\/p>\n

2.4.1. \uc720\uc800\uc815\ubcf4 \ubcc0\uacbd<\/p>\n

SQL> alter user MPV2 default tablespace TSD_MPV2 temporary tablespace TEMP_BATCH;
\nSQL> alter user TANALADMIN default tablespace TSD_COMM temporary tablespace TEMP_BATCH;
\nSQL> alter user INSPADMIN default tablespace TSD_COMM temporary tablespace TEMP_BATCH;
\nSQL> alter user TANAL default tablespace TSD_COMM temporary tablespace TEMP_BATCH;
\nSQL> alter user SVCOP default tablespace USERS temporary tablespace TEMP_BATCH;
\nSQL> alter user SVCADMIN default tablespace USERS temporary tablespace TEMP_BATCH;
\nSQL> alter user SVCMCHT default tablespace USERS temporary tablespace TEMP_BATCH;
\nSQL> alter user TPA default tablespace TPA_TS temporary tablespace TEMP;
\nSQL> alter user AMAILADMIN default tablespace TSD_AMAIL temporary tablespace TEMP;
\nSQL> alter user SPLEX2 default tablespace SHAREPLEX temporary tablespace TEMP;<\/p>\n

\u2026\u2026..<\/p><\/blockquote>\n

 <\/p>\n

2.4.2. TTS\uc81c\uc57d\uc0ac\ud56d Object \ub4f1\ub85d<\/p>\n

$:> imp system\/oracle file=rows_n.dmp log=imp_obj.log rows=n full=y ignore=y buffer=102400000<\/p><\/blockquote>\n

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining
\nand Real Application Testing options
\nExport file created by EXPORT:V10.02.01 via conventional path
\nimport done in KO16KSC5601 character set and AL16UTF16 NCHAR character set
\n. importing SYSTEM’s objects into SYSTEM
\nIMP- 00017: following statement failed with ORACLE error 1119:
\n“CREATE TABLESPACE “SHAREPLEX” BLOCKSIZE 8192 DATAFILE ‘\/dev\/vg07\/rlvol35’ ”
\n“SIZE 5120M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE
\nPERMANENT SEGMENT SPACE MANAGEMENT AUTO”<\/p><\/blockquote>\n

IMP- 00003: ORACLE error 1119 encountered
\nORA- 01119: error in creating database file ‘\/dev\/vg07\/rlvol35’
\nORA- 27040: file create error, unable to create file
\nIBM AIX RISC System\/6000 Error: 2: No such file or directory
\nIMP- 00017: following statement failed with ORACLE error 1119:
\n“CREATE TEMPORARY TABLESPACE “TEMP01″ BLOCKSIZE 8192 TEMPFILE ‘\/dev\/vg14\/rl”
\n“vol5’ SIZE 10111M , ‘\/dev\/vg15\/rlvol10’ SIZE 10111M , ‘\/dev\/vg16\/”
\n“rlvol4’ SIZE 10111M , ‘\/dev\/vg16\/rlvol8’ SIZE 10111M , ‘\/dev\/vg17”
\n“\/rlvol5’ SIZE 10111M , ‘\/dev\/vg17\/rlvol8’ SIZE 10111M , ‘\/dev\/vg1”
\n“6\/rlvol5’ SIZE 10111M , ‘\/dev\/vg11\/rlvol2’ SIZE 25087M EXTENT MA”
\n“NAGEMENT LOCAL UNIFORM SIZE 1048576”
\nIMP- 00003: ORACLE error 1119 encountered
\nORA- 01119: error in creating database file ‘\/dev\/vg14\/rlvol5’
\nORA- 27040: file create error, unable to create file
\nIBM AIX RISC System\/6000 Error: 2: No such file or directory
\nIMP- 00017: following statement failed with ORACLE error 959:
\n“ALTER USER “SYS” IDENTIFIED BY VALUES ‘6AE2F634C19CF614’ TEMPORARY TABLESPA”
\n“CE “TEMP01″”
\nIMP- 00003: ORACLE error 959 encountered
\nORA- 00959: tablespace ‘TEMP01’ does not exist
\nIMP- 00017: following statement failed with ORACLE error 959:
\n“ALTER USER “SYSTEM” IDENTIFIED BY VALUES ‘A71C8B67B5BC5635’ TEMPORARY
\nTABLESPACE “TEMP01″”
\nIMP- 00003: ORACLE error 959 encountered
\nORA- 00959: tablespace ‘TEMP01’ does not exist
\n. importing TMALL’s objects into TMALL
\n. importing SYSTEM’s objects into SYSTEM
\n. importing SYSMAN’s objects into SYSMAN
\n. importing CYBER’s objects into CYBER
\n. importing MPV2’s objects into MPV2
\n. importing INSPADMIN’s objects into INSPADMIN
\n. importing TANALADMIN’s objects into TANALADMIN
\n. importing TMALL’s objects into TMALL
\n. importing SMSMO’s objects into SMSMO
\n. importing SHOPLINKER’s objects into SHOPLINKER
\n. importing SPLEX’s objects into SPLEX<\/p>\n

\uc911\ub7b5\u2026\u2026<\/p>\n

 <\/p><\/blockquote>\n

\u25b2 \uc2e4\ud589\ud55c \ud6c4\uc5d0 \uac01\uc885 object \uac00 \uc815\uc0c1\uc801\uc73c\ub85c import \uac00 \ub418\uc5c8\ub294\uc9c0\u00a0 \ud655\uc778<\/strong><\/p>\n

 <\/p>\n

3. Tablespace Re-Org<\/strong><\/p>\n

3.1. LOB Table Move<\/p>\n

\uae30\uc874\uc5d0 lob type \uc758 Table \uacfc \uc77c\ubc18 Table \uc758 \uacf5\uc874\uc73c\ub85c \uc778\ud558\uc5ec I\/O \uce21\uba74\uc758 \ubb38\uc81c\uc810\uacfc \uad00\ub9ac\uc0c1\uc758 \ubb38\uc81c \ubc0f Migration \uc2dc\uc758 \ubb38\uc81c\uc810\uc774 \uc788\uc74c.<\/p>\n

\uc704\uc758 \ubb38\uc81c\ub85c \uc778\ud558\uc5ec TTS Migration \ud6c4\uc5d0 TSD_PROD \uc5d0 \uc874\uc7ac\ud558\ub294 lob type \uc758 \ud14c\uc774\ube14\uc744 \ubcc4\ub3c4\uc758 Tablespace \ub85c \uc774\uc804\uc744 \ud568.<\/p>\n

 <\/p>\n

3.1.1. TSD_PROD Rename To LOB_DATA<\/p>\n

lob \ud14c\uc774\ube14\ubcf4\ub2e4 \uc77c\ubc18\ud14c\uc774\ube14\uc758 \uc774\ub3d9\uc774 \ube60\ub974\uae30 \ub54c\ubb38\uc5d0 \uc704\uc640 \uac19\uc774 LOB_DATA \ub85c \ubcc0\uacbd<\/p>\n

SQL> alter tablespace TSD_PROD rename to LOB_DATA;<\/p><\/blockquote>\n

 <\/p>\n

3.1.2. TSD_PROD_IMSI Rename To TSD_PROD<\/p>\n

\uc0ac\uc804\uc5d0 \uc0dd\uc131\ud55c TSD_PROD_IMSI \ub97c TSD_PROD \ub85c \ubcc0\uacbd<\/p>\n

SQL> alter tablespace TSD_PROD_IMSI rename to TSD_PROD;<\/p><\/blockquote>\n

 <\/p>\n

3.1.3. TSI_PROD_IMG01 Tabelspace Re-size<\/p>\n

parallel \uc2e4\ud589\uc2dc extend \uc5d0\ub7ec \ub300\ube44 re-size<\/p>\n

SQL> alter tablespace TSI_PROD_IMG_01 add datafile\u00a0 ‘\/dev\/rindex16_01’ size 16000M;<\/p><\/blockquote>\n

 <\/p>\n

3.1.4. LOB_DATA \uc77c\ubc18\ud14c\uc774\ube14\uc744 TSD_PROD\ub85c \uc774\uc804<\/p>\n

LOB Type \uc758 \ud14c\uc774\ube14\uc758 \ub290\ub9b0 I\/O \ubb38\uc81c\ub85c \uc778\ud558\uc5ec \uc77c\ubc18 \ud14c\uc774\ube14\uc744 move \ud568<\/p>\n

 <\/p>\n

SQL> alter table TMALL.DP_PRD_CONT_SUMMARY move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.SY_BATCH_APP_LOG move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.TEMP_TEST move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.KTW$TBS_REORG_TEMP move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.KTW$SESS_WAIT move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.DP_KN_SHP_RECOM move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.SY_BATCH_APP_LIST move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.PD_BRAND move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.PD_SEL_INFO move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.MT_EVNT_MAIL_CHIP move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.DP_SEMI_EXPRT move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.KW_LOG_INFO move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.PD_AUCT_PRD_HIST move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.TEMP_KW_LOG_1208 move tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.DP_COMP_SHPP_ORD_ATTR move tablespace TSD_PROD parallel 8 nologging;<\/p>\n

\u2026\u2026\u2026<\/p>\n

 <\/p><\/blockquote>\n

3.2. Long Table Move<\/strong><\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\nlong type \uc758 \ud14c\uc774\ube14\uc740 exp\/imp \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud574\uc11c \uc774\uc804<\/span><\/strong><\/p>\n

 <\/p>\n

3.2.1. long type export<\/p>\n

\u00a0\u00a0 $:\/>exp tmall\/oracle file=tmall_long.dmp log=tmall_long.log tables=’SY_SECURE_KEY’,’TEMP1′,’PLAN_TABLE_OLD’,’TKPROF_TABLE’ buffer=1024000<\/p>\n

 <\/p><\/blockquote>\n

3.2.2. drop long type table<\/p>\n

SQL> drop table tmall.SY_SECURE_KEY;
\nSQL> drop table tmall.TEMP1;
\nSQL> drop table tmall.PLAN_TABLE_OLD;
\nSQL> drop table tmall.TKPROF_TABLE;<\/p>\n

 <\/p><\/blockquote>\n

3.2.3.create long type table(tablespace\ubcc0\uacbd)<\/p>\n

CREATE TABLE TMALL.SY_SECURE_KEY
\n(
\nKEY LONG RAW
\n)
\nTABLESPACE TSD_PROD
\nPCTFREE 10
\nINITRANS 1
\nMAXTRANS 255<\/p>\n

STORAGE
\n(
\nINITIAL 65536
\nMINEXTENTS 1
\nMAXEXTENTS UNLIMITED<\/p>\n

BUFFER_POOL DEFAULT
\n)
\nLOGGING
\nDISABLE ROW MOVEMENT ;
\nGRANT SELECT ON TMALL.SY_SECURE_KEY TO SVCOP;
\nGRANT DELETE ON TMALL.SY_SECURE_KEY TO SVCADMIN;
\nGRANT INSERT ON TMALL.SY_SECURE_KEY TO SVCADMIN;
\nGRANT SELECT ON TMALL.SY_SECURE_KEY TO SVCADMIN;<\/p>\n

GRANT INSERT ON TMALL.SY_SECURE_KEY TO SVCESC;
\nGRANT SELECT ON TMALL.SY_SECURE_KEY TO SVCESC;
\nGRANT UPDATE ON TMALL.SY_SECURE_KEY TO SVCESC;
\nGRANT SELECT ON TMALL.SY_SECURE_KEY TO SVCFRONT;<\/p>\n

\u2026\u2026. \uc911\ub7b5<\/p><\/blockquote>\n

 <\/p>\n

3.2.4. long type import<\/p>\n

$:\/>imp tmall\/oracle file=tmall_long.dmp log=imp_tmall_long.log tables=’SY_SECURE_KEY’,’TEMP1′,’PLAN_TABLE_OLD’,’TKPROF_TABLE’ ignore=y buffer=1024000<\/p><\/blockquote>\n

 <\/p>\n

3.3. Partition Table Move<\/strong><\/p>\n

3.3.1. LOB_DATA\uc5d0 \uc874\uc7ac\ud558\ub294 partition \ud14c\uc774\ube14 TSD_PROD \ub85c \uc774\uc804<\/p>\n

SQL> alter table TMALL.PD_PRD move partition P_PD_PRD_SEL tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.TB_IF_SMS_TRANSFER move partition P_MAXVALUE tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.TB_IF_SMS_TRANSFER move partition P_2009_12 tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.TB_IF_SMS_TRANSFER move partition P_2009_11 tablespace TSD_PROD parallel 8 nologging;
\nSQL> alter table TMALL.TB_IF_SMS_TRANSFER move partition P_2009_10 tablespace TSD_PROD parallel 8 nologging;<\/p>\n

\u2026..<\/p>\n

 <\/p><\/blockquote>\n

3.4. Tablespace Re-Org \ub9c8\ubb34\ub9ac<\/strong><\/p>\n

3.4.1. logging, noparallel \uc124\uc815<\/p>\n

SQL> alter index TANALADMIN.IDX_QRTZ_T_VOLATILE noparallel;
\nSQL> alter index TMALL.PK_CM_UNITY_INFO_CONT noparallel;
\nSQL> alter index TMALL.PK_MT_MT_ISLND_TMPLT noparallel;
\nSQL> alter index TMALL.IX99_MT_ISLND_TMPLT_IMG noparallel;
\nSQL> alter index TMALL.PK_SELLER_SELL_SUMMARY noparallel;
\nSQL> alter index TMALL.PK_MT_SELLERSHP noparallel;<\/p>\n

\uc911\ub7b5\u2026<\/p><\/blockquote>\n

 <\/p>\n

3.4.2. \ucd5c\uc885 \uad8c\ud55c \uc124\uc815<\/p>\n


\nApp \uc2e4\ud589\uc2dc \uad8c\ud55c\uc73c\ub85c \uc0dd\uae30\ub294 \uc624\ub958\ub97c \ubc29\uc9c0\ud558\uae30 \uc704\ud574\uc11c \ubaa8\ub4e0 \uc720\uc800\uc758 \uad8c\ud55c\uc744 \ub9c8\uc9c0\ub9c9\uc5d0 \uc2e4\ud589<\/span><\/strong><\/p>\n

 <\/p>\n

SQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_CUPN_ORD TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_CUPN_ORD_GA TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_CUPN_USE TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_CUPN_USE_GA TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_DISP_ITM_FEE TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_DLVCOST_MNBD TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_DLV_CLAIM TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_DVLTYPE_STATUS TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_ITEM_ATTR TO YMLEE75;
\nSQL>GRANT SELECT ON TANALADMIN.ST_TOTZ_TR_ORD_CN TO YMLEE75;<\/p>\n

\uc911\ub7b5\u2026<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

============================================================================================== \uc21c\uc11c \u00a0 1.CRS \ubc0f Oracle install 1.1.CRS requirement 1.1.1.OS requirement 1.1.2.Oracle requirement 1.1.3.CRS install & Oracle install 2.To IBM From HP 2.1.Pre-Migration Check(HP) 2.1.1.HP \uc11c\ubc84\uc758 TTS \ub300\uc0c1 Tablespace \ud655\uc778 2.1.2.TTS \ub300\uc0c1 Tablespace \uc758 Violation Check 2.2.TTS Migration On HP 2.2.1.Tablespace Read Only \ubcc0\uacbd 2.2.2.TTS \uc774\uc804\uc744 \uc704\ud55c Meta Data Export \uc2e4\ud589 2.2.3.TTS plug-in \ud6c4 object […]<\/p>\n","protected":false},"author":1,"featured_media":3402,"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":[10],"tags":[1127,1453,1449,1452,1450,1143,1451],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how-1.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4872"}],"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=4872"}],"version-history":[{"count":7,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4872\/revisions"}],"predecessor-version":[{"id":4880,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4872\/revisions\/4880"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3402"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4872"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}