XTTS 跨平台表空间迁移测试

最新推荐文章于 2024-01-04 17:18:34 发布
最新推荐文章于 2024-01-04 17:18:34 发布
阅读量200 收藏
点赞数
官方文档XTTS：
Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (文档 ID 1389592.1)
测试环境：11.2.0.3.0 
辅助数据库：11.2.0.4.0 ==《安装在目标数据库。

1，建立配置文件    xtt.properties和相关目录。
tablespaces=SNOW
platformid=10
backupformat=/xtts/bak
backupondest=/xtts/bak
dfcopydir=/xtts/bak
stageondest=/xtts/bak
storageondest=/u02/test
cnvinst_home=/u01/app/oracle/product/11.2.0/dbhome_2
cnvinst_sid=xtt


 2，在原数据库执行初始化操作。

[oracle@edbjr2p1 ~]$ perl xttdriver.pl -p


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Starting prepare phase
--------------------------------------------------------------------
Prepare source for Tablespaces:
                  'SNOW'  /xtts/bak
xttpreparesrc.sql for 'SNOW' started at Tue May 16 16:59:46 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:46 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:49 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:49 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:50 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:50 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:51 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:51 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:51 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:51 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:52 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:52 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:52 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:52 2017
Prepare source for Tablespaces:
                  ''  /xtts/bak
xttpreparesrc.sql for '' started at Tue May 16 16:59:53 2017
xttpreparesrc.sql for  ended at Tue May 16 16:59:53 2017


--------------------------------------------------------------------
Done with prepare phase
--------------------------------------------------------------------


3，在目标数据库执行转换


[oracle@edbjr2p1 ~]$ perl xttdriver.pl -c


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Performing convert
--------------------------------------------------------------------


--------------------------------------------------------------------
Converted datafiles listed in: /home/oracle/xtt/xttnewdatafiles.txt
--------------------------------------------------------------------

4，模拟业务，建立测试业表

SQL> create table test tablespace snow as select * from dba_objects;
Table created.
SQL> select count(*) from test;
  COUNT(*)
----------
     75193

5，执行增量备份==原端











[oracle@edbjr2p1 ~]$ perl xttdriver.pl -i


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
Prepare newscn for Tablespaces: 'SNOW' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
rman target /  cmdfile /home/oracle/xtt/rmanincr.cmd


Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 16 17:05:04 2017


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: PROD1 (DBID=2082231315)


RMAN> set nocfau;
2> host 'echo ts::SNOW';
3> backup incremental from scn 1194918 
4>   tag tts_incr_update tablespace 'SNOW'  format
5>  '/xtts/bak/%U';
6> 
executing command: SET NOCFAU
using target database control file instead of recovery catalog


ts::SNOW
host command complete


Starting backup at 16-MAY-17


allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=144 device type=DISK
backup will be obsolete on date 23-MAY-17
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/PROD1/SNOW01.DBF
input datafile file number=00007 name=/u01/app/oracle/oradata/PROD1/snow02.dbf
channel ORA_DISK_1: starting piece 1 at 16-MAY-17
channel ORA_DISK_1: finished piece 1 at 16-MAY-17
piece handle=/xtts/bak/1as4d9m1_1_1 tag=TTS_INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01


using channel ORA_DISK_1
backup will be obsolete on date 23-MAY-17
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 16-MAY-17
channel ORA_DISK_1: finished piece 1 at 16-MAY-17
piece handle=/xtts/bak/1bs4d9m2_1_1 tag=TTS_INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-MAY-17


Recovery Manager complete.




--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------

6，恢复增量数据




[oracle@edbjr2p1 ~]$ perl xttdriver.pl -r


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------


--------------------------------------------------------------------
End of rollforward phase
--------------------------------------------------------------------

7，原端设置成为只读表，并增量备份。

[oracle@edbjr2p1 ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.3.0 Production on Tue May 16 17:07:54 2017


Copyright (c) 1982, 2011, Oracle.  All rights reserved.




Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> alter tablespace snow read only;


Tablespace altered.


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@edbjr2p1 ~]$ perl xttdriver.pl -i


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
Prepare newscn for Tablespaces: 'SNOW' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
Prepare newscn for Tablespaces: '' 
rman target /  cmdfile /home/oracle/xtt/rmanincr.cmd


Recovery Manager: Release 11.2.0.3.0 - Production on Tue May 16 17:08:05 2017


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


connected to target database: PROD1 (DBID=2082231315)


RMAN> set nocfau;
2> host 'echo ts::SNOW';
3> backup incremental from scn 1194918 
4>   tag tts_incr_update tablespace 'SNOW'  format
5>  '/xtts/bak/%U';
6> 
executing command: SET NOCFAU
using target database control file instead of recovery catalog


ts::SNOW
host command complete


