开发者社区> jan1990> 正文

xtt.properties

简介: Reduce Transportable Tablespace Downtime using Incremental Backups (Doc ID 1389592.1) Properties file for xttdriver.
+关注继续查看

Reduce Transportable Tablespace Downtime using Incremental Backups

(Doc ID 1389592.1)

Properties file for xttdriver.pl

Properties to set are the following:

tablespaces

platformid

srcdir

dstdir

srclink

dfcopydir

backupformat

stageondest

storageondest

backupondest

cnvinst_home

cnvinst_sid

asm_home

asm_sid

parallel

rollparallel

getfileparallel

metatransfer

destuser

desthost

desttmpdir

See documentation below and My Oracle Support Note 1389592.1 for details.

Tablespaces to transport

========================

tablespaces

-----------

Comma separated list of tablespaces to transport from source database

to destination database.

Specify tablespace names in CAPITAL letters.

tablespaces=TS1,TS2

Source database platform ID

===========================

platformid

----------

Source database platform id, obtained from V$DATABASE.PLATFORM_ID

platformid=2

Parameters required for Prepare Phase method dbms_file_transfer

===============================================================

srcdir

------

Directory object in the source database that defines where the source

datafiles currently reside.

Feb 2015: Ver2: We support multiple SOURCEDIR's.

NOTE: Number of entries in srcir and dstdir should match.

The srcdir to dstdir mapping can either be N:1 or N:N i.e. there can be

multiple source dirs and the files will be written to a single destination

directory, or files from a particular source dir can be written to a

particular destination directory

Example [N:1, allowed]

======================

srcdir=SRC1,SRC2

dstdir=DST

In this case the files from SRC1, SRC2 will be written to DST

Example [N:N, allowed]

======================

srcdir=SRC1,SRC2

dstdir=DST1,DST2

In this case the files from SRC1 will be written to DST1, SRC2 to DST2.

Example [N:M, not allowed]

==========================

srcdir=SRC1,SRC2,SRC3

dstdir=DST1,DST2

This is not allowed and will result in error.

srcdir=SOURCEDIR1,SOURCEDIR2

dstdir

------

Directory object in the destination database that defines where the

destination datafiles will be created.

Feb 2015: Ver2: We support multiple DESTDIR's.

SOURCEDIR1 will map to DESTDIR1 and SOURCEDIR2 to DESTDIR2 and so on

Refer to above parameter for more examples

dstdir=DESTDIR1,DESTDIR2

srclink

-------

Database link in the destination database that refers to the source

database. Datafiles will be transferred over this database link using

dbms_file_transfer.

srclink=TTSLINK

Source system file locations

============================

dfcopydir

---------

This parameter is used only when Prepare phase method is RMAN backup.

Location where datafile copies are created during the "-p prepare" step.

This location must have sufficient free space to hold copies of all

datafiles being transported.

This location may be an NFS-mounted filesystem that is shared with the

destination system, in which case it should reference the same NFS location

as the stageondest property for the destination system.

dfcopydir=/stage_source

backupformat

------------

Location where incremental backups are created.

This location may be an NFS-mounted filesystem that is shared with the

destination system, in which case it should reference the same NFS location

as the stageondest property for the destination system.

backupformat=/stage_source

Destination system file locations

=================================

stageondest

-----------

Location where datafile copies are placed by the user when they are

transferred manually from the souce system. This location must have

sufficient free space to hold copies of all datafiles being transported.

This is also the location from where datafiles copies and incremental

backups are read when they are converted in the "-c conversion of datafiles"

and "-r roll forward datafiles" steps.

This location may be a DBFS-mounted filesystem.

This location may be an NFS-mounted filesystem that is shared with the

source system, in which case it should reference the same NFS location

as the dfcopydir and backupformat properties for the source system.

stageondest=/stage_dest

storageondest

-------------

This parameter is used only when Prepare phase method is RMAN backup.

Location where the converted datafile copies will be written during the

"-c conversion of datafiles" step. This is the final location of the

datafiles where they will be used by the destination database.

storageondest=+DATA

backupondest

------------

Location where converted incremental backups on the destination system

will be written during the "-r roll forward datafiles" step.

NOTE: If this is set to an ASM location then define properties

asm_home and asm_sid below. If this is set to a file system

location, then comment out asm_home and asm_sid below

backupondest=+RECO

Database home and SID settings for destination system instances

===============================================================

cnvinst_home, cnvinst_sid

-------------------------

Database home and SID of the incremental convert instance that

runs on the destination system.

Only set these parameters if a separate incremental convert home is in use.

