xtts 迁移注意

简介: xtts 迁移注意

1,NOTE: Only those database objects that are physically located in the tablespace(s) being transported will be copied to the destination system. Other objects, such as users, pl/sql objects, sequences, views etc., located in the SYSTEM tablespace will not be transported. You will need to pre-create the users and copy such objects to the destination system, possibly using data pump.

Metadata Residing in the SYSTEM or SYSAUX Tablespaces
Database metadata includes views, synonyms, type definitions, database links,
PL/SQL packages, roles, Java classes, privileges, sequences, and other objects.
Running a full database, metadata-only import creates database metadata that is not
automatically created in the target database by the transport process. This will be
accomplished with two separate import processes, as detailed in the following
steps.
SYSTEM-Owned Objects Residing in the SYSTEM or SYSAUX Tablespaces
Some applications create tables and indexes owned by the SYSTEM user that are
required for proper application functionality. To properly identify these objects
requires application-specific knowledge. You must move these objects to the target
database manually with Data Pump, or manually re-create the objects after
performing the platform migration.
User-Owned Tables Residing in the SYSTEM or SYSAUX Tablespaces
Run the following script (provided in the Appendix) to identify user objects that
reside in SYSTEM or SYSAUX:
Handle Objects in the SYSTEM or SYSAUX Tablespaces
Because XTTS does not move objects that reside in the SYSTEM or SYSAUX
tablespaces of the source database, the following conditions warrant special
consideration when transporting a whole database:

NOTE: Only those database objects that are physically located in the tablespace(s) being transported will be copied to the destination system. Other objects, such as users, pl/sql objects, sequences, views etc., located in the SYSTEM tablespace will not be transported. You will need to pre-create the users and copy such objects to the destination system, possibly using data pump.

The following may help:

Oracle Database 12c: Full Transportable Export/Import

and/or

MAA paper Platform Migration Using Transportable Tablespaces: Oracle Database.

相关文章
|
2月前
|
关系型数据库 MySQL 数据库
rds迁移数据迁移工具选择
rds迁移数据迁移工具选择
138 3
|
11月前
|
容灾 关系型数据库 数据库
将旧集群的数据备份迁移到新集群。
将旧集群的数据备份迁移到新集群。
113 1
|
10月前
|
关系型数据库 MySQL 数据库
MySQL数据库DTS迁移上云
利用DTS数据迁移工具完成RDS实例间的数据迁移。
153 0
|
存储 文件存储 对象存储
S3存储服务间数据同步工具Rclone迁移教程
目前大多项目我们都会使用各种存储服务,例如oss、cos、minio等。当然,因各种原因,可能需要在不同存储服务间进行数据迁移工作,所以今天就给大家介绍一个比较通用的数据迁移工具Rclone。
S3存储服务间数据同步工具Rclone迁移教程
|
2月前
|
监控 容灾 安全
规划阿里云RDS跨区迁移并构建容灾与备份策略
规划阿里云RDS(Relational Database Service)跨区迁移并构建容灾与备份策略
144 2
|
12月前
|
SQL 关系型数据库 MySQL
【迁移】Mysql数据库备份 迁移
备份数据,新建库,导入数据,恢复备份
64 0
【迁移】Mysql数据库备份 迁移
系统迁移
系统迁移
100 0
|
2月前
|
弹性计算 Linux Windows
服务器迁移
本实践以小微客户为例,提供两个场景的迁移验证实践。采用 SMC 模式,一个以阿里云内部迁移举例;一个以他云服务器为例,迁移到华东2(上海)。
服务器迁移
|
弹性计算 Ubuntu 关系型数据库
服务器迁移最佳实践
越来越多的企业上云后,在窗口期内快速、平滑迁移到阿里云上,用最优的方案来实践以及实现业务价值。
692 0
服务器迁移最佳实践
|
关系型数据库 RDS
DTS 跨账号迁移详细配置
本文分享DTS 跨账号迁移详细配置
DTS 跨账号迁移详细配置