Use RAC and mongouard to build the AA Architecture

The standby technology is introduced in the previous configuration process (see www.linuxidc.comlinux2012-0152055.htm)

In the previous configuration process of migrating a single instance database to the rac environment (see the http://www.linuxidc.com/Linux/2012-01/52055.htm), the use of standby technology is introduced.

In the previous configuration process of migrating a single-instance database to the rac environment (SEE), this article describes how to use standby technology to build a data guard model for the physical standby database of a single-instance master database, this section describes how to build the data guard model for the physical standby database of a single instance for the primary database of rac. In the MAS architecture, ASM provides a storage grid, RAC provides grid computing at the database level. data guard focuses on data backup and disaster tolerance. For more information about apsaradb for redis, refer to the following link!

I. Introduction to the environment of the master and slave Databases
Master database:
Database Version: 10.2.0.5
OS Version: 64-bit CentOS4.8
Database Name: rac (two instances)
Instance name: rac1, rac2
IP Address: 192.168.1.41/24, 24,192.168 .1.42/24
Db_unique_name: rac
Service name: rac.yang.com
Listener port 1521
Storage Type: OMF + ASM disk, + DATA, + FRA

Slave database:
Database Version: 10.2.0.5
OS Version: rhel5.4 64-bit
Database Name: rac (Single Instance)
Instance name: orcl
IP Address: 192.168.1.49/24
Db_unique_name: orcl
Service name: orcl.yang.com
Listener port 1521
Storage Type: file system + OMF

Make sure that the rac environment of the master database is normal before you start. You only need to install the database software for the slave database.

[Oracle @ rac1 ~] $ Crs_stat-t-v
Name Type R/ra f/FT Target State Host
----------------------------------------------------------------------
Ora. rac. db application 0/0 0/1 ONLINE rac1
Ora... c1.inst application 0/5 0/0 ONLINE rac1
Ora... c2.inst application 0/5 0/0 ONLINE rac2
Ora... SM1.asm application 0/5 0/0 ONLINE rac1
Ora... C1.lsnr application 0/5 0/0 ONLINE rac1
Ora. rac1.gsd application 0/5 0/0 ONLINE rac1
Ora. rac1.ons application 0/3 0/0 ONLINE rac1
Ora. rac1.vip application 0/0 0/0 ONLINE rac1
Ora... SM2.asm application 0/5 0/0 ONLINE rac2
Ora... C2.lsnr application 0/5 0/0 ONLINE rac2
Ora. rac2.gsd application 0/5 0/0 ONLINE rac2
Ora. rac2.ons application 0/3 0/0 ONLINE rac2
Ora. rac2.vip application 0/0 0/0 ONLINE rac2

2. Configure the listener and the tnsnames. ora file as follows. Configure the listener on node 2 of rac as follows:

[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:
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)
)
)