ORACLE RMAN 跨平台恢复测试(Windows->Linux)

原数据库为ORACLE11G 11.2.0.3，跑在64位WINDOWS上，使用RMAN做了个备份，将备份文件上传到Linux服务器上的/home/oracle/rmanbackup目录中，准备恢复到64位LINUX上，过程如下：

 

将数据库启动到nomount状态

oracle@changeme:~> sqlplus /nolog
SQL> conn / as sysdba
SQL> startup nomount
SQL> exit

进入RMAN进行恢复

oracle@changeme:~> rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Jun 29 17:39:40 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CSDB (not mounted)

RMAN> set DBID=3039653104

executing command: SET DBID


RMAN> restore controlfile from '/home/oracle/rmanbackup/CTL_0FODDSB1_20130629';

Starting restore at 29-JUN-13
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/csdb/control01.ctl
Finished restore at 29-JUN-13

RMAN> sql 'alter database mount';

sql statement: alter database mount
released channel: ORA_DISK_1

RMAN> catalog start with '/home/oracle/rmanbackup';

Starting implicit crosscheck backup at 29-JUN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 29-JUN-13

Starting implicit crosscheck copy at 29-JUN-13
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 29-JUN-13

searching for all files in the recovery area
cataloging files...
no files cataloged

searching