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:
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.
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> 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.
- Oracle RMAN Transport Tablespace - 兼容性检查
- Oracle Transport Tablespace by RMAN
- Oracle Transport Tablespace
- Oracle Transport Tablespace
- 使用rman在不同平台之间传送oracle asm表空间(transport tablespace)
- transport tablespace
- Transport Tablespace Set(三) ----transport single tablespace
- 测试transport tablespace
- transport tablespace Tips
- RMAN Restore Database/Tablespace
- Transport tablespace at OS level
- 运用transport tablespace进行快速oracle版本升级(9i-10g)
- 运用transport tablespace进行快速oracle版本升级(9i-10g)
- 运用transport tablespace进行快速oracle版本升级(9i-10g)
- Oracle TableSpace
- Oracle Tablespace
- Oracle Tablespace
- RMAN兼容性测试
- STL_queue
- An easy problem+数学推理
- OpenGL模型视图变换、投影变换、视口变换
- NYOJ 图像有用区域 南工92
- hibernate 中createQuery与createSQLQuery
- Oracle RMAN Transport Tablespace - 兼容性检查
- 俺的懒人AnyTips
- hibernate的HQL的统计查询
- 高斯正十七边型的画法
- PHP输出非HTML格式文件总结
- opencv c++函数 基础1 Mat基本图像容器
- Android fastboot
- GetMessage()函数使用时的注意
- 视差滚动(Parallax Scrolling)概念及10个实用插件