跨平台传输表空间

1.查看ORACLE支持的可跨版本
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> select PLATFORM_NAME, ENDIAN_FORMAT from V$TRANSPORTABLE_PLATFORM

PLATFORM_NAME                  ENDIAN_FORMAT
------------------------------ --------------------
Solaris[tm] OE (32-bit)        Big
Solaris[tm] OE (64-bit)        Big
Microsoft Windows IA (32-bit)  Little
Linux IA (32-bit)              Little
AIX-Based Systems (64-bit)     Big
HP-UX (64-bit)                 Big
HP Tru64 UNIX                  Little
HP-UX IA (64-bit)              Big
Linux IA (64-bit)              Little
HP Open VMS                    Little
Microsoft Windows IA (64-bit)  Little

PLATFORM_NAME                  ENDIAN_FORMAT
------------------------------ --------------------
IBM zSeries Based Linux        Big
Linux x86 64-bit               Little
Apple Mac OS                   Big
Microsoft Windows x86 64-bit   Little
Solaris Operating System (x86) Little
IBM Power Based Linux          Big
Solaris Operating System (x86- Little
64)

HP IA Open VMS                 Little

19 rows selected.

2。将数据库置成read only状态
SQL> alter database open read only;

Database altered.

3。检查linux是否支持'AIX-Based Systems (64-bit)'传输
set serveroutput on
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.
可以看到不支持'AIX-Based Systems (64-bit)'传输

4。检查是否有传输表空间不支持的对象
SQL> set serveroutput on
SQL> declare
  2  external boolean;
  3  begin
  4   external := dbms_tdb.check_external;
  5  end;
  6   /
The following directories exist in the database:
SYS.ORACLE_OCM_CONFIG_DIR, SYS.DATA_PUMP_DIR, SYS.WORK_DIR, SYS.ADMIN_DIR

PL/SQL procedure successfully completed.

5。用rman跨平台传输表空间
将表空间置为read only状态
SQL> alter tablespace users read only;

Tablespace altered.

转换表空间
RMAN> convert tablespace users to platform="AIX-Based Systems (64-bit)" FORMAT '/oradata/aix.dbf';

Starting backup at 17-JUN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=262 devtype=DISK
channel ORA_DISK_1: starting datafile conversion
input datafile fno=00004 name=/oradata/test/users01.dbf
converted datafile=/oradata/aix.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
Finished backup at 17-JUN-09