Oracle RMAN Transport Tablespace - 兼容性检查

最新推荐文章于 2022-12-29 11:27:35 发布

deanza

最新推荐文章于 2022-12-29 11:27:35 发布

阅读量653

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL Script Tools Oracle Backup Recovery

本文链接：https://blog.youkuaiyun.com/deanza/article/details/8848910

Oracle Backup Recovery 同时被 2 个专栏收录

28 篇文章

订阅专栏

SQL Script Tools

27 篇文章

订阅专栏

本文介绍如何查询当前Oracle数据库所在平台及字节顺序，并通过DBMS_TDB包检查数据库是否支持从源平台迁移到目标平台。此外，还提供了一个示例来验证特定平台的兼容性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查询当前数据库的平台
SELECT d.PLATFORM_NAME,tp.ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_NAME = d.PLATFORM_NAME;
select * from v$transportable_platform;

查看当前数据库是否支持指定的平台（数据库在read only模式下打开）
The DBMS_TDB package serves two purposes:

Confirms support of transporting a database from a given source platform to a given target platform
Determining whether a database to be transported has been properly prepared for transport, and if not, identifyies the condition that prevents database transport

SQL> set serveroutput on
SQL> declare
          db_ready boolean;
          begin
          db_ready := dbms_tdb.check_db('Linux IA (64-bit)');
          end;
          /
输出没有结果，表明兼容。

SQL> set serveroutput on
SQL> declare
          db_ready boolean;
          begin
          db_ready := dbms_tdb.check_db('AIX-Based Systems (64-bit)');
          end;
        /
The specified target platform name 'AIX-Based Systems (64-bit)' is invalid or the target platform is not transportable.

PL/SQL procedure successfully completed.