rcle传输表空间

1、oracle 传输表空间0、检查平台信息所有tts支持平台select * from v$transportable_platform;当前系统平台情况select d.platform_name, endian_formatfrom v$transportable_platform tp, v$database dwhere tp.platform_name = d.platform_name;一、源端操作检查是否符合tts要求sql execute dbms_tts.transpo rt_set_check( odu , true);pl/sql procedure successfull

2、y completed.sql select * from transport_set_violations;no rows selectedsql select count(*) from dba_tables wheretablespace_name= odu；count(*)59sql select file_name from dba_data_files wheretablespace_name= odu；file_name/opt/oracle/oradata/chf/odu01.dbf/opt/oracle/oradata/chf/odu02.dbf需要传输表空间至于readon

3、ly模式sql alter tablespace odu read only;tablespace altered.导出表空间元数据oraclenode1 $ / as sysdba tablespaces=odufile=/tmp/odu.dmp transport_tablespace=yexport: release 1020.4.0 production on sun sep 11 10:01:52 2011copyright (c) 1982, 2007, oracle. all rights reserved.connected to: oracle database 10g en

4、terprise edition release 10.2.0.4.064bit productionwith the partitioning, olap, data mining and real application testing optionsexport done in zhs16gbk character set and al16utf16 nchar character setnote: table data (rows) will not be exportedabout to export transportable tablespace metadatafor tabl

5、espace odu .exporting cluster definitions.exporting table definitions.exporting table t_odu_03一 exporting table rr一 exporting table t_odu一 exporting table db.exporting table node.exporting table conf.exporting table dbinc.exporting table ckp一 exporting table ts.exporting table tsatt一 exporting table

6、 df.exporting table dfatt一 exporting table tf一 exporting table tfatt.exporting table rt一 exporting table orl一 exporting table rlh一 exporting table al一 exporting table bs一 exporting table bp一 exporting table bcf一 exporting table ccf一 exporting table xcf一 exporting table bsf一 exporting table bdf一 expo

7、rting table cdf一 exporting table xdf.exporting table t_undo一 exporting table bcb一 exporting table ccb一 exporting table scr一 exporting table scrl.exporting table config一 exporting table xal.exporting table rsr一 exporting table fb.exporting table grsp.exporting table rout.exporting table rcver.exporti

8、ng table f_drop一 exporting table a一 exporting table t1一 exporting table t2_1一 exporting table t2.exporting table t_mv一 exporting table tab2.exporting table mlog$_t_mv一 exporting table t_n一 exporting table t_m.exporting table mlog$_t_n一 exporting table t_1一 exporting table t_2一 exporting table t_3一 e

9、xporting table t_4一 exporting table t_5.exporting referential integrity constraints.exporting triggers.end transportable tablespace metadata exportexport terminated successfully without warnings.sql alter tablespace odu read write;tablespace altered.传输到目标段cant beoraclenode1 $ scp /opt/oracle/oradata

10、/chf/odu0* 192.168.11.12:/opt/oracle/oradata/testthe authenticity of host 192.168.11.12 (192.168.11.12)established.rsa key fingerprint is db:3c:b4:34:7f:d7:e4:97:ab:b6:8b:b0:ab:22:43:35.are you sure you want to continue connecting (yes/no)? yes192.168.11.12warning: permanently added(rsa) to the list

11、 of knownhosts.oracle192.168.11.12 s password:odu01.dbf 100% 100mb 3.3mb/s 00:30odu02.dbf 100% 11gb 2.8mb/s 1:05:00oraclenode1 $ scp /tmp/odu.dmp 192.168.11.12:/tmporacle192.168.11.12 s password:permission denied, please try again.oracle192.168.11.12 s password:odu.dmp 100% 456kb 456.0kb/s 00:00二、目标

12、端操作导入元数据库oracleecp-uc-db1 $ / as sysdbatablespaces=odu file=/tmp/odu.dmp transport_tablespace=ydatafiles=/opt/oracle/oradata/test/odu01.dbf,/opt/oracle/oradata/test/odu02.dbf fromuser=chf touser=chfimport: release 10.2.0.4.0-production on sun sep 11 11:13:25 2011copyright (c) 1982, 2007, oracle. all

13、 rights reserved.connected to: oracle database 10g enterprise edition release 10.2.0.4.064bit productionwith the partitioning, olap, data mining and real application testing optionsexport file created by export:v10.02.01 via conventional pathabout to import transportable tablespace(s) metadataimport

14、 done in zhs16gbk character set and al16utf16 nchar character set.importing chfs objects into chf.importing table“ t_odu_03 .importing table“ t_odu_01 .importing table“ t_odu”.importing table“ db”.importing table” rlh.importing table“ conf”.importing table“ dbinc.importing table“ ckp”.importing tabl

15、e“ ts”.importing table “ tsatt.importing table“ df”.importing tabledfatt.importing table“ tf”.importing table“ tfatt.importing table“ offr”.importing table“ rr”.importing table“ rt”.importing table“ orl”.im porting table“al”.importing table“ bs”.importing table“ bp”.importing table“ bcf”.importing t

16、able“ ccf”.importing table“ xcf”.importing table“ bsf”.importing table“ bdf”.importing table“ cdf”.importing table“ xdf”.importing table“ brl”.importing table“ bcb”.importing table“ ccb”.importing table“ scr”.importing table“ scrl”.importing table“ config ”.importing table“ xal ”.importing table“ rs

17、r”.importing table“ fb”.importing table“ grsp”.importing table“ rout”.importing table“ rcver”.importing table“f_drop”.importing table“ t_query”.importing table“t_undo”.importing table“ a”.importing table“ t1 .importing table“ t2_1 .importing table“ t2 .importing table“ t_mv”.importing table“ tab2 .i

18、mporting table“ mlog$_t_mv”.importing table“ t_n ”.importing table“ t_m”.importing table“ mlog$_t_n ”.impo rting table“ t_1 .importing table“ t_2 .importing table“ t_3 .importing table“ t_4 .importing table“ t_5 about to enable constraintsimport terminated successfully without warnings.sql select tablespace_name ,status from dba_tablespaces;tablespace_name statussystem onlineundotbs1 onlinesysaux onlinetemp onlineusers onlinexff online