tts oracle,TTS与XTTS配置

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