Starting backup at 16-MAY-17


allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
backup will be obsolete on date 23-MAY-17
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/PROD1/SNOW01.DBF
input datafile file number=00007 name=/u01/app/oracle/oradata/PROD1/snow02.dbf
channel ORA_DISK_1: starting piece 1 at 16-MAY-17
channel ORA_DISK_1: finished piece 1 at 16-MAY-17
piece handle=/xtts/bak/1cs4d9rm_1_1 tag=TTS_INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01


using channel ORA_DISK_1
backup will be obsolete on date 23-MAY-17
archived logs will not be kept or backed up
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 16-MAY-17
channel ORA_DISK_1: finished piece 1 at 16-MAY-17
piece handle=/xtts/bak/1ds4d9rn_1_1 tag=TTS_INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 16-MAY-17


Recovery Manager complete.




--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------


8，目标端导入增量数据
[oracle@edbjr2p1 ~]$ perl xttdriver.pl -r


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------


--------------------------------------------------------------------
End of rollforward phase
--------------------------------------------------------------------


9，传输表空间---目标库执行

[oracle@edbjr2p1 ~]$ perl xttdriver.pl -e


--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------


--------------------------------------------------------------------
Generating plugin
--------------------------------------------------------------------


--------------------------------------------------------------------
Done generating plugin file /home/oracle/xtt/xttplugin.txt
--------------------------------------------------------------------
[oracle@edbjr2p1 ~]$ cat xtt/xttplugin.txt 
impdp directory=<DATA_PUMP_DIR> logfile=<tts_imp.log> \
network_link=<ttslink> transport_full_check=no \
transport_tablespaces=SNOW \
transport_datafiles='/u02/test/SNOW_6.xtf','/u02/test/SNOW_7.xtf'
[oracle@edbjr2p1 ~]$ impdp directory=snow network_link=snow transport_tablespaces=SNOW transport_datafiles=/u02/test/SNOW_6.xtf,/u02/test/SNOW_7.xtf


Import: Release 11.2.0.3.0 - Production on Tue May 16 17:10:37 2017


Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Username: / as sysdba


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01":  /******** AS SYSDBA directory=snow network_link=snow transport_tablespaces=SNOW transport_datafiles=/u02/test/SNOW_6.xtf,/u02/test/SNOW_7.xtf 
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 17:11:10


10. 验证数据库，表空间设置为读写模式===目标数据库


SQL> select count(*) from test;


  COUNT(*)
----------
     75193


SQL> alter tablespace snow read write;


Tablespace altered.







来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20747382/viewspace-2139162/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20747382/viewspace-2139162/

