RMAN 跨平台迁移--之 covert database.docVIP

RMAN 跨平台迁移--之 covert database RMAN 跨平台迁移--之 covert database2011-04-05 21:55转载自 xu521huan最终编辑 jiamiao442最近研究goldengate 折腾了2天 以为都弄好了呢 最后检查 发现数据实际没用同步 既然这样 那咋就再弄一次 先把整个库同步一下 原库是linux的 我准备恢复到win xp上，当然可以使用gg的 load data功能，该功能还没试验过 由于之前一直没用过rman的covert功能，这次正好试试 过程如下： SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount ORACLE instance started. Total System Global Area 314572800 bytes Fixed Size 1267236 bytes Variable Size 260049372 bytes Database Buffers bytes Redo Buffers 2924544 bytes Database mounted. SQL alter database open read only; Database altered. SQL declare db_ready boolean; begin /* db_ready is ignored, but with SERVEROUTPUT set to ON any * conditions preventing transport will be output to console */ 2 3 4 5 6 db_ready := dbms_tdb.check_db(Microsoft Windows IA (32-bit), 7 dbms_tdb.skip_none); 8 end; 9 / PL/SQL procedure successfully completed. SQL declare 2 external boolean; 3 begin 4 /* value of external is ignored, but with SERVEROUTPUT set to ON 5 * dbms_tdb.check_external displays report of external objects 6 * on console */ 7 external := dbms_tdb.check_external; 8 end; 9 / PL/SQL procedure successfully completed. SQL ----检查是否有外部表或无法传输的对象 SQL exit Disconnected from Oracle Database 10g Enterprise Edition Release .0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@localhost bdump]$ cd $ORACLE_HOME/bin [oracle@localhost bin]$ ./rman target / Recovery Manager: Release .0 - Production on Wed Nov 17 13:34:49 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: TEST (DBID=2024668720) RMAN CONVERT DATABASE NEW DATABASE roger 2 transport script /oracle/transport_win32.sql 3 to platform Microsoft Windows IA (32-bit) 4 db_file_name_convert /oracle/product/oradata/test /backup/roger; ---进行转换并生成相关的脚本 Star