Use RAC and Data Guard to build the MAS Architecture

In the previous configuration process of migrating a single-instance database to the rac environment (SEE), we introduced the use of standby technology to build the 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!
Http://www.oracle.com/technetwork/database/features/availability/maa-090890.html

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) ) ) [Oracle @ rac1 ~] $ Sqlplus sys/123456@192.168.1.41: 1521/rac_DGMGRL.yang.com as sysdba SQL * Plus: Release 10.2.0.5.0-Production on Thu Jan 12 10:56:05 2012 Copyright (c) 1982,201 0, Oracle. All Rights Reserved. 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) ) ) RAC1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = rac1-vip.yang.com) (PORT = 1521 )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac.yang.com) (INSTANCE_NAME = rac1) ) ) RAC2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = rac2-vip.yang.com) (PORT = 1521 )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rac.yang.com) (INSTANCE_NAME = rac2) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = server49.yang.com) (PORT = 1521 )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.yang.com) (INSTANCE_NAME = orcl) ) )

1 2 3 4 Next Page