利用RMAN将数据库转换到不同平台上

Z:>rman



Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jan 3 21:00:46 2007



Copyright (c) 1982, 2005, Oracle.  All rights reserved.



RMAN> connect target sys/password@orcl



connected to target database: ORCL (DBID=1106543623)



RMAN> SQL 'ALTER TABLESPACE users READ ONLY';



using target database control file instead of recovery catalog
sql statement: ALTER TABLESPACE users READ ONLY



RMAN> CONVERT TABLESPACE users

2> TO PLATFORM 'IBM zSeries Based Linux';



Starting backup at 03-JAN-07

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=145 devtype=DISK

channel ORA_DISK_1: starting datafile conversion

input datafilefno=00004 name=C:ORACLEPRODUCT.2.0ORADATAORCLUSERS01.DBF

converted datafile=C:ORACLEPRODUCT.2.0DB_1DATABASEDATA_D-ORCL_I-11065436

23_TS-USERS_FNO-4_01I6JT63

channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03

Finished backup at 03-JAN-07



RMAN> SQL 'ALTER TABLESPACE users READ WRITE';


sql statement: ALTER TABLESPACE users READ WRITE



RMAN> exit





Recovery Manager complete.


Z:>