在前面的单实例数据库迁移至rac环境配置过程中（见 ），，介绍了使用standby技术构建单实例主库对应rac物理备库的data guard模型，本节中将介绍rac主库对应单实例物理备库的data guard模型构建；在maa架构中，asm提供了存储方面的网格，rac提供了数据库层面上的网格计算，data guard则着重强调在数据的备份和容灾方面，更多maa方面的知识，参考下面的链接!
一：主备库的环境介绍
主库：
数据库版本：10.2.0.5
os版本：centos4.8 64位
数据库名：rac（两个实例）
实例名：rac1,rac2
ip地址:192.168.1.41/24,192.168.1.42/24
db_unique_name: rac
服务名：rac.yang.com
监听器端口：1521
存储类型：omf+asm磁盘组，+data,+fra
备库：
数据库版本：10.2.0.5
os版本：rhel5.4 64位
数据库名：rac （单实例）
实例名：orcl
ip地址:192.168.1.49/24
db_unique_name: orcl
服务名：orcl.yang.com
监听器端口：1521
存储类型：文件系统+omf
在开始前确保主库rac环境正常，备库只需要安装数据库软件即可，不需要建库
[oracle@rac1 ~]$ crs_stat -t -v
name type r/ra f/ft target state host
----------------------------------------------------------------------
ora.rac.db application 0/0 0/1 online online rac1
ora....c1.inst application 0/5 0/0 online online rac1
ora....c2.inst application 0/5 0/0 online online rac2
ora....sm1.asm application 0/5 0/0 online online rac1
ora....c1.lsnr application 0/5 0/0 online online rac1
ora.rac1.gsd application 0/5 0/0 online online rac1
ora.rac1.ons application 0/3 0/0 online online rac1
ora.rac1.vip application 0/0 0/0 online online rac1
ora....sm2.asm application 0/5 0/0 online online rac2
ora....c2.lsnr application 0/5 0/0 online online rac2
ora.rac2.gsd application 0/5 0/0 online online rac2
ora.rac2.ons application 0/3 0/0 online online rac2
ora.rac2.vip application 0/0 0/0 online online rac2
二：配置监听器和tnsnames.ora文件如下，rac节点2上需要同样进行配置
[oracle@rac1 ~]$ cat $oracle_home/network/admin/listener.ora
listener_rac1 =
(description_list =
(description =
(address = (protocol = tcp)(host = rac1-vip.yang.com)(port = 1521)(ip = first))
(address = (protocol = tcp)(host = 192.168.1.41)(port = 1521)(ip = first))
)
)
sid_list_listener_rac1 =
(sid_list =
(sid_desc =
(oracle_home = /u01/app/oracle/product/10.2.0/db_1)
(global_dbname=rac_dgmgrl.yang.com)
(sid_name = rac1)
)
)
connected to:
oracle database 10g enterprise edition release 10.2.0.5.0 - 64bit production
with the partitioning, real application clusters, olap, data mining
and real application testing options
sql>
[oracle@rac1 ~]$ cat $oracle_home/admin/tnsnames.ora
listeners_rac =
(address_list =
(address = (protocol = tcp)(host = rac1-vip.yang.com)(port = 1521))
(address = (protocol = tcp)(host = rac2-vip.yang.com)(port = 1521))
)
listener_rac1 =
(address_list =
(address = (protocol = tcp)(host = rac1-vip.yang.com)(port = 1521))
)
listener_rac2 =
(address_list =
(address = (protocol = tcp)(host = rac1-vip.yang.com)(port = 1521))
)
rac =
(description =
(address = (protocol = tcp)(host = rac1-vip.yang.com)(port = 1521))
(address = (protocol = tcp)(host = rac2-vip.yang.com)(port = 1521))
(load_balance = yes)
(connect_data =
(server = dedicated)
(service_name = rac.yang.com)
)
)