xtts_v4 跨平台迁移数据库表空间之 - 19C

xtts 跨平台迁移数据库之 - Recovery Manager (RMAN) -NFS 测试实例

规划
source                              target
ip    192.168.142.200    192.168.142.201
db   19.3.0.0                   19.3.0.0
sid   zzh                            orcl

# su - oracle
$ sqlplus / as sysdba;
SQL> set lines 200;
set pages 200;
SQL> select * from v$version;

创建测试用用户、表及表空间：create tablespace XTTS_TBS datafile '/u01/app/oracle/oradata/ZZH/xtts_tbs01.dbf' size 100M autoextend on maxsize unlimited;
create user xtts identified by xtts default tablespace xtts_tbs;
grant connect,resource to xtts;
create table xtts.test as select * from dba_users;
create table xtts.zzh(id number,name varchar2(20));
insert into xtts.zzh values(1,'ZZH'); 
insert into xtts.zzh values(2,'ZZH'); 
insert into xtts.zzh values(3,'ZZH'); 
commit;

第一步：
源端设置 rman_xttconvert_VER4.zip
# su - oracle
$ mkdir xtts
$ cd xtts
$ rz
$ unzip rman_xttconvert_VER4.3.zip -d /u01/xtts/

注意：我们XTTS以及备份目的地使用的是NFS共享文件系统，所以XTTS只需要配置一次即可
配置 src_scratch_location 目录
创建数据文件的目录
# su - oracle
$ mkdir xtts_rman_dir

配置 dest_scratch_location、dest_datafile_location 目录

配置 xtt.properties
# su - oracle
$ cd xtts
$ vi xtt.properties
tablespaces=XTTS_TBS
platformid=13  -- 从 v$transp