Oracle RMAN Transport Tablespace - 兼容性检查

来源:互联网 发布:财务管理书籍 知乎 编辑:程序博客网 时间:2024/04/27 23:18
查询当前数据库的平台
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.