环境介绍:
- RAC集群环境Oracle11g
IP:192.168.20.11
IP:192.168.20.12
Rac1、rac2的grid软件,数据库软件都已建好,不建库
2.单实例,从开始建库到结束,一直开着归档,归档模式
目标
目的是单实例做全备,恢复到RAC单节点1环境启库,单节点1恢复完启库,单节点2再启库,把两节点加入集群
全库备份见上一篇文章“Rman单机备份到恢复详细过程” 有脚本及注释
一节点Pfile启库
脚本:
arorcl1.__db_cache_size=436207616
arorcl2.__db_cache_size=436207616
arorcl1.__java_pool_size=16777216
arorcl2.__java_pool_size=16777216
arorcl1.__large_pool_size=16777216
arorcl2.__large_pool_size=16777216
arorcl1.__oracle_base='/u01/oracle/app'#ORACLE_BASE set from environment
arorcl2.__oracle_base='/u01/oracle/app'#ORACLE_BASE set from environment
arorcl1.__pga_aggregate_target=503316480
arorcl2.__pga_aggregate_target=503316480
arorcl1.__sga_target=754974720
arorcl2.__sga_target=754974720
arorcl1.__shared_io_pool_size=0