1.1 恢复spfile
根据rman备份的log确认dbid以及spfile在哪个备份中
set dbid=2494162093
RMAN> startup nomount
RMAN> restore spfile from /home/oracle/rman11204/RAC_20160311_11_1_dbfull;
生成pfile,修改sga,pga,audit_trail,instance_number,db_create_file_dest, db_create_online_log_dest_1等参数,生成新的spfile。
1.2 恢复controlfile
RMAN> restore controlfile from /home/oracle/rman11204/RAC_20160311_11_1_dbfull;
1.3 恢复数据文件
RMAN> alter database mount;
rman target / nocatalog log /home/oracle/rman_restore.log append << EOF
run{
allocate channel c1 type