create user zhangshuai identified by oracle default tablespace test;
grant connect,resource to zhangshuai;
select PLATFORM_ID from V$DATABASE;
Phase 1 - Initial Setup
Step 1.1 - Install the Destination Database Software and Create the Destination
Database
安装目标主机的数据库和实例
Step 1.2 - If necessary, Configure the Incremental Convert Home and Instance
如果目标主机数据库版本低于 11.2.0.4,需要安装 11.2.0.4 的数据库软件
Step 1.3 - Identify Tablespaces to be Transported
确定需要传输的表空间
Step 1.4 - If Using dbms_file_transfer Prepare Phase Method, then Configure
Directory Objects and Database Links
配置 source,target 的 directory
source 端
PS:/u01/app/oracle/oradata/xttssrc 为数据文件路径
create directory sourcedir as '/u01/app/oracle/oradata/xttssrc';
col DIRECTORY_PATH for a60
col owner for a20
col directory_name for a25
set linesize 200
select owner,directory_name,DIRECTORY_PATH from dba_directories;
目标端
PS:/u01/app/oracle/oradata/xttstar 为数据文件路径
create directory destdir as '/u01/app/oracle/oradata/xttstar';
create public database link ttslink connect to SYSTEM identified by oracle using
'192.168.50.213:1521/xttssrc';
select * from dual@ttslink;
Step 1.5 - Create Staging Areas
Create the staging areas on the source and destinations systems as defined by
the following xtt.properties parameters: backupformat, backupondest.
Also, if using RMAN backups in the Prepare phase, create the staging areas on
the source and destinations systems as defined by the following xtt.properties
parameters: dfcopydir, stageondest.
Step 1.6 - Install xttconvert Scripts on the Source System
传输 XTTS 软件包到 source 系统
Step 1.7 - Configure xtt.properties on the Source System
tablespaces=TEST,TEST_IDX
platformid=13
srcdir=SOURCEDIR
dstdir=DESTDIR
srclink=TTSLINK
backupformat=/u01/soft/xtts/rmanbak
stageondest=/u01/soft/xtts/rmanbak
storageondest=/u01/app/oracle/oradata/xttstar
backupondest=/u01/soft/xtts/rmanbak
parallel=3
评论