实战12C-19cXTTS迁移过程_数据库量6T_停机时间1小时.pdf

小草

1375

26页

97次

2023-07-20

10墨值下载

! 源端⽬标端

IP地址 192.168.10.111/112 192.168.10.116/117

操作系统 oracle Linux 7.7 oracle Linux 7.9

是否RAC 是是

数据库名称 hisdb hisdb

迁移业务⽤户⻅下⽂ !

1.XTTS概述

注意：相关信息做过脱密处理

采⽤XTTS(Cross Platform Transportable Tablespaces)迁移⽅式，准确说这⾥指的是加强版XTTS，具备跨平台字

节序转换、全量初始化、多次增量前滚的功能，从⽽有效缩短正式迁移阶段的⽣产停机时间，顺利完成U2L的迁移

⼯作。⽐如本次需求如下

2.迁移准备阶段

2.1校验⾃包含

本次迁移⽤户

UPT,

需要变更表空间对象( 如果有需要变更，本次迁移没有)

查看表空间

select distinct tablespace_name from dba_segments where owner in('UPT') order by 1;

execute dbms_tts.transport_set_check('UPT_DATA',true);

select * from TRANSPORT_SET_VIOLATIONS;

上述查询若没有结果⾏返回，说明⾃包含校验通过。

alter table PDSCI.SRM_ACH_SCORE_MATCHING move tablespace pdsci;

alter index PDSCI.PK_SRM_ACH_SCORE_MATCHING REBUILD TABLESPACE pdsci;

alter tablespace pdsci read write;

2.2创建XTTS⼯作⽬录

本次我设置的XTTS的⼯作⽬录是/data/xtts，在源端和⽬标端都创建相关⽬录，上传并解压xttconvert脚本。

2.3查看平台信息

--源端Linux创建相关⽬录

mkdir -p /data/xttssource

mkdir -p /data/xttssource/src_backup

mkdir -p /data/xttssource/tmp

mkdir -p /data/xttssource/dump

mkdir -p /data/xttssource/backup_incre

chown -R oracle:oinstall /data/xttssource

--源端Linux上传rman-xttconvert_3.0.zip⾄/data/xttssource

cd /data/xttssource

unzip rman-xttconvert_3.0.zip

--⽬标端Linux创建相关⽬录

mkdir -p /data/xtts

mkdir -p /data/xtts/src_backup

mkdir -p /data/xtts/tmp

mkdir -p /data/xtts/dump

mkdir -p /data/xtts/backup_incre

chown -R oracle:oinstall /data/xtts

--⽬标端Linux上传rman-xttconvert_3.0.zip⾄/data/xtts

cd /data/xtts

unzip rman-xttconvert_3.0.zip

SQL> COLUMN PLATFORM_NAME FORMAT A36

SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM ORDER BY PLATFORM_NAME;

PLATFORM_ID PLATFORM_NAME ! ! ! ! ! ! ! ! ! ! ! ENDIAN_FORMAT

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

! ! ! ! !6 AIX-Based Systems (64-bit) ! ! ! ! ! Big

! ! ! ! 16 Apple Mac OS ! ! ! ! ! ! ! ! ! ! ! ! Big

! ! ! ! 21 Apple Mac OS (x86-64) ! ! ! ! ! ! ! Little

! ! ! ! 19 HP IA Open VMS ! ! ! ! ! ! ! ! ! ! ! Little

! ! ! ! 15 HP Open VMS ! ! ! ! ! ! ! ! ! ! ! ! Little

! ! ! ! !5 HP Tru64 UNIX ! ! ! ! ! ! ! ! ! ! ! Little

! ! ! ! !3 HP-UX (64-bit) ! ! ! ! ! ! ! ! ! ! ! Big

! ! ! ! !4 HP-UX IA (64-bit) ! ! ! ! ! ! ! ! ! Big

! ! ! ! 18 IBM Power Based Linux ! ! ! ! ! ! ! Big

! ! ! ! !9 IBM zSeries Based Linux ! ! ! ! ! ! Big

2.4 检查字符集（源⽬标应⼀致）⽬标不是utf8字符集

2.4 查看offline datafile

2.5检查⽬标端补丁情况

2.6检查组件安装情况，对于不⼀样的组件，需要有所标记,本次迁移不⽤管

! ! ! ! 10 Linux IA (32-bit) ! ! ! ! ! ! ! ! ! Little

PLATFORM_ID PLATFORM_NAME ! ! ! ! ! ! ! ! ! ! ! ENDIAN_FORMAT

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

! ! ! ! 11 Linux IA (64-bit) ! ! ! ! ! ! ! ! ! Little

! ! ! ! 13 Linux x86 64-bit ! ! ! ! ! ! ! ! ! ! Little

! ! ! ! !7 Microsoft Windows IA (32-bit) ! ! ! Little

! ! ! ! !8 Microsoft Windows IA (64-bit) ! ! ! Little

! ! ! ! 12 Microsoft Windows x86 64-bit ! ! ! ! Little

! ! ! ! 17 Solaris Operating System (x86) ! ! ! Little

! ! ! ! 20 Solaris Operating System (x86-64) ! Little

! ! ! ! !1 Solaris[tm] OE (32-bit) ! ! ! ! ! ! Big

! ! ! ! !2 Solaris[tm] OE (64-bit) ! ! ! ! ! ! Big

20 rows selected

SQL> col VALUE$ format a20

SQL> select name,value$ !from PROPS$ !where name like '%CHARACTERSET';

NAME ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! VALUE$

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

NLS_NCHAR_CHARACTERSET ! ! ! ! ! ! ! ! ! ! ! ! ! ! UTF8

NLS_CHARACTERSET ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! ! AL32UTF8

SQL> select TS#,FILE#,NAME,STATUS from v$datafile where status='OFFLINE';

SQL> select 'opatch',comments from dba_registry_history;

'OPATC

------

COMMENTS

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

opatch

RDBMS_12.2.0.1.0_LINUX.X64_170125

of 26

10墨值下载

相关文档

评论