Rman异机恢复
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;
页:
[1]