Oracle 传输表空间

Oracle传输表空间0、检查平台信息所有tts支持平台SELECT*FROMV$TRANSPORTABLE_PLATFORM;当前系统平台情况SELECTd.PLATFORM_NAME,ENDIAN_FORMATFROMV$TRANSPORTABLE_PLATFORMtp,V$DATABASEdWHEREtp.PLATFORM_NAME=d.PLATFORM_NAME;一、源端操作检查是否符合TTS要求SQLEXECUTEDBMS_TTS.TRANSPORT_SET_CHECK(‘ODU’,TRUE);PL/SQLproceduresuccessfullycompleted.SQLSELECT*FROMTRANSPORT_SET_VIOLATIONS;norowsselectedSQLSELECTCOUNT(*)FROMDBA_TABLESWHERETABLESPACE_NAME=’ODU’;COUNT(*)———-59SQLSELECTfile_namefromdba_data_fileswheretablespace_name=’ODU’;FILE_NAME————————————————–/opt/oracle/oradata/chf/odu01.dbf/opt/oracle/oradata/chf/odu02.dbf需要传输表空间至于readonly模式SQLALTERTABLESPACEODUREADONLY;Tablespacealtered.导出表空间元数据[oracle@node1~]$expuserid=\’/assysdba\’tablespaces=ODUfile=/tmp/ODU.dmptransport_tablespace=yExport:Release10.2.0.4.0–ProductiononSunSep1110:01:522011Copyright(c)1982,2007,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0–64bitProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsExportdoneinZHS16GBKcharactersetandAL16UTF16NCHARcharactersetNote:tabledata(rows)willnotbeexportedAbouttoexporttransportabletablespacemetadata…FortablespaceODU….exportingclusterdefinitions.exportingtabledefinitions..exportingtableT_ODU_03..exportingtableT_ODU_01..exportingtableT_ODU..exportingtableDB..exportingtableNODE..exportingtableCONF..exportingtableDBINC..exportingtableCKP..exportingtableTS..exportingtableTSATT..exportingtableDF..exportingtableDFATT..exportingtableTF..exportingtableTFATT..exportingtableOFFR..exportingtableRR..exportingtableRT..exportingtableORL..exportingtableRLH..exportingtableAL..exportingtableBS..exportingtableBP..exportingtableBCF..exportingtableCCF..exportingtableXCF..exportingtableBSF..exportingtableBDF..exportingtableCDF..exportingtableXDF..exportingtableBRL..exportingtableBCB..exportingtableCCB..exportingtableSCR..exportingtableSCRL..exportingtableCONFIG..exportingtableXAL..exportingtableRSR..exportingtableFB..exportingtableGRSP..exportingtableROUT..exportingtableRCVER..exportingtableF_DROP..exportingtableT_QUERY..exportingtableT_UNDO..exportingtableA..exportingtableT1..exportingtableT2_1..exportingtableT2..exportingtableT_MV..exportingtableTAB2..exportingtableMLOG$_T_MV..exportingtableT_N..exportingtableT_M..exportingtableMLOG$_T_N..exportingtableT_1..exportingtableT_2..exportingtableT_3..exportingtableT_4..exportingtableT_5.exportingreferentialintegrityconstraints.exportingtriggers.endtransportabletablespacemetadataexportExportterminatedsuccessfullywithoutwarnings.SQLaltertablespaceodureadwrite;Tablespacealtered.传输到目标段[oracle@node1~]$scp/opt/oracle/oradata/chf/odu0*192.168.11.12:/opt/oracle/oradata/testTheauthenticityofhost’192.168.11.12(192.168.11.12)’can’tbeestablished.RSAkeyfingerprintisdb:3c:b4:34:7f:d7:e4:97:ab:b6:8b:b0:ab:22:43:35.Areyousureyouwanttocontinueconnecting(yes/no)?yesWarning:Permanentlyadded’192.168.11.12′(RSA)tothelistofknownhosts.oracle@192.168.11.12′spassword:odu01.dbf100%100MB3.3MB/s00:30odu02.dbf100%11GB2.8MB/s1:05:00[oracle@node1~]$scp/tmp/ODU.dmp192.168.11.12:/tmporacle@192.168.11.12′spassword:Permissiondenied,pleasetryagain.oracle@192.168.11.12′spassword:ODU.dmp100%456KB456.0KB/s00:00二、目标端操作导入元数据库[oracle@ECP-UC-DB1~]$impuserid=\’/assysdba\’tablespaces=ODUfile=/tmp/ODU.dmptransport_tablespace=ydatafiles=/opt/oracle/oradata/test/odu01.dbf,/opt/oracle/oradata/test/odu02.dbffromuser=chftouser=chfImport:Release10.2.0.4.0–ProductiononSunSep1111:13:252011Copyright(c)1982,2007,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gEnterpriseEditionRelease10.2.0.4.0–64bitProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsExportfilecreatedbyEXPORT:V10.02.01viaconventionalpathAbouttoimporttransportabletablespace(s)metadata…importdoneinZHS16GBKcharactersetandAL16UTF16NCHARcharacterset.importingCHF’sobjectsintoCHF..importingtable“T_ODU_03″..importingtable“T_ODU_01″..importingtable“T_ODU”..importingtable“DB”..importingtable“NODE”..importingtable“CONF”..importingtable“DBINC”..importingtable“CKP”..importingtable“TS”..importingtable“TSATT”..importingtable“DF”..importingtable“DFATT”..importingtable“TF”..importingtable“TFATT”..importingtable“OFFR”..importingtable“RR”..importingtable“RT”..importingtable“ORL”..importingtable“RLH”..importingtable“AL”..importingtable“BS”..importingtable“BP”..importingtable“BCF”..importingtable“CCF”..importingtable“XCF”..importingtable“BSF”..importingtable“BDF”..importingtable“CDF”..importingtable“XDF”..importingtable“BRL”..importingtable“BCB”..importingtable“CCB”..importingtable“SCR”..importingtable“SCRL”..importingtable“CONFIG”..importingtable“XAL”..importingtable“RSR”..importingtable“FB”..importingtable“GRSP”..importingtable“ROUT”..importingtable“RCVER”..importingtable“F_DROP”..importingtable“T_QUERY”..importingtable“T_UNDO”..importingtable“A”..importingtable“T1″..importingtable“T2_1″..importingtable“T2″..importingtable“T_MV”..importingtable“TAB2″..importingtable“MLOG$_T_MV”..importingtable“T_N”..importingtable“T_M”..importingtable“MLO