oracle xtts 测试,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'