前言
XTTS作为Oracle很受欢迎的数据迁移方式之一，本文将详细描述整个过程，大概主要迁移阶段分为：全量阶段、增量阶段、最后增量阶段和元数据迁移阶段。
xtts优点：
跨平台，跨版本，停机时间短，一致性高，适用大数据量的环境等
xtts缺点：
操作难度高，比较复杂等
参考MOS
V4 Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup(Doc ID 2471245.1)
本文环境：
源数据库版本：11.2.0.4 单实例
源平台：aix7.1
目标数据库版本：19.3.0.0 RAC CDB
目标平台：linux 7 x86
业务表空间：
JANTBS
DOGTBS
ZLYTBS
xtts脚本工具：V4
一、环境检查
源端平台信息检查
line 300
col PLATFORM_NAME for a40
select a.PLATFORM_ID,a.PLATFORM_NAME,a.ENDIAN_FORMAT from v$transportable_platform a, v$database b where a.PLATFORM_NAME=b.PLATFORM_NAME;
SQL> SQL>
PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- ---------------------------------------- --------------
6 AIX-Based Systems (64-bit) Big
Note：
记录平台ID，下面需要用到。
字符集检查
set line 300
col value$ for A40;
select name, value$ from props$ where name like '%CHARACTERSET%';
源：
NAME VALUE$
------------------------------ ----------------------------------------
NLS_CHARACTERSET ZHS16GBK
NLS_NCHAR_CHARACTERSET AL16UTF16
目标PDB：
NAME VALUE$
------------------------------ ----------------------------------------
NLS_CHARACTERSET ZHS16GBK
NLS_NCHAR_CHARACTERSET AL16UTF16
Note：源端和目标端的字符集需要保持一致。
数据文件检查
select ts#,file#,status from v$datafile where status not in ('ONLINE','SYSTEM');
no rows selected
SQL>
Note：
检查是否有不正常的数据文件。
表空间自包含检查
execute DBMS_TTS.TRANSPORT_SET_CHECK('JANTBS,DOGTBS,ZLYTBS',TRUE,TRUE);
select * from TRANSPORT_SET_VIOLATIONS;
SQL> execute DBMS_TTS.TRANSPORT_SET_CHECK('JANTBS,DOGTBS,ZLYTBS',TRUE,TRUE);
PL/SQL procedure successfully completed.
SQL> select * from TRANSPORT_SET_VIOLATIONS;
no rows selected
SQL>
Note：
主要检查是否有对象关联在系统表空间（SYSTEM,SYSAUX），
关联在系统表空间的对象需要迁移到非系统的表空间，
有关联的表空间需要一并传输。
二、XTTS配置
配置TNS
FORDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.73)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = fordb)
)
)
MYPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.75)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mypdb)
)
)
Note：
rac注意，pdb配置单节点的vip
创建目录
源：
mkdir /home/oracle/xtts
mkdir -p /oracle/xttsbk
目标：
mkdir /home/oracle/xtts
mkdir -p /backup/xttsbk
解压
unzip -d /home/oracle/xtts rman_xttconvert_VER4.3.zip
[oracle@aix173 /home/oracle/xtts]$ls -lrt
total 528
-rw-r--r-- 1 oracle oinstall 1390 May 24 2017 xttcnvrtbkupdest.sql
-rw-r--r-- 1 oracle oinstall 52 May 24 2017 xttstartupnomount.sql
-rw-r--r-- 1 oracle oinstall 11710 May 24 2017 xttprep.tmpl
-rw-r--r-- 1 oracle oinstall 71 May 24 2017 xttdbopen.sql
-rw-r--r-- 1 oracle oinstall 5169 Feb 19 2019 xtt.newproperties
-rw-r--r-- 1 oracle oinstall 5169 Feb 19 2019 xtt.properties
-rw-r--r-- 1 oracle oinstall 180408 Jul 07 2019 xttdriver.pl
配置属性文件
cd xtts
vi xtt.properties
tablespaces=JANTBS,DOGTBS,ZLYTBS
platformid=6
src_scratch_location=/oracle/xttsbk
dest_scratch_location=/backup/xttsbk
dest_datafile_location=+DATA
parallel=3
destconnstr=sys/oracle@mypdb
Note：
平台ID是源平台的ID，
CDB环境需要设置连接串，
parallel可以根据数据量进行修改。
拷贝脚本到目标端
scp -r /home/oracle/xtts 192.168.11.75:/home/oracle/
配置临时目录环境变量
export TMPDIR=/home/oracle/xtts
Note：源和目标均需要配置
三、0级（全备）备份还原
备份
cd xtts
$ORACLE_HOME/perl/bin/perl xttdriver.pl --backup --debug 3
Note：嫌备份过程信息太多，可以不加 - -debug 3 参数
============================================================
trace file is /home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//Aug10_Tue_16_05_00_814_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: platformid
Values: 6
Key: src_scratch_location
Values: /oracle/xttsbk
Key: parallel
Values: 3
Key: dest_scratch_location
Values: /backup/xttsbk
Key: dest_datafile_location
Values: +DATA
Key: rollparallel
Values: 2
Key: tablespaces
Values: JANTBS,DOGTBS,ZLYTBS
Key: destconnstr
Values: sys/oracle@mypdb
Key: getfileparallel
Values: 4
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : fordb
ORACLE_HOME : /oracle/app/oracle/product/11.2.0.4/dbhome_1
112040
PRIMARY
Running on PRIMARY
--------------------------------------------------------------------
Starting prepare phase
--------------------------------------------------------------------
Parallel:3
scalar(or3
XXX: adding here for 2, 0, JANTBS,DOGTBS,ZLYTBS
XXX: adding proper here for index 0, b4 added 'ZLYTBS'
,
XXX: adding proper here for index 0, added 'ZLYTBS'
XXX: adding proper here for index 1, b4 added 'DOGTBS'
,
XXX: adding proper here for index 1, added 'DOGTBS'
--------------------------------------------------------------------
Find list of datafiles in system
--------------------------------------------------------------------
sqlplus -L -s / as sysdba @/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//diff.sql +DATA
::JANTBS5,+DATA/JANTBS_5.dbf
8,+DATA/JANTBS_8.dbf
::DOGTBS
6,+DATA/DOGTBS_6.dbf
9,+DATA/DOGTBS_9.dbf
::ZLYTBS
7,+DATA/ZLYTBS_7.dbf
10,+DATA/ZLYTBS_10.dbf
--------------------------------------------------------------------
Done finding list of datafiles in system
--------------------------------------------------------------------
/ as sysdba
size of tablespace 3
No. of tablespaces per batch 1
TABLESPACE STRING :'JANTBS'
Prepare source for Tablespaces:
'JANTBS' /backup/xttsbk
xttpreparesrc.sql for 'JANTBS' started at Tue Aug 10 16:05:01 2021
#PLAN:JANTBS::::972744
#CONVERT:host 'echo ts::JANTBS';
#CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
#CONVERT: datafile
backup as copy tag 'prepare' datafile
#CONVERT: '/backup/xttsbk/JANTBS_5.tf'
5
#PLAN:5
#CONVERT: ,'/backup/xttsbk/JANTBS_8.tf'
,8
#PLAN:8
#CONVERT: format '+DATA/%N_%f.dbf'
#CONVERT: parallelism 3;
format '/oracle/xttsbk/%N_%f.tf';
xttpreparesrc.sql for ended at Tue Aug 10 16:05:01 2021
#PLAN:JANTBS::::972744#CONVERT:host 'echo ts::JANTBS';
#CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
#CONVERT: datafile
backup as copy tag 'prepare' datafile
#CONVERT: '/backup/xttsbk/JANTBS_5.tf'
5
#PLAN:5
#CONVERT: ,'/backup/xttsbk/JANTBS_8.tf'
,8
#PLAN:8
#CONVERT: format '+DATA/%N_%f.dbf'
#CONVERT: parallelism 3;
format '/oracle/xttsbk/%N_%f.tf';
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttprepare.cmd
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Aug 10 16:05:01 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: FORDB (DBID=498190680)
RMAN> #PLAN:JANTBS::::972744
2> #CONVERT:host 'echo ts::JANTBS';
3> #CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
4> #CONVERT: datafile
5> backup as copy tag 'prepare' datafile
6> #CONVERT: '/backup/xttsbk/JANTBS_5.tf'
7> 5
8> #PLAN:5
9> #CONVERT: ,'/backup/xttsbk/JANTBS_8.tf'
10> ,8
11> #PLAN:8
12> #CONVERT: format '+DATA/%N_%f.dbf'
13> #CONVERT: parallelism 3;
14> format '/oracle/xttsbk/%N_%f.tf';
15>
RMAN-03090: Starting backup at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=146 device type=DISK
RMAN-08580: channel ORA_DISK_1: starting datafile copy
RMAN-08522: input datafile file number=00005 name=/oracle/app/oracle/oradata/fordb/jantbs01.dbf
RMAN-08586: output file name=/oracle/xttsbk/JANTBS_5.tf tag=PREPARE RECID=1 STAMP=1080230705
RMAN-08581: channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-08580: channel ORA_DISK_1: starting datafile copy
RMAN-08522: input datafile file number=00008 name=/oracle/app/oracle/oradata/fordb/jantbs02.dbf
RMAN-08586: output file name=/oracle/xttsbk/JANTBS_8.tf tag=PREPARE RECID=2 STAMP=1080230708
RMAN-08581: channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-03091: Finished backup at 10-AUG-21
Recovery Manager complete.
TABLESPACE STRING :'DOGTBS'
Prepare source for Tablespaces:
'DOGTBS' /backup/xttsbk
xttpreparesrc.sql for 'DOGTBS' started at Tue Aug 10 16:05:11 2021
#PLAN:DOGTBS::::972744
#CONVERT:host 'echo ts::DOGTBS';
#CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
#CONVERT: datafile
backup as copy tag 'prepare' datafile
#CONVERT: '/backup/xttsbk/DOGTBS_6.tf'
6
#PLAN:6
#CONVERT: ,'/backup/xttsbk/DOGTBS_9.tf'
,9
#PLAN:9
#CONVERT: format '+DATA/%N_%f.dbf'
#CONVERT: parallelism 3;
format '/oracle/xttsbk/%N_%f.tf';
xttpreparesrc.sql for ended at Tue Aug 10 16:05:11 2021
#PLAN:DOGTBS::::972744#CONVERT:host 'echo ts::DOGTBS';
#CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
#CONVERT: datafile
backup as copy tag 'prepare' datafile
#CONVERT: '/backup/xttsbk/DOGTBS_6.tf'
6
#PLAN:6
#CONVERT: ,'/backup/xttsbk/DOGTBS_9.tf'
,9
#PLAN:9
#CONVERT: format '+DATA/%N_%f.dbf'
#CONVERT: parallelism 3;
format '/oracle/xttsbk/%N_%f.tf';
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttprepare.cmd
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Aug 10 16:05:11 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: FORDB (DBID=498190680)
RMAN> #PLAN:DOGTBS::::972744
2> #CONVERT:host 'echo ts::DOGTBS';
3> #CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
4> #CONVERT: datafile
5> backup as copy tag 'prepare' datafile
6> #CONVERT: '/backup/xttsbk/DOGTBS_6.tf'
7> 6
8> #PLAN:6
9> #CONVERT: ,'/backup/xttsbk/DOGTBS_9.tf'
10> ,9
11> #PLAN:9
12> #CONVERT: format '+DATA/%N_%f.dbf'
13> #CONVERT: parallelism 3;
14> format '/oracle/xttsbk/%N_%f.tf';
15>
RMAN-03090: Starting backup at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=146 device type=DISK
RMAN-08580: channel ORA_DISK_1: starting datafile copy
RMAN-08522: input datafile file number=00006 name=/oracle/app/oracle/oradata/fordb/dogtbs01.dbf
RMAN-08586: output file name=/oracle/xttsbk/DOGTBS_6.tf tag=PREPARE RECID=3 STAMP=1080230715
RMAN-08581: channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-08580: channel ORA_DISK_1: starting datafile copy
RMAN-08522: input datafile file number=00009 name=/oracle/app/oracle/oradata/fordb/dogtbs02.dbf
RMAN-08586: output file name=/oracle/xttsbk/DOGTBS_9.tf tag=PREPARE RECID=4 STAMP=1080230719
RMAN-08581: channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-03091: Finished backup at 10-AUG-21
Recovery Manager complete.
TABLESPACE STRING :'ZLYTBS'
Prepare source for Tablespaces:
'ZLYTBS' /backup/xttsbk
xttpreparesrc.sql for 'ZLYTBS' started at Tue Aug 10 16:05:21 2021
#PLAN:ZLYTBS::::972744
#CONVERT:host 'echo ts::ZLYTBS';
#CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
#CONVERT: datafile
backup as copy tag 'prepare' datafile
#CONVERT: '/backup/xttsbk/ZLYTBS_7.tf'
7
#PLAN:7
#CONVERT: ,'/backup/xttsbk/ZLYTBS_10.tf'
,10
#PLAN:10
#CONVERT: format '+DATA/%N_%f.dbf'
#CONVERT: parallelism 3;
format '/oracle/xttsbk/%N_%f.tf';
xttpreparesrc.sql for ended at Tue Aug 10 16:05:21 2021
#PLAN:ZLYTBS::::972744#CONVERT:host 'echo ts::ZLYTBS';
#CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
#CONVERT: datafile
backup as copy tag 'prepare' datafile
#CONVERT: '/backup/xttsbk/ZLYTBS_7.tf'
7
#PLAN:7
#CONVERT: ,'/backup/xttsbk/ZLYTBS_10.tf'
,10
#PLAN:10
#CONVERT: format '+DATA/%N_%f.dbf'
#CONVERT: parallelism 3;
format '/oracle/xttsbk/%N_%f.tf';
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttprepare.cmd
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Aug 10 16:05:21 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: FORDB (DBID=498190680)
RMAN> #PLAN:ZLYTBS::::972744
2> #CONVERT:host 'echo ts::ZLYTBS';
3> #CONVERT: convert from platform 'AIX-Based Systems (64-bit)'
4> #CONVERT: datafile
5> backup as copy tag 'prepare' datafile
6> #CONVERT: '/backup/xttsbk/ZLYTBS_7.tf'
7> 7
8> #PLAN:7
9> #CONVERT: ,'/backup/xttsbk/ZLYTBS_10.tf'
10> ,10
11> #PLAN:10
12> #CONVERT: format '+DATA/%N_%f.dbf'
13> #CONVERT: parallelism 3;
14> format '/oracle/xttsbk/%N_%f.tf';
15>
RMAN-03090: Starting backup at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=146 device type=DISK
RMAN-08580: channel ORA_DISK_1: starting datafile copy
RMAN-08522: input datafile file number=00007 name=/oracle/app/oracle/oradata/fordb/zlytbs01.dbf
RMAN-08586: output file name=/oracle/xttsbk/ZLYTBS_7.tf tag=PREPARE RECID=5 STAMP=1080230726
RMAN-08581: channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-08580: channel ORA_DISK_1: starting datafile copy
RMAN-08522: input datafile file number=00010 name=/oracle/app/oracle/oradata/fordb/zlytbs02.dbf
RMAN-08586: output file name=/oracle/xttsbk/ZLYTBS_10.tf tag=PREPARE RECID=6 STAMP=1080230729
RMAN-08581: channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
RMAN-03091: Finished backup at 10-AUG-21
Recovery Manager complete.
--------------------------------------------------------------------
Done with prepare phase
--------------------------------------------------------------------
/ as sysdba
size of tablespace 3
No. of tablespaces per batch 1
TABLESPACE STRING :'JANTBS'
Prepare newscn for Tablespaces: 'JANTBS'
TABLESPACE STRING :'DOGTBS'
Prepare newscn for Tablespaces: 'DOGTBS'
TABLESPACE STRING :'ZLYTBS'
Prepare newscn for Tablespaces: 'ZLYTBS'
New /home/oracle/xtts/xttplan.txt with FROM SCN's generated
scalar(or3
XXX: adding here for 2, 0, JANTBS,DOGTBS,ZLYTBS
XXX: adding proper here for index 0, b4 added 'ZLYTBS'
,
XXX: adding proper here for index 0, added 'ZLYTBS'
XXX: adding proper here for index 1, b4 added 'DOGTBS'
,
XXX: adding proper here for index 1, added 'DOGTBS'
Number of tb arrays is 2
::JANTBS:::SCN:::9742035=974203,JANTBS,+DATA/JANTBS_5.dbf
8=974205,JANTBS,+DATA/JANTBS_8.dbf
::DOGTBS:::SCN:::974232
6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
::ZLYTBS:::SCN:::974278
7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
::JANTBS:::SCN:::974203
/home/oracle/xtts/newfile.txt: ::JANTBS:::SCN:::974203
/home/oracle/xtts/newfile.txt: 5=974203,JANTBS,+DATA/JANTBS_5.dbf
/home/oracle/xtts/newfile.txt: 8=974205,JANTBS,+DATA/JANTBS_8.dbf
/home/oracle/xtts/newfile.txt: ::DOGTBS:::SCN:::974232
/home/oracle/xtts/newfile.txt: 6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
/home/oracle/xtts/newfile.txt: 9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
/home/oracle/xtts/newfile.txt: ::ZLYTBS:::SCN:::974278
/home/oracle/xtts/newfile.txt: 7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
/home/oracle/xtts/newfile.txt: 10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: ::JANTBS:::SCN:::974203
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: 5=974203,JANTBS,+DATA/JANTBS_5.dbf
Writing new 5=974203,JANTBS,+DATA/JANTBS_5.dbf
Writing1 new 5, +DATA/JANTBS_5.dbf
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: 8=974205,JANTBS,+DATA/JANTBS_8.dbf
Writing new 8=974205,JANTBS,+DATA/JANTBS_8.dbf
Writing1 new 8, +DATA/JANTBS_8.dbf
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: ::DOGTBS:::SCN:::974232
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: 6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
Writing new 6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
Writing1 new 6, +DATA/DOGTBS_6.dbf
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: 9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
Writing new 9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
Writing1 new 9, +DATA/DOGTBS_9.dbf
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: ::ZLYTBS:::SCN:::974278
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: 7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
Writing new 7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
Writing1 new 7, +DATA/ZLYTBS_7.dbf
/home/oracle/xtts/backup_Aug10_Tue_16_05_00_814//xttnewdatafiles.txt.added: 10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
Writing new 10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
Writing1 new 10, +DATA/ZLYTBS_10.dbf
Added fname here 1:/backup/xttsbk/JANTBS_5.tf
Added fname here 1:/backup/xttsbk/JANTBS_8.tf
Added fname here 1:/backup/xttsbk/DOGTBS_6.tf
Added fname here 1:/backup/xttsbk/DOGTBS_9.tf
Added fname here 1:/backup/xttsbk/ZLYTBS_7.tf
Added fname here 1:/backup/xttsbk/ZLYTBS_10.tf
YYY: ::JANTBS:::SCN:::974203
YYY: ::DOGTBS:::SCN:::974232
YYY: ::ZLYTBS:::SCN:::974278
============================================================
No new datafiles added
=============================================================
[oracle@aix173 /home/oracle/xtts]$
拷贝
scp /oracle/xttsbk/* oracle@192.168.11.75:/backup/xttsbk
scp res.txt oracle@192.168.11.75:/home/oracle/xtts
还原
cd xtts
$ORACLE_HOME/perl/bin/perl xttdriver.pl --restore --debug 3
============================================================
trace file is /home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//Aug10_Tue_17_23_29_476_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: getfileparallel
Values: 4
Key: dest_scratch_location
Values: /backup/xttsbk
Key: platformid
Values: 6
Key: dest_datafile_location
Values: +DATA
Key: destconnstr
Values: sys/oracle@mypdb
Key: rollparallel
Values: 2
Key: tablespaces
Values: JANTBS,DOGTBS,ZLYTBS
Key: src_scratch_location
Values: /oracle/xttsbk
Key: parallel
Values: 3
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : wldb1
ORACLE_HOME : /oracle/app/oracle/product/19.0.0/dbhome_1
190000
#0:::5,6,JANTBS_5.dbf,0,972744,0,0,0,JANTBS,JANTBS_5.dbf
--------------------------------------------------------------------
Performing convert for file 5
--------------------------------------------------------------------
#0:::8,6,JANTBS_8.dbf,0,972744,0,0,0,JANTBS,JANTBS_8.dbf
--------------------------------------------------------------------
Performing convert for file 8
--------------------------------------------------------------------
/home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//rman_convert_JANTBS_8.cmd
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 10 17:23:31 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: WLDB:MYPDB (DBID=2736861097)
RMAN> convert from platform 'AIX-Based Systems (64-bit)' datafile '/backup/xttsbk/JANTBS_8.tf' format '+DATA/JANTBS_8.dbf' ;
2>
RMAN-03090: Starting conversion at target at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08605: channel ORA_DISK_1: SID=280 instance=wldb1 device type=DISK
RMAN-08589: channel ORA_DISK_1: starting datafile conversion
RMAN-08506: input file name=/backup/xttsbk/JANTBS_8.tf
RMAN-08588: converted datafile=+DATA/jantbs_8.dbf
RMAN-08590: channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:08
RMAN-03091: Finished conversion at target at 10-AUG-21
Recovery Manager complete.
#0:::6,6,DOGTBS_6.dbf,0,972744,0,0,0,DOGTBS,DOGTBS_6.dbf
--------------------------------------------------------------------
Performing convert for file 6
--------------------------------------------------------------------
/home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//rman_convert_JANTBS_5.cmd
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 10 17:23:31 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: WLDB:MYPDB (DBID=2736861097)
RMAN> convert from platform 'AIX-Based Systems (64-bit)' datafile '/backup/xttsbk/JANTBS_5.tf' format '+DATA/JANTBS_5.dbf' ;
2>
RMAN-03090: Starting conversion at target at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08605: channel ORA_DISK_1: SID=142 instance=wldb1 device type=DISK
RMAN-08589: channel ORA_DISK_1: starting datafile conversion
RMAN-08506: input file name=/backup/xttsbk/JANTBS_5.tf
RMAN-08588: converted datafile=+DATA/jantbs_5.dbf
RMAN-08590: channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
RMAN-03091: Finished conversion at target at 10-AUG-21
Recovery Manager complete.
#0:::9,6,DOGTBS_9.dbf,0,972744,0,0,0,DOGTBS,DOGTBS_9.dbf
--------------------------------------------------------------------
Performing convert for file 9
--------------------------------------------------------------------
/home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//rman_convert_DOGTBS_9.cmd
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 10 17:23:48 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: WLDB:MYPDB (DBID=2736861097)
RMAN> convert from platform 'AIX-Based Systems (64-bit)' datafile '/backup/xttsbk/DOGTBS_9.tf' format '+DATA/DOGTBS_9.dbf' ;
2>
RMAN-03090: Starting conversion at target at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08605: channel ORA_DISK_1: SID=142 instance=wldb1 device type=DISK
RMAN-08589: channel ORA_DISK_1: starting datafile conversion
RMAN-08506: input file name=/backup/xttsbk/DOGTBS_9.tf
RMAN-08588: converted datafile=+DATA/dogtbs_9.dbf
RMAN-08590: channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
RMAN-03091: Finished conversion at target at 10-AUG-21
Recovery Manager complete.
#0:::7,6,ZLYTBS_7.dbf,0,972744,0,0,0,ZLYTBS,ZLYTBS_7.dbf
--------------------------------------------------------------------
Performing convert for file 7
--------------------------------------------------------------------
/home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//rman_convert_DOGTBS_6.cmd
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 10 17:23:47 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: WLDB:MYPDB (DBID=2736861097)
RMAN> convert from platform 'AIX-Based Systems (64-bit)' datafile '/backup/xttsbk/DOGTBS_6.tf' format '+DATA/DOGTBS_6.dbf' ;
2>
RMAN-03090: Starting conversion at target at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08605: channel ORA_DISK_1: SID=409 instance=wldb1 device type=DISK
RMAN-08589: channel ORA_DISK_1: starting datafile conversion
RMAN-08506: input file name=/backup/xttsbk/DOGTBS_6.tf
RMAN-08588: converted datafile=+DATA/dogtbs_6.dbf
RMAN-08590: channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:08
RMAN-03091: Finished conversion at target at 10-AUG-21
Recovery Manager complete.
#0:::10,6,ZLYTBS_10.dbf,0,972744,0,0,0,ZLYTBS,ZLYTBS_10.dbf
--------------------------------------------------------------------
Performing convert for file 10
--------------------------------------------------------------------
/home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//rman_convert_ZLYTBS_10.cmd
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 10 17:24:02 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: WLDB:MYPDB (DBID=2736861097)
RMAN> convert from platform 'AIX-Based Systems (64-bit)' datafile '/backup/xttsbk/ZLYTBS_10.tf' format '+DATA/ZLYTBS_10.dbf' ;
2>
RMAN-03090: Starting conversion at target at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08605: channel ORA_DISK_1: SID=409 instance=wldb1 device type=DISK
RMAN-08589: channel ORA_DISK_1: starting datafile conversion
RMAN-08506: input file name=/backup/xttsbk/ZLYTBS_10.tf
RMAN-08588: converted datafile=+DATA/zlytbs_10.dbf
RMAN-08590: channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
RMAN-03091: Finished conversion at target at 10-AUG-21
Recovery Manager complete.
/home/oracle/xtts/restore_Aug10_Tue_17_23_29_476//rman_convert_ZLYTBS_7.cmd
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Aug 10 17:24:01 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: WLDB:MYPDB (DBID=2736861097)
RMAN> convert from platform 'AIX-Based Systems (64-bit)' datafile '/backup/xttsbk/ZLYTBS_7.tf' format '+DATA/ZLYTBS_7.dbf' ;
2>
RMAN-03090: Starting conversion at target at 10-AUG-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08605: channel ORA_DISK_1: SID=142 instance=wldb1 device type=DISK
RMAN-08589: channel ORA_DISK_1: starting datafile conversion
RMAN-08506: input file name=/backup/xttsbk/ZLYTBS_7.tf
RMAN-08588: converted datafile=+DATA/zlytbs_7.dbf
RMAN-08590: channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:07
RMAN-03091: Finished conversion at target at 10-AUG-21
Recovery Manager complete.
YYY:
[oracle@19c-h1 xtts]$
四、1级（增量）备份还原
Note：
此阶段可以一直重复下去，
直到源和目标数据差异很小，
有助于缩短停机时间。
建议开启块跟踪，有助于提升增量备份的速度。
alter database enable block change tracking using file '/oracle/app/oracle/oradata/fordb/bltracking.f';
备份
$ORACLE_HOME/perl/bin/perl xttdriver.pl --backup --debug 3
Note：从日志可以看到，已经开始进行增量备份了
============================================================
trace file is /home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//Aug10_Tue_17_30_25_716_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: platformid
Values: 6
Key: src_scratch_location
Values: /oracle/xttsbk
Key: parallel
Values: 3
Key: dest_scratch_location
Values: /backup/xttsbk
Key: dest_datafile_location
Values: +DATA
Key: rollparallel
Values: 2
Key: tablespaces
Values: JANTBS,DOGTBS,ZLYTBS
Key: destconnstr
Values: sys/oracle@mypdb
Key: getfileparallel
Values: 4
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : fordb
ORACLE_HOME : /oracle/app/oracle/product/11.2.0.4/dbhome_1
112040
PRIMARY
Running on PRIMARY
--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
scalar(or3
XXX: adding here for 2, 0, JANTBS,DOGTBS,ZLYTBS
XXX: adding proper here for index 0, b4 added 'ZLYTBS'
,
XXX: adding proper here for index 0, added 'ZLYTBS'
XXX: adding proper here for index 1, b4 added 'DOGTBS'
,
XXX: adding proper here for index 1, added 'DOGTBS'
Number of tb arrays is 2
::JANTBS:::SCN:::9742035=974203,JANTBS,+DATA/JANTBS_5.dbf
8=974205,JANTBS,+DATA/JANTBS_8.dbf
::DOGTBS:::SCN:::974232
6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
::ZLYTBS:::SCN:::974278
7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
::JANTBS:::SCN:::974203
/home/oracle/xtts/newfile.txt: ::JANTBS:::SCN:::974203
/home/oracle/xtts/newfile.txt: 5=974203,JANTBS,+DATA/JANTBS_5.dbf
/home/oracle/xtts/newfile.txt: 8=974205,JANTBS,+DATA/JANTBS_8.dbf
/home/oracle/xtts/newfile.txt: ::DOGTBS:::SCN:::974232
/home/oracle/xtts/newfile.txt: 6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
/home/oracle/xtts/newfile.txt: 9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
/home/oracle/xtts/newfile.txt: ::ZLYTBS:::SCN:::974278
/home/oracle/xtts/newfile.txt: 7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
/home/oracle/xtts/newfile.txt: 10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: ::JANTBS:::SCN:::974203
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: 5=974203,JANTBS,+DATA/JANTBS_5.dbf
Writing new 5=974203,JANTBS,+DATA/JANTBS_5.dbf
Writing1 new 5, +DATA/JANTBS_5.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: 8=974205,JANTBS,+DATA/JANTBS_8.dbf
Writing new 8=974205,JANTBS,+DATA/JANTBS_8.dbf
Writing1 new 8, +DATA/JANTBS_8.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: ::DOGTBS:::SCN:::974232
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: 6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
Writing new 6=974232,DOGTBS,+DATA/DOGTBS_6.dbf
Writing1 new 6, +DATA/DOGTBS_6.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: 9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
Writing new 9=974236,DOGTBS,+DATA/DOGTBS_9.dbf
Writing1 new 9, +DATA/DOGTBS_9.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: ::ZLYTBS:::SCN:::974278
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: 7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
Writing new 7=974278,ZLYTBS,+DATA/ZLYTBS_7.dbf
Writing1 new 7, +DATA/ZLYTBS_7.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//xttnewdatafiles.txt.added: 10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
Writing new 10=974280,ZLYTBS,+DATA/ZLYTBS_10.dbf
Writing1 new 10, +DATA/ZLYTBS_10.dbf
Added fname here 1:/backup/xttsbk/JANTBS_5.tf
Added fname here 1:/backup/xttsbk/JANTBS_8.tf
Added fname here 1:/backup/xttsbk/DOGTBS_6.tf
Added fname here 1:/backup/xttsbk/DOGTBS_9.tf
Added fname here 1:/backup/xttsbk/ZLYTBS_7.tf
Added fname here 1:/backup/xttsbk/ZLYTBS_10.tf
YYY: ::JANTBS:::SCN:::974203
YYY: ::DOGTBS:::SCN:::974232
YYY: ::ZLYTBS:::SCN:::974278
============================================================
No new datafiles added
=============================================================
/ as sysdba
size of tablespace 3
No. of tablespaces per batch 1
TABLESPACE STRING :'JANTBS'
Prepare newscn for Tablespaces: 'JANTBS'
JANTBS::::974203 5
8
TABLESPACE STRING :'DOGTBS'
Prepare newscn for Tablespaces: 'DOGTBS'
DOGTBS::::974232 6
9
TABLESPACE STRING :'ZLYTBS'
Prepare newscn for Tablespaces: 'ZLYTBS'
ZLYTBS::::974278 7
10
--------------------------------------------------------------------
Starting incremental backup
--------------------------------------------------------------------
/home/oracle/xtts/backup_Aug10_Tue_17_30_25_716//rmanincr.cmd
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Aug 10 17:30:27 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: FORDB (DBID=498190680)
RMAN> set nocfau;
2> host 'echo ts::JANTBS';
3> backup incremental from scn 972744
4> tablespace 'JANTBS' format
5> '/oracle/xttsbk/%U';
6> set nocfau;
7> host 'echo ts::DOGTBS';
8> backup incremental from scn 972744
9> tablespace 'DOGTBS' format
10> '/oracle/xttsbk/%U';
11> set nocfau;
12> host 'echo ts::ZLYTBS';
13> backup incremental from scn 972744
14> tablespace 'ZLYTBS' format
15> '/oracle/xttsbk/%U';
16>
RMAN-03023: executing command: SET NOCFAU
RMAN-06009: using target database control file instead of recovery catalog
ts::JANTBS
RMAN-06134: host command complete
RMAN-03090: Starting backup at 10-AUG-21
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=21 device type=DISK
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00005 name=/oracle/app/oracle/oradata/fordb/jantbs01.dbf
RMAN-08522: input datafile file number=00008 name=/oracle/app/oracle/oradata/fordb/jantbs02.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 10-AUG-21
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 10-AUG-21
RMAN-08530: piece handle=/oracle/xttsbk/090665pm_1_1 tag=TAG20210810T173030 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
RMAN-03091: Finished backup at 10-AUG-21
RMAN-03023: executing command: SET NOCFAU
ts::DOGTBS
RMAN-06134: host command complete
RMAN-03090: Starting backup at 10-AUG-21
RMAN-12016: using channel ORA_DISK_1
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00006 name=/oracle/app/oracle/oradata/fordb/dogtbs01.dbf
RMAN-08522: input datafile file number=00009 name=/oracle/app/oracle/oradata/fordb/dogtbs02.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 10-AUG-21
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 10-AUG-21
RMAN-08530: piece handle=/oracle/xttsbk/0a0665pt_1_1 tag=TAG20210810T173037 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
RMAN-03091: Finished backup at 10-AUG-21
RMAN-03023: executing command: SET NOCFAU
ts::ZLYTBS
RMAN-06134: host command complete
RMAN-03090: Starting backup at 10-AUG-21
RMAN-12016: using channel ORA_DISK_1
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00007 name=/oracle/app/oracle/oradata/fordb/zlytbs01.dbf
RMAN-08522: input datafile file number=00010 name=/oracle/app/oracle/oradata/fordb/zlytbs02.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 10-AUG-21
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 10-AUG-21
RMAN-08530: piece handle=/oracle/xttsbk/0b0665q5_1_1 tag=TAG20210810T173045 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
RMAN-03091: Finished backup at 10-AUG-21
Recovery Manager complete.
--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------
/ as sysdba
size of tablespace 3
No. of tablespaces per batch 1
TABLESPACE STRING :'JANTBS'
Prepare newscn for Tablespaces: 'JANTBS'
TABLESPACE STRING :'DOGTBS'
Prepare newscn for Tablespaces: 'DOGTBS'
TABLESPACE STRING :'ZLYTBS'
Prepare newscn for Tablespaces: 'ZLYTBS'
New /home/oracle/xtts/xttplan.txt with FROM SCN's generated
[oracle@aix173 /home/oracle/xtts]$
拷贝
scp `cat incrbackups.txt` oracle@192.168.11.75:/backup/xttsbk
scp res.txt oracle@192.168.11.75:/home/oracle/xtts
还原
$ORACLE_HOME/perl/bin/perl xttdriver.pl --restore --debug 3
Note：从日志可以看到在进行增量恢复了。
============================================================
trace file is /home/oracle/xtts/restore_Aug10_Tue_17_36_02_598//Aug10_Tue_17_36_02_598_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: rollparallel
Values: 2
Key: tablespaces
Values: JANTBS,DOGTBS,ZLYTBS
Key: dest_datafile_location
Values: +DATA
Key: src_scratch_location
Values: /oracle/xttsbk
Key: parallel
Values: 3
Key: destconnstr
Values: sys/oracle@mypdb
Key: getfileparallel
Values: 4
Key: dest_scratch_location
Values: /backup/xttsbk
Key: platformid
Values: 6
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : wldb1
ORACLE_HOME : /oracle/app/oracle/product/19.0.0/dbhome_1
190000
8,5
6,9
7,10
YYY: JANTBS_5.dbf::8,5:::1=090665pm_1_1 DOGTBS_9.dbf::6,9:::1=0a0665pt_1_1 ZLYTBS_10.dbf::7,10:::1=0b0665q5_1_1
--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------
ROLLFORWARD: Starting DB in nomount mode
ORACLE instance started.
Total System Global Area 1879046152 bytes
Fixed Size 9136136 bytes
Variable Size 654311424 bytes
Database Buffers 1207959552 bytes
Redo Buffers 7639040 bytes
rdfno 6,9
BEFORE ROLLPLAN
datafile number : 9
datafile name : +DATA/DOGTBS_9.dbf
datafile number : 6
datafile name : +DATA/DOGTBS_6.dbf
AFTER ROLLPLAN
rdfno 8,5
BEFORE ROLLPLAN
datafile number : 8
datafile name : +DATA/JANTBS_8.dbf
datafile number : 5
datafile name : +DATA/JANTBS_5.dbf
AFTER ROLLPLAN
rdfno 7,10
BEFORE ROLLPLAN
datafile number : 10
datafile name : +DATA/ZLYTBS_10.dbf
datafile number : 7
datafile name : +DATA/ZLYTBS_7.dbf
AFTER ROLLPLAN
sqlplus -L -s "/ as sysdba" @/home/oracle/xtts/restore_Aug10_Tue_17_36_02_598//xxttconv_090665pm_1_1_8_5.sql /backup/xttsbk/090665pm_1_1 /backup/xttsbk 6
CONVERTED BACKUP PIECE/backup/xttsbk/xib_090665pm_1_1_8_5
PL/SQL procedure successfully completed.
sqlplus -L -s "/ as sysdba" @/home/oracle/xtts/restore_Aug10_Tue_17_36_02_598//xxttconv_0a0665pt_1_1_6_9.sql /backup/xttsbk/0a0665pt_1_1 /backup/xttsbk 6
CONVERTED BACKUP PIECE/backup/xttsbk/xib_0a0665pt_1_1_6_9
PL/SQL procedure successfully completed.
Entering RollForwardAfter applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
Entering RollForwardAfter applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
sqlplus -L -s "/ as sysdba" @/home/oracle/xtts/restore_Aug10_Tue_17_36_02_598//xxttconv_0b0665q5_1_1_7_10.sql /backup/xttsbk/0b0665q5_1_1 /backup/xttsbk 6
CONVERTED BACKUP PIECE/backup/xttsbk/xib_0b0665q5_1_1_7_10
PL/SQL procedure successfully completed.
Entering RollForwardAfter applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
--------------------------------------------------------------------
End of rollforward phase
--------------------------------------------------------------------
[oracle@19c-h1 xtts]$
五、最后（停机阶段）的备份还原
Note：
此阶段就是停机阶段进行最后的补增量。
只读表空间
alter tablespace JANTBS read only;
alter tablespace DOGTBS read only;
alter tablespace ZLYTBS read only;
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
USERS ONLINE
JANTBS READ ONLY
DOGTBS READ ONLY
ZLYTBS READ ONLY
8 rows selected.
SQL>
备份
$ORACLE_HOME/perl/bin/perl xttdriver.pl --backup --debug 3
============================================================
trace file is /home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//Aug10_Tue_17_41_51_790_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: platformid
Values: 6
Key: src_scratch_location
Values: /oracle/xttsbk
Key: parallel
Values: 3
Key: dest_scratch_location
Values: /backup/xttsbk
Key: dest_datafile_location
Values: +DATA
Key: rollparallel
Values: 2
Key: tablespaces
Values: JANTBS,DOGTBS,ZLYTBS
Key: destconnstr
Values: sys/oracle@mypdb
Key: getfileparallel
Values: 4
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : fordb
ORACLE_HOME : /oracle/app/oracle/product/11.2.0.4/dbhome_1
112040
PRIMARY
Running on PRIMARY
--------------------------------------------------------------------
Backup incremental
--------------------------------------------------------------------
scalar(or3
XXX: adding here for 2, 0, JANTBS,DOGTBS,ZLYTBS
XXX: adding proper here for index 0, b4 added 'ZLYTBS'
,
XXX: adding proper here for index 0, added 'ZLYTBS'
XXX: adding proper here for index 1, b4 added 'DOGTBS'
,
XXX: adding proper here for index 1, added 'DOGTBS'
Number of tb arrays is 2
::JANTBS:::SCN:::9777575=977757,JANTBS,+DATA/JANTBS_5.dbf
8=977757,JANTBS,+DATA/JANTBS_8.dbf
::DOGTBS:::SCN:::977766
6=977766,DOGTBS,+DATA/DOGTBS_6.dbf
9=977766,DOGTBS,+DATA/DOGTBS_9.dbf
::ZLYTBS:::SCN:::977775
7=977775,ZLYTBS,+DATA/ZLYTBS_7.dbf
10=977775,ZLYTBS,+DATA/ZLYTBS_10.dbf
::JANTBS:::SCN:::977757
/home/oracle/xtts/newfile.txt: ::JANTBS:::SCN:::977757
/home/oracle/xtts/newfile.txt: 5=977757,JANTBS,+DATA/JANTBS_5.dbf
/home/oracle/xtts/newfile.txt: 8=977757,JANTBS,+DATA/JANTBS_8.dbf
/home/oracle/xtts/newfile.txt: ::DOGTBS:::SCN:::977766
/home/oracle/xtts/newfile.txt: 6=977766,DOGTBS,+DATA/DOGTBS_6.dbf
/home/oracle/xtts/newfile.txt: 9=977766,DOGTBS,+DATA/DOGTBS_9.dbf
/home/oracle/xtts/newfile.txt: ::ZLYTBS:::SCN:::977775
/home/oracle/xtts/newfile.txt: 7=977775,ZLYTBS,+DATA/ZLYTBS_7.dbf
/home/oracle/xtts/newfile.txt: 10=977775,ZLYTBS,+DATA/ZLYTBS_10.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: ::JANTBS:::SCN:::977757
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: 5=977757,JANTBS,+DATA/JANTBS_5.dbf
Writing new 5=977757,JANTBS,+DATA/JANTBS_5.dbf
Writing1 new 5, +DATA/JANTBS_5.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: 8=977757,JANTBS,+DATA/JANTBS_8.dbf
Writing new 8=977757,JANTBS,+DATA/JANTBS_8.dbf
Writing1 new 8, +DATA/JANTBS_8.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: ::DOGTBS:::SCN:::977766
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: 6=977766,DOGTBS,+DATA/DOGTBS_6.dbf
Writing new 6=977766,DOGTBS,+DATA/DOGTBS_6.dbf
Writing1 new 6, +DATA/DOGTBS_6.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: 9=977766,DOGTBS,+DATA/DOGTBS_9.dbf
Writing new 9=977766,DOGTBS,+DATA/DOGTBS_9.dbf
Writing1 new 9, +DATA/DOGTBS_9.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: ::ZLYTBS:::SCN:::977775
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: 7=977775,ZLYTBS,+DATA/ZLYTBS_7.dbf
Writing new 7=977775,ZLYTBS,+DATA/ZLYTBS_7.dbf
Writing1 new 7, +DATA/ZLYTBS_7.dbf
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttnewdatafiles.txt.added: 10=977775,ZLYTBS,+DATA/ZLYTBS_10.dbf
Writing new 10=977775,ZLYTBS,+DATA/ZLYTBS_10.dbf
Writing1 new 10, +DATA/ZLYTBS_10.dbf
Added fname here 1:/backup/xttsbk/JANTBS_5.tf
Added fname here 1:/backup/xttsbk/JANTBS_8.tf
Added fname here 1:/backup/xttsbk/DOGTBS_6.tf
Added fname here 1:/backup/xttsbk/DOGTBS_9.tf
Added fname here 1:/backup/xttsbk/ZLYTBS_7.tf
Added fname here 1:/backup/xttsbk/ZLYTBS_10.tf
YYY: ::JANTBS:::SCN:::977757
YYY: ::DOGTBS:::SCN:::977766
YYY: ::ZLYTBS:::SCN:::977775
============================================================
No new datafiles added
=============================================================
/ as sysdba
size of tablespace 3
No. of tablespaces per batch 1
TABLESPACE STRING :'JANTBS'
Prepare newscn for Tablespaces: 'JANTBS'
JANTBS::::977757 5
TABLESPACE STRING :'DOGTBS'
Prepare newscn for Tablespaces: 'DOGTBS'
DOGTBS::::977766 6
TABLESPACE STRING :'ZLYTBS'
Prepare newscn for Tablespaces: 'ZLYTBS'
ZLYTBS::::977775 7
--------------------------------------------------------------------
Starting incremental backup
--------------------------------------------------------------------
/home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//rmanincr.cmd
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Aug 10 17:41:52 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN-06005: connected to target database: FORDB (DBID=498190680)
RMAN> set nocfau;
2> host 'echo ts::JANTBS';
3> backup incremental from scn 974203
4> tablespace 'JANTBS' format
5> '/oracle/xttsbk/%U';
6> set nocfau;
7> host 'echo ts::DOGTBS';
8> backup incremental from scn 974232
9> tablespace 'DOGTBS' format
10> '/oracle/xttsbk/%U';
11> set nocfau;
12> host 'echo ts::ZLYTBS';
13> backup incremental from scn 974278
14> tablespace 'ZLYTBS' format
15> '/oracle/xttsbk/%U';
16>
RMAN-03023: executing command: SET NOCFAU
RMAN-06009: using target database control file instead of recovery catalog
ts::JANTBS
RMAN-06134: host command complete
RMAN-03090: Starting backup at 10-AUG-21
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=23 device type=DISK
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00005 name=/oracle/app/oracle/oradata/fordb/jantbs01.dbf
RMAN-08522: input datafile file number=00008 name=/oracle/app/oracle/oradata/fordb/jantbs02.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 10-AUG-21
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 10-AUG-21
RMAN-08530: piece handle=/oracle/xttsbk/0c0666f3_1_1 tag=TAG20210810T174155 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-03091: Finished backup at 10-AUG-21
RMAN-03023: executing command: SET NOCFAU
ts::DOGTBS
RMAN-06134: host command complete
RMAN-03090: Starting backup at 10-AUG-21
RMAN-12016: using channel ORA_DISK_1
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00006 name=/oracle/app/oracle/oradata/fordb/dogtbs01.dbf
RMAN-08522: input datafile file number=00009 name=/oracle/app/oracle/oradata/fordb/dogtbs02.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 10-AUG-21
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 10-AUG-21
RMAN-08530: piece handle=/oracle/xttsbk/0d0666f5_1_1 tag=TAG20210810T174157 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
RMAN-03091: Finished backup at 10-AUG-21
RMAN-03023: executing command: SET NOCFAU
ts::ZLYTBS
RMAN-06134: host command complete
RMAN-03090: Starting backup at 10-AUG-21
RMAN-12016: using channel ORA_DISK_1
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00007 name=/oracle/app/oracle/oradata/fordb/zlytbs01.dbf
RMAN-08522: input datafile file number=00010 name=/oracle/app/oracle/oradata/fordb/zlytbs02.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 10-AUG-21
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 10-AUG-21
RMAN-08530: piece handle=/oracle/xttsbk/0e0666f8_1_1 tag=TAG20210810T174200 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
RMAN-03091: Finished backup at 10-AUG-21
Recovery Manager complete.
--------------------------------------------------------------------
Done backing up incrementals
--------------------------------------------------------------------
/ as sysdba
size of tablespace 3
No. of tablespaces per batch 1
TABLESPACE STRING :'JANTBS'
Prepare newscn for Tablespaces: 'JANTBS'
DECLARE*
ERROR at line 1:
ORA-20001: TABLESPACE(S) IS READONLY OR,
OFFLINE JUST CONVERT, COPY
ORA-06512: at line 284
####################################################################
Warning:
------
Warnings found in executing /home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttpreparenextiter.sql
####################################################################
DECLARE*
ERROR at line 1:
ORA-20001: TABLESPACE(S) IS READONLY OR,
OFFLINE JUST CONVERT, COPY
ORA-06512: at line 284
TABLESPACE STRING :'DOGTBS'
Prepare newscn for Tablespaces: 'DOGTBS'
DECLARE*
ERROR at line 1:
ORA-20001: TABLESPACE(S) IS READONLY OR,
OFFLINE JUST CONVERT, COPY
ORA-06512: at line 284
####################################################################
Warning:
------
Warnings found in executing /home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttpreparenextiter.sql
####################################################################
DECLARE*
ERROR at line 1:
ORA-20001: TABLESPACE(S) IS READONLY OR,
OFFLINE JUST CONVERT, COPY
ORA-06512: at line 284
TABLESPACE STRING :'ZLYTBS'
Prepare newscn for Tablespaces: 'ZLYTBS'
DECLARE*
ERROR at line 1:
ORA-20001: TABLESPACE(S) IS READONLY OR,
OFFLINE JUST CONVERT, COPY
ORA-06512: at line 284
####################################################################
Warning:
------
Warnings found in executing /home/oracle/xtts/backup_Aug10_Tue_17_41_51_790//xttpreparenextiter.sql
####################################################################
DECLARE*
ERROR at line 1:
ORA-20001: TABLESPACE(S) IS READONLY OR,
OFFLINE JUST CONVERT, COPY
ORA-06512: at line 284
New /home/oracle/xtts/xttplan.txt with FROM SCN's generated
[oracle@aix173 /home/oracle/xtts]$
拷贝
scp `cat incrbackups.txt` oracle@192.168.11.75:/backup/xttsbk
scp res.txt oracle@192.168.11.75:/home/oracle/xtts
还原
$ORACLE_HOME/perl/bin/perl xttdriver.pl --restore --debug 3
[oracle@19c-h1 xtts]$ $ORACLE_HOME/perl/bin/perl xttdriver.pl --restore --debug 3
============================================================
trace file is /home/oracle/xtts/restore_Aug10_Tue_17_47_21_959//Aug10_Tue_17_47_21_959_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
Key: parallel
Values: 3
Key: destconnstr
Values: sys/oracle@mypdb
Key: platformid
Values: 6
Key: tablespaces
Values: JANTBS,DOGTBS,ZLYTBS
Key: getfileparallel
Values: 4
Key: src_scratch_location
Values: /oracle/xttsbk
Key: rollparallel
Values: 2
Key: dest_datafile_location
Values: +DATA
Key: dest_scratch_location
Values: /backup/xttsbk
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
ARGUMENT tablespaces
ARGUMENT platformid
ARGUMENT backupformat
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
ORACLE_SID : wldb1
ORACLE_HOME : /oracle/app/oracle/product/19.0.0/dbhome_1
190000
8,5
6,9
7,10
YYY: JANTBS_5.dbf::8,5:::1=0c0666f3_1_1 DOGTBS_9.dbf::6,9:::1=0d0666f5_1_1 ZLYTBS_10.dbf::7,10:::1=0e0666f8_1_1
--------------------------------------------------------------------
Start rollforward
--------------------------------------------------------------------
ROLLFORWARD: Starting DB in nomount mode
ORACLE instance started.
Total System Global Area 1879046152 bytes
Fixed Size 9136136 bytes
Variable Size 654311424 bytes
Database Buffers 1207959552 bytes
Redo Buffers 7639040 bytes
rdfno 6,9
BEFORE ROLLPLAN
datafile number : 9
datafile name : +DATA/DOGTBS_9.dbf
datafile number : 6
datafile name : +DATA/DOGTBS_6.dbf
AFTER ROLLPLAN
rdfno 8,5
BEFORE ROLLPLAN
datafile number : 8
datafile name : +DATA/JANTBS_8.dbf
datafile number : 5
datafile name : +DATA/JANTBS_5.dbf
AFTER ROLLPLAN
rdfno 7,10
BEFORE ROLLPLAN
datafile number : 10
datafile name : +DATA/ZLYTBS_10.dbf
datafile number : 7
datafile name : +DATA/ZLYTBS_7.dbf
AFTER ROLLPLAN
sqlplus -L -s "/ as sysdba" @/home/oracle/xtts/restore_Aug10_Tue_17_47_21_959//xxttconv_0d0666f5_1_1_6_9.sql /backup/xttsbk/0d0666f5_1_1 /backup/xttsbk 6
CONVERTED BACKUP PIECE/backup/xttsbk/xib_0d0666f5_1_1_6_9
PL/SQL procedure successfully completed.
sqlplus -L -s "/ as sysdba" @/home/oracle/xtts/restore_Aug10_Tue_17_47_21_959//xxttconv_0c0666f3_1_1_8_5.sql /backup/xttsbk/0c0666f3_1_1 /backup/xttsbk 6
CONVERTED BACKUP PIECE/backup/xttsbk/xib_0c0666f3_1_1_8_5
PL/SQL procedure successfully completed.
Entering RollForwardAfter applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
Entering RollForwardAfter applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
sqlplus -L -s "/ as sysdba" @/home/oracle/xtts/restore_Aug10_Tue_17_47_21_959//xxttconv_0e0666f8_1_1_7_10.sql /backup/xttsbk/0e0666f8_1_1 /backup/xttsbk 6
CONVERTED BACKUP PIECE/backup/xttsbk/xib_0e0666f8_1_1_7_10
PL/SQL procedure successfully completed.
Entering RollForwardAfter applySetDataFile
Done: applyDataFileTo
Done: applyDataFileTo
Done: RestoreSetPiece
Done: RestoreBackupPiece
PL/SQL procedure successfully completed.
--------------------------------------------------------------------
End of rollforward phase
--------------------------------------------------------------------
[oracle@19c-h1 xtts]$
六、迁移元数据
创建目录对象
mkdir /oracle/dumpfile
create directory mydir as '/oracle/dumpfile';
Note：源和目标都需要创建，可以自行定义路径。
源端导出
vi exp.par
dumpfile=xttdump.dmp
directory=DATA_PUMP_DIR
statistics=NONE
transport_tablespaces=TS1,TS2
transport_full_check=y
logfile=tts_export.log
expdp system/oracle parfile=xtts_exp.par
Export: Release 11.2.0.4.0 - Production on Tue Aug 10 17:53:45 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "statistics=NONE" Location: Parameter File, ignored.
Legacy Mode has set reuse_dumpfiles=true parameter.
Starting "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** parfile=xtts_exp.par reuse_dumpfiles=true
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is:
/oracle/dumpfile/xtts20210810.dmp
******************************************************************************
Datafiles required for transportable tablespace DOGTBS:
/oracle/app/oracle/oradata/fordb/dogtbs01.dbf
/oracle/app/oracle/oradata/fordb/dogtbs02.dbf
Datafiles required for transportable tablespace JANTBS:
/oracle/app/oracle/oradata/fordb/jantbs01.dbf
/oracle/app/oracle/oradata/fordb/jantbs02.dbf
Datafiles required for transportable tablespace ZLYTBS:
/oracle/app/oracle/oradata/fordb/zlytbs01.dbf
/oracle/app/oracle/oradata/fordb/zlytbs02.dbf
Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at Tue Aug 10 17:54:40 2021 elapsed 0 00:00:50
[oracle@aix173 /home/oracle/xtts]$
拷贝
scp /oracle/dumpfile/xtts20210810.dmp oracle@172.172.30.161:/home/oracle/dumpfile
目标端导入
源端生成模板
$ORACLE_HOME/perl/bin/perl xttdriver.pl -e
============================================================
trace file is /home/oracle/xtts/generate_Aug10_Tue_18_07_16_271//Aug10_Tue_18_07_16_271_.log
=============================================================
--------------------------------------------------------------------
Parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done parsing properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Done checking properties
--------------------------------------------------------------------
--------------------------------------------------------------------
Generating plugin
--------------------------------------------------------------------
--------------------------------------------------------------------
Done generating plugin file /home/oracle/xtts/xttplugin.txt
--------------------------------------------------------------------
Note：在数据文件繁多的时候模板就体现作用了，transport_datafiles会帮忙写好。
目标端创建好用户
create user janusr identified by oracle;
create user dogusr identified by oracle;
create user zlyusr identified by oracle;
grant dba to zlyusr;
grant dba to janusr;
grant dba to dogusr;
Note：权限根据实际情况而定。
开始导入
vi xtts_imp.par
dumpfile=xtts20210810.dmp
directory=mydir
transport_datafiles='+DATA/JANTBS_5.dbf','+DATA/JANTBS_8.dbf','+DATA/DOGTBS_6.dbf','+DATA/DOGTBS_9.dbf','+DATA/ZLYTBS_7.dbf','+DATA/ZLYTBS_10.dbf'
logfile=xtts_imp20210810.log
impdp system/oracle@mypdb parfile=xtts_imp.par
Import: Release 19.0.0.0.0 - Production on Tue Aug 10 18:19:16 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/********@mypdb parfile=xtts_imp.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX/INDEX
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Tue Aug 10 18:19:42 2021 elapsed 0 00:00:24
[oracle@19c-h1 xtts]$
修改用户默认表空间
alter user janusr default tablespace jantbs quota unlimited on jantbs;
alter user dogusr default tablespace dogtbs quota unlimited on dogtbs;
alter user zlyusr default tablespace zlytbs quota unlimited on zlytbs;
数据验证
validate tablespace JANTBS,DOGTBS,ZLYTBS check logical;
Note：利用RMAN验证源端和目标比对是否有差异，可以看到源和目标比对是一致的。
源端：
Starting validate at 10-AUG-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=143 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00005 name=/oracle/app/oracle/oradata/fordb/jantbs01.dbf
input datafile file number=00008 name=/oracle/app/oracle/oradata/fordb/jantbs02.dbf
input datafile file number=00006 name=/oracle/app/oracle/oradata/fordb/dogtbs01.dbf
input datafile file number=00009 name=/oracle/app/oracle/oradata/fordb/dogtbs02.dbf
input datafile file number=00007 name=/oracle/app/oracle/oradata/fordb/zlytbs01.dbf
input datafile file number=00010 name=/oracle/app/oracle/oradata/fordb/zlytbs02.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 9901 12800 977663
File Name: /oracle/app/oracle/oradata/fordb/jantbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2428
Index 0 296
Other 0 175
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 9901 12800 977699
File Name: /oracle/app/oracle/oradata/fordb/dogtbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2428
Index 0 296
Other 0 175
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 9901 12800 977734
File Name: /oracle/app/oracle/oradata/fordb/zlytbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2428
Index 0 296
Other 0 175
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 9601 12800 977663
File Name: /oracle/app/oracle/oradata/fordb/jantbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2488
Index 0 472
Other 0 239
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 9601 12800 977699
File Name: /oracle/app/oracle/oradata/fordb/dogtbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2488
Index 0 472
Other 0 239
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 9601 12800 977734
File Name: /oracle/app/oracle/oradata/fordb/zlytbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2488
Index 0 472
Other 0 239
Finished validate at 10-AUG-21
RMAN>
目标：
Starting validate at 10-AUG-21
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 instance=wldb1 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00016 name=+DATA/jantbs_8.dbf
input datafile file number=00017 name=+DATA/jantbs_5.dbf
input datafile file number=00014 name=+DATA/dogtbs_9.dbf
input datafile file number=00015 name=+DATA/dogtbs_6.dbf
input datafile file number=00018 name=+DATA/zlytbs_10.dbf
input datafile file number=00019 name=+DATA/zlytbs_7.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14 OK 0 9601 12800 7031342
File Name: +DATA/dogtbs_9.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2488
Index 0 472
Other 0 239
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15 OK 0 9901 12800 7031340
File Name: +DATA/dogtbs_6.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2428
Index 0 296
Other 0 175
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16 OK 0 9601 12800 7031349
File Name: +DATA/jantbs_8.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2488
Index 0 472
Other 0 239
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17 OK 0 9901 12800 7031347
File Name: +DATA/jantbs_5.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2428
Index 0 296
Other 0 175
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18 OK 0 9601 12800 7031357
File Name: +DATA/zlytbs_10.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2488
Index 0 472
Other 0 239
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19 OK 0 9901 12800 7031354
File Name: +DATA/zlytbs_7.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 2428
Index 0 296
Other 0 175
Finished validate at 10-AUG-21
RMAN>
开启表空间读写
alter tablespace JANTBS read write;
alter tablespace DOGTBS read write;
alter tablespace ZLYTBS read write;
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
UNDO_2 ONLINE
DOGTBS READ ONLY
JANTBS READ ONLY
ZLYTBS READ ONLY
8 rows selected.
SQL> alter tablespace JANTBS read write;
Tablespace altered.
SQL> alter tablespace DOGTBS read write;
Tablespace altered.
SQL> alter tablespace ZLYTBS read write;
Tablespace altered.
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
SYSAUX ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
UNDO_2 ONLINE
DOGTBS ONLINE
JANTBS ONLINE
ZLYTBS ONLINE
8 rows selected.
SQL>
至此迁移完成，后续可以进行表分析。
最后修改时间：2023-05-12 18:08:26
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
