--在线传输表空间，增量方式--创建相关目录createdirectorysourcediras'+DATA/mydb/datafile';createdirectorydestdiras'/oracle/app/oracle/oradata/mytest';--创建dblinkcreatepublicdatabaselinkttslinkconnecttosystemidentifiedbyoracleusing'mydb';select*fromdual@ttslink;exportTMPDIR=/home/oracle/xttmkdir-p/stage_sourcechownoracle:oinstall/stage_sourcescp-r/home/oracle/xttmystandby:/home/oracle--相关表空间TEST,MYDB,TMOVE,TBSADD,TSB01tablespaces=----需要迁移的表空间platformid=----源OS平台IDdfcopydir=----源数据库备份文件存放目录backupformat=---源数据库增备文件存放目录stageondest=----目标据库备份文件存放目录storageondest=----目标据库正式文件存放目录backupondest=----目标据库增备文件存放目录parallel=----备份，转化的并行度rollparallel=----增备的并行度getfileparallel=----使用dbms_file_transfer方式的并行度--源端块跟踪alterdatabaseenableblockchangetrackingusingfile'+data';--源端运行，导出数据exportTMPDIR=/home/oracle/xtt$ORACLE_HOME/perl/bin/perlxttdriver.pl-p--nfs/stage_source192.168.8.0/24(rw,no_root_squash,no_all_squash,sync)exportfs-rservicerpcbindstartservicenfsstartmount-tnfs-orw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600192.168.8.24:/stage_source/stage_dest--挂在的nfs，无需拷贝--scporacle@source:/stage_source/*/stage_destcd/home/oracle/xtt/scprmanconvert.cmdmystandby:/home/oracle/xtt--chown-Roracle:oinstall/stage_dest/*exportTMPDIR=/home/oracle/xtt$ORACLE_HOME/perl/bin/perlxttdriver.pl-c--源端创建增量备份exportTMPDIR=/home/oracle/xtt$ORACLE_HOME/perl/bin/perlxttdriver.pl-i--nfs无需拷贝--scp`catincrbackups.txt`oracle@dest:/stage_destcd/home/oracle/xtt/scpxttplan.txtmystandby:/home/oracle/xttscptsbkupmap.txtmystandby:/home/oracle/xtt--目标端exportORACLE_SID=mytestexportTMPDIR=/home/oracle/xtt$ORACLE_HOME/perl/bin/perlxttdriver.pl-r--源端更新scn$ORACLE_HOME/perl/bin/perlxttdriver.pl-s--目标端创建相关用户，注意密码即将过期用户无法查到（open）select'createuser'||d.username||'identifiedbyvalues'''||u.password||'''defaulttablespaceUSERStemporarytablespace'||d.TEMPORARY_TABLESPACE||';'fromdba_usersd,user$uwhered.username=u.nameandaccount_status='OPEN'andusernamenotin('SYS','SYSTEM');select'grant'||granted_role||'to'||grantee||';'fromdba_role_privswheregranteein(selectusernamefromdba_userswhereaccount_status='OPEN'andusernamenotin('SYS','SYSTEM'))unionselect'grant'||PRIVILEGE||'to'||grantee||';'fromDBA_SYS_PRIVSwheregranteein(selectusernamefromdba_userswhereaccount_status='OPEN'andusernamenotin('SYS','SYSTEM'));--源端设置表空间只读TEST,MYDB,TMOVE,TBSADD,TSB01altertablespaceTESTreadonly;altertablespaceMYDBreadonly;altertablespaceTMOVEreadonly;altertablespaceTBSADDreadonly;altertablespaceTSB01readonly;--最后增量--源端创建增量备份,注意nfs目录权限chown-Roracle:oinstall/stage_sourceexportTMPDIR=/home/oracle/xtt$ORACLE_HOME/perl/bin/perlxttdriver.pl-i--nfs无需拷贝，incrbackups.txt备份信息--scp`catincrbackups.txt`oracle@dest:/stage_destcd/home/oracle/xtt/scpxttplan.txttsbkupmap.txtmystandby:/home/oracle/xtt--目标端su-rootchown-Roracle:oinstall/stage_dest/su-oracleexportORACLE_SID=mytestexportTMPDIR=/home/oracle/xtt$ORACLE_HOME/perl/bin/perlxttdriver.pl-r--生成导入脚本$ORACLE_HOME/perl/bin/perlxttdriver.pl-e--编辑导入脚本,例如impdpdirectory=DATA_PUMP_DIRlogfile=tts_imp.log\network_link=ttslinktransport_full_check=no\transport_tablespaces=ABC\transport_datafiles='/oracle/app/oracle/oradata/mytest/ABC_12.dbf'--设置表空间读写altertablespaceTESTreadwrite;altertablespaceMYDBreadwrite;altertablespaceTMOVEreadwrite;altertablespaceTBSADDreadwrite;altertablespaceTSB01readwrite;--修改目标端用户默认表空间（语句在源端查询）select'alteruser'||d.username||'defaulttablespace'||d.default_tablespace||'temporarytablespace'||d.TEMPORARY_TABLESPACE||';'fromdba_usersd,user$uwhered.username=u.nameandaccount_status='OPEN'andusernamenotin('SYS','SYSTEM');--取消块跟踪alterdatabasedisableblockchangetracking;--删除dblinkdropdatabaselinkttslink;--参考http://www.xifenfei.com/2017/11/xtts.htmlhttps://blog.csdn.net/heguanghuicn/article/details/7946019811G-ReduceTransportableTablespaceDowntimeusingCrossPlatformIncrementalBackup(DocID1389592.1)https://yq.aliyun.com/articles/129601