xtts步骤

1、首先现在xtts脚本与模块：  mos id 1389592.1 附件中有xtts操作需要的源代码。   2、在源平台和目标平台上创建支持的数据库对象/暂存区。  （1）在源平台上创建目录对象。 mkdir -p /home/oracle/xtts mkdir -p /home/oracle/xttsfiles 创建数据库目录，并赋予权限： create directory ora10g_dbf as '/u01/app/oracle/oradata/prod'; grant read,write on directory ora10g_dbf to public; create directory xttsfiles as '/home/oracle/xttsfiles'; grant read,write on directory xttsfiles to public; (2)目标平台上数据库的版本不要低于11.2.0.4，需要创建目录对象外加一个数据库链接指向源数据库。 mkdir -p /home/oracle/xtts mkdir -p /home/oracle/xttsfiles drop database link ora10g ; 配置tnsname.ora 文件中的 ORA10G ORA10G =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.42)(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = prod)     )   ) create database link ora10g connect to system identified by oracle using 'ORA10G'; 创建目录： create directory ora11g_dbf as '/u01/app/oracle/oradata/prod'; grant read,write on directory ora11g_dbf to public; create directory xttsfiles as '/home/oracle/xttsfiles' ; grant read ,write on directory xttsfiles to public; 3、解压与安装xtts 脚本 在源平台与目标平台上都需要进行安装操作。 unzip -d /home/oracle/xtts rman_xttcovert_.zip 4、配置 XTTS 属性以及环境变量 export TMPDIR=/home/oracle/xtts 源库确定好需要迁移的表空间名称。 SQL> select tablespace_name from dba_tablespaces; TABLESPACE_NAME ------------------------------ SYSTEM UNDOTBS1 SYSAUX TEMP USERS BFW_TBS TEST_1 TBS_TEST_ABC 8 rows selected. 确定此次测试的表空间名称为    USERS,BFW_TBS,TEST_1,TBS_TEST_ABC 如果出现bash:./vmware-install.pl :/usr/bin/perl:bad interpreter:No such file or directory.现象， 输入yum groupinstall "Perl Support"即可。 alter tablespace BFW_TBS read only; alter tablespace TBS_TEST_ABC read only; alter tablespace USERS read only; alter tablespace TEST_1 read only; alter tablespace BFW_TBS read write; alter tablespace TBS_TEST_ABC read write ; alter tablespace USERS read write; alter tablespace TEST_1 read write; impdp \'\/ as sys\' directory=xttsfiles logfile=xttsfiles.log \ network_link=ORA10G transport_full_check=no \ transport_tablespaces=USERS,BFW_TBS,TEST_1,TBS_TEST_ABC \ transport_datafiles='ORA11G_DBF:/users01.dbf','ORA11G_DBF:/o1_mf_users_fv6ofqw5_.dbf','ORA11G_DBF:/o1_mf_bfw_tbs_ftzmf5dd_.dbf','ORA11G_DBF:/o1_mf_test_1_fv224kq6_.dbf','ORA11G_DBF:/o1_mf_tbs_test_fv6b7frm_.dbf'