Rman异机恢复

hunter

1.全库备份，scp到异机目录下
  查询源库的DBID:
  SQL> select name,dbid from v$database;

        NAME                     DBID
        ------------------ ----------
        RESEARCH           2055556290

  SQL>
  异机建立dump目录、oradata下建立SID名对应目录
  
2.恢复spfile，启动到nomount:   
  export ORACLE_SID=research
  rman target /
  set dbid=2055556290
  startup nomount
  restore spfile to pfile '/rman/initresearch.ora' from '/rman/backupspec/level0_RESEARCH_12692_1_1_20140407.dbf';
  startup force nomount pfile='/rman/initresearch.ora';

3.恢复控制文件，启动到mount
restore controlfile from '/rman/backupspec/level0_RESEARCH_12691_1_1_20140407.dbf';
alter database mount;

4.恢复数据库
登记备份段:
catalog start with '/rman/backupspec/';

restore database;

recover database;

5.alter database open resetlogs;