cnvinst_home=/u01/app/oracle/product/11.2.0.4/xtt_home

cnvinst_sid=xtt

asm_home, asm_sid

-----------------

Grid home and SID for the ASM instance that runs on the destination

system.

NOTE: If backupondest is set to a file system location, then comment out

both asm_home and asm_sid.

asm_home=/u01/app/11.2.0.4/grid

asm_sid=+ASM1

Parallel parameters

===================

parallel

--------

Parallel defines the channel parallelism used in copying (prepare phase),

converting.

Note: Incremental backup creation parallelism is defined by RMAN

configuration for DEVICE TYPE DISK PARALLELISM.

If undefined, default value is 8.

parallel=3

rollparallel

------------

Defines the level of parallelism for the -r roll forward operation.

If undefined, default value is 0 (serial roll forward).

rollparallel=2

getfileparallel

---------------

Defines the level of parallelism for the -G operation

If undefined, default value is 1. Max value supported is 8.

This will be enhanced in the future to support more than 8

depending on the destination system resources.

getfileparallel=4

metatransfer

---------------

If passwordless ssh is enabled between the source and the destination, the

script can automatically transfer the temporary files and the backups from

source to destination. Other parameters like desthost, desttmpdir needs to

be defined for this to work. destuser is optional

metatransfer=1

destuser

---------

The username that will be used for copying the files from source to dest

using scp. This is optional

destuser=username

desthost

--------

This will be the name of the destination host.

desthost=machinename

desttmpdir

---------------

This should be defined to same directory as TMPDIR for getting the

temporary files. The incremental backups will be copied to directory pointed

by stageondest parameter.

desttmpdir=/tmp

dumpdir

---------

The directory in which the dump file be restored to. If this is not specified

then TMPDIR is used.

dumpdir=/tmp

using scp. This is optional

destuser=username

END

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
如何设置阿里云服务器安全组?阿里云安全组规则详细解说
阿里云安全组设置详细图文教程(收藏起来) 阿里云服务器安全组设置规则分享,阿里云服务器安全组如何放行端口设置教程。阿里云会要求客户设置安全组,如果不设置,阿里云会指定默认的安全组。那么,这个安全组是什么呢?顾名思义,就是为了服务器安全设置的。安全组其实就是一个虚拟的防火墙,可以让用户从端口、IP的维度来筛选对应服务器的访问者,从而形成一个云上的安全域。
18580 0
阿里云服务器如何登录?阿里云服务器的三种登录方法
购买阿里云ECS云服务器后如何登录?场景不同,阿里云优惠总结大概有三种登录方式: 登录到ECS云服务器控制台 在ECS云服务器控制台用户可以更改密码、更换系.
27723 0
阿里云服务器安全组设置内网互通的方法
虽然0.0.0.0/0使用非常方便,但是发现很多同学使用它来做内网互通,这是有安全风险的,实例有可能会在经典网络被内网IP访问到。下面介绍一下四种安全的内网互联设置方法。 购买前请先:领取阿里云幸运券,有很多优惠,可到下文中领取。
21933 0
阿里云服务器端口号设置
阿里云服务器初级使用者可能面临的问题之一. 使用tomcat或者其他服务器软件设置端口号后,比如 一些不是默认的, mysql的 3306, mssql的1433,有时候打不开网页, 原因是没有在ecs安全组去设置这个端口号. 解决: 点击ecs下网络和安全下的安全组 在弹出的安全组中,如果没有就新建安全组,然后点击配置规则 最后如上图点击添加...或快速创建.   have fun!  将编程看作是一门艺术,而不单单是个技术。
19980 0
阿里云服务器ECS登录用户名是什么?系统不同默认账号也不同
阿里云服务器Windows系统默认用户名administrator,Linux镜像服务器用户名root
15287 0
腾讯云服务器 设置ngxin + fastdfs +tomcat 开机自启动
在tomcat中新建一个可以启动的 .sh 脚本文件 /usr/local/tomcat7/bin/ export JAVA_HOME=/usr/local/java/jdk7 export PATH=$JAVA_HOME/bin/:$PATH export CLASSPATH=.
14852 0
阿里云服务器怎么设置密码?怎么停机?怎么重启服务器?
如果在创建实例时没有设置密码,或者密码丢失,您可以在控制台上重新设置实例的登录密码。本文仅描述如何在 ECS 管理控制台上修改实例登录密码。
23523 0
+关注
43
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
JS零基础入门教程(上册)
立即下载
性能优化方法论
立即下载
手把手学习日志服务SLS,云启实验室实战指南
立即下载