Oracle 11g单实例RMAN恢复到Oracle 11g RAC(4)

Starting restore at 2017/09/16 09:12:58
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=171 instance=orcl1 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/orcl/controlfile/current.260.937131879
output file name=+RECOVERY/orcl/controlfile/current.256.937131879
Finished restore at 2017/09/16 09:13:00

5. 通过备份的控制文件启动到mount状态

注：具体哪个文件还原控制文件，可参数源端运行 list backup of controlfile 可知。

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

6. 将备份集注册进控制文件里

RMAN> crosscheck backupset;
RMAN> catalog start with '/u01/orabak';
RMAN> list backup summary;

List of Backups
===============
Key    TY LV S Device Type Completion Time    #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
1      B  F  A DISK        2017/09/16 08:28:46 1      1      NO        TAG20170916T082835
2      B  F  A DISK        2017/09/16 08:28:52 1      1      NO        TAG20170916T082835
3      B  F  A DISK        2017/09/16 08:28:53 1      1      NO        TAG20170916T082835
4      B  F  A DISK        2017/09/16 08:29:14 1      1      NO        TAG20170916T082835
5      B  A  A DISK        2017/09/16 08:29:23 1      1      NO        TAG20170916T082923
6      B  A  A DISK        2017/09/16 08:29:23 1      1      NO        TAG20170916T082923
7      B  A  A DISK        2017/09/16 08:29:24 1      1      NO        TAG20170916T082923
8      B  F  A DISK        2017/09/16 08:29:24 1      1      NO        TAG20170916T082924

7. 查看与记录数据库信息

由于控制文件记录的是原oracle10g rac数据库文件的信息，需要记录下来在恢复时进行修改。

(1) 查看源端数据文件及编号

$ sqlplus / as sysdba;

SQL> set pagesize 999;
SQL> set linesize 200;
SQL> col NAME for a65
SQL> select file#,name from v$datafile;

FILE# NAME
---------- -----------------------------------------------------------------
    1 /u01/app/oracle/oradata/orcl/system01.dbf
    2 /u01/app/oracle/oradata/orcl/sysaux01.dbf
    3 /u01/app/oracle/oradata/orcl/undotbs01.dbf
    4 /u01/app/oracle/oradata/orcl/users01.dbf
    5 /u01/app/oracle/oradata/orcl/tjoa.dbf

(2) 查看联机日志文件

SQL> col MEMBER for a65
SQL> select member from v$logfile;
SQL> select member from v$logfile;