coilwv820340
关注
xtts_v4 跨平台迁移数据库表空间之 - 19C
Ahern_的博客
05-08 828
dest_scratch_location=/u01/xtts/xtts_rman_dir -- 目标系统备份文件存储位置，我测试采用的NFS挂载共享目录与源共享同一目录，减少拷贝时间。dest_datafile_location=/u01/app/oracle/oradata/ORCL -- 目标数据库数据文件存储位置。src_scratch_location=/u01/xtts/xtts_rman_dir -- 源备份文件存储位置。注意，完成元数据导入后需要修改目标用户默认表空间。
实战xtts迁移12C到19c
07-26
* 跨平台迁移：XTTS 可以将数据库从一个平台迁移到另一个平台，包括跨操作系统、架构和版本的迁移。 XTTS 迁移的步骤包括： 1. 准备源端和目标端，包括创建 XTTS 工作目录、上传和解压 xttsconvert 脚本、创建相关...
oracle xtts 测试,XTTS 跨平台表空间迁移测试
weixin_32183427的博客
04-09 412
简介这两天一直在研究xtts(跨平台表空间迁移的方法)，因为一是网上的资源不是很多，二是个人感觉这是个很实用的迁移技巧。下面就和大家来分享一下我个人做的测试过程吧。1、搭建测试环境跨平台表空间迁移过程 (参考文档官方1389592.1)--过程主要分为四个部分1、初始化阶段2、准备阶段3、增量备份前滚阶段4、运输或叫迁移阶段Phase 1 - 初始化安装Step 1.1 - 在目标端安装数据...
XTTS跨平台表空间增量迁移
cnb71835的博客
03-18 495
测试环境文档，非正式环境迁移文档，免去涉密因素 一、准备工作 1.1、平台检查 column platform_name format a30 ...
通过XTTS传输表空间方法实现数据库迁移步骤以及思路
狗剩儿的记忆博客
02-05 1235
文章目录前言一、前期准备工作：1.准备目标库环境，保证与源库字符集相同！2.确认源端数据库处于归档模式3.收集源端数据库信息，主要包括：二、具体实施工作：1.建立nfs，节省文件传输时间（可选）2.导出源库用户创建脚本，并在目标端进行创建3.修改归档模式，并添加归档日志删除脚本及任务4.源端做0级备份5.0级备份传输后在目标库进行0级备份文件提取6.源端做一次1级备份7.目标端一级备份恢复8.测试时间段可重复6~7步骤9.源端设置表空间只读（read only）----停机开始10.源端做最后一次1级备份1
Oracle跨平台迁移
04-01
### Oracle跨平台迁移知识点 #### 一、Oracle跨平台迁移概览 Oracle数据库跨平台迁移是指将现有的Oracle数据库从一个操作系统平台迁移到另一个操作系统平台上，同时也可能伴随着版本的升级。跨平台迁移通常需要...
VER4.3版本发布：Oracle跨平台表空间传输新工具xtts rman_xttconvert
需要注意的是，进行跨平台表空间传输时，由于不同平台可能有不同的字节序（Endianness）和操作系统特性，所以在执行XTT之前，DBA需要对源和目标平台进行详尽的兼容性测试，以确保数据的正确传输和应用的正常运行。...
深入浅出XTTS：Oracle数据库迁移升级利器（附PPT）
weixin_34375054的博客
05-16 1398
师介绍杨光 新炬网络高级工程师 近十年数据库运维、数据分析、数据库设计以及系统规划建设经验。 长期为国内电信运营商的大型IT系统进行系统软件运维、数据架构规划、设计和实施以及大型IT系统数据建模工作。 在大数据平台技术架构以及大数据资产管理方面有着深入的研究。 演讲大纲： 1.什么是XTTS 2. 适用场景 3. XTTS的基...
ORACLE XTTS
10-08
解决XTTS无法迁移除表、索引、序列外的元数据问题
XTTS软件+文档.rar
04-06
最近整理Oracle异构迁移工具，把软件和官方文档拿出来跟大家分享，当时在MOS中搜了很长时间，其中包括xttsconvert 2.0 v3 ver4.3和对应的官方文档，希望可以对行里玩Oracle的大牛们有所帮助。
Oracle异构迁移工具XTTS软件+文档.rar
12-14
最近整理Oracle异构迁移工具，把软件和官方文档拿出来跟大家分享，当时在MOS中搜了很长时间，其中包括xttsconvert 2.0 v3 ver4.3和对应的官方文档，希望可以对行里玩Oracle的大牛们有所帮助。
Oracle xtts同平台迁移测试
Kay的博客
03-05 704
Oracle xtts同平台迁移测试 1、环境检查 2、源库开启块跟踪 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/u02/changetracking.chg'; 3、挂载nfs存储 4、确认scn记录 作为后续增量备份的开始scn，起始点 alter system checkpoint; select current_s...
XTTS 简介
Ryan——进阶之路
06-01 7451
传输表空间技术从 Oracle8i 诞生，甲骨文公司经过多个版本的不停的改进完善，时至今日已经发展成为跨平台大数据量迁移的一大利器，尤其从 Oracle11.2.0.3 以后 XTTS 推出使用跨平台增量备份的方式，通过迁移不同字节序格式系统之间的数据，大大的减少了停机的时间。 一、XTTS发展 从8i，tts技术的诞生，引入了相同平台相同块大小之间的表空间传输。到了9i，tts开始支持同
oracle XTTS介绍
weixin_34168880的博客
03-25 1422
2019独角兽企业重金招聘Python工程师标准>>> ...
深入浅出XTTS：Oracle数据库迁移升级利器
最新发布
一个只求实际的程序猿
01-04 2045
来看一下这个XTTS整个的时间流程,准备阶段、初始化和N次增量备份恢复,这些都是迁移之前的,只需要考虑实际停业务的时间,这段时间做表空间只读,增量备份恢复,元数据导入,数据校验.知道表空间的只读和数据的校验,这两个时间是固定的,表空间只读速度很快,关键的时间点是增量的备份和恢复的时间,以及元数据的导入时间.
【XTTS】XTTS使用说明
weixin_34414650的博客
09-27 246
【XTTS】XTTS使用说明 迁移神技 XTTS-恩墨小王子再战32TB跨平台U2L 2016-09-27 ...
使用XTTS增量进行HP Unix到Soalris Sparc的数据库迁移
Roger的数据库专栏
05-07 1510
自从2015年初进行了xtts增量的U2L迁移测试之后，国内很多人都开始利用这种方案进行数据库跨平台迁移了，基本上都是利用Oracle 封装的perl脚本。
Oracle跨平台迁移：数据泵与XTTS方案解析
而XTTS（Transparent Tablespace Transportable）是一种更为复杂的迁移技术，它允许在不同平台间移动整个表空间，包括数据、索引和约束。无论是传统的XTTS迁移还是增量XTTS迁移，都需要仔细的规划和执行。传统XTTS...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值