Oracle 传输表空间.doc

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.TRANSPORT_SET_CHECK(ODU, TRUE);PL/SQL procedure successfully completed.SQL SELECT * FROM TRANSPORT_SET_VIOLATIONS;no rows selectedSQL SELECT COUNT(*) FROM DBA_TABLES WHERE TABLESPACE_NAME=ODU;COUNT(*)-59SQL SELECT file_name from dba_data_files where tablespace_name=ODU;FILE_NAME/opt/oracle/oradata/chf/odu01.dbf/opt/oracle/oradata/chf/odu02.dbf需要传输表空间至于readonly模式SQL ALTER TABLESPACE ODU READ ONLY;Tablespace altered.导出表空间元数据oraclenode1 $ exp userid=/ as sysdba tablespaces=ODU file=/tmp/ODU.dmp transport_tablespace=yExport: Release 10.2.0.4.0 Production on Sun Sep 11 10:01:52 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 64bit 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 tablespace ODU . exporting cluster definitions. exporting table definitions. . exporting table T_ODU_03. . exporting table T_ODU_01. . 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 DF. . exporting table DFATT. . exporting table TF. . exporting table TFATT. . exporting table OFFR. . exporting table RR. . 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. . exporting table CDF. . exporting table XDF. . exporting table BRL. . 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. . exporting table F_DROP. . exporting table T_QUERY. . exporting table T_UNDO. . 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. . exporting 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.传输到目标段oraclenode1 $ scp /opt/oracle/oradata/chf/odu0* 192.168.11.12:/opt/oracle/oradata/testThe authenticity of host 192.168.11.12 (192.168.11.12) cant be 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)? yesWarning: Permanently added 192.168.11.12 (RSA) to the list of known hosts.oracle192.168.11.12s 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.12s password:Permission denied, please try again.oracle192.168.11.12s password:ODU.dmp 100% 456KB 456.0KB/s 00:00 二、目标端操作导入元数据库oracleECP-UC-DB1 $ imp userid=/ as sysdba tablespaces=ODU file=/tmp/ODU.dmp transport_tablespace=y datafiles=/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 rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 64bit 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 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 “NODE”. . importing table “CONF”. . importing table “DBINC”. . importing table “CKP”. . importing table “TS”. . importing table “TSATT”. . importing table “DF”. . importing table “DFATT”. . importing table “TF”. . importing table “TFATT”. . importing table “OFFR”. . importing table “RR”. . importing table “RT”. . importing table “ORL”. . importing table “RLH”. . importing table “AL”. . importing table “BS”. . importing table “BP”. . importing table “BCF”. . importing table “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 “RSR”. . 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. . importing table “MLOG$_T_MV”. . importing table “T_N”. . importing table “T_M”. . importing table “MLOG$_T_N”. . impor