Oracle RMAN Transport Tablespace - 兼容性检查

最新推荐文章于 2025-07-10 11:29:24 发布

原创最新推荐文章于 2025-07-10 11:29:24 发布 · 668 阅读

0 ·

CC 4.0 BY-SA版权

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

28 篇文章

订阅专栏

SQL Script Tools

27 篇文章

订阅专栏

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

查询当前数据库的平台
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.