oracle12c主备搭建,ORACLE 12C DATAGUARD环境搭建和主从切换

环境说明：

目的：

(1)在linux 操作系统下，创建oracle 12c 单实例的dataguard环境

(2)测试dataguard主从切换

主库：10.50.115.12 (DB_UNIQUE_NAME=cdbtest,service_name=cdbtest,db_name=cdbtest)

从库：10.50.115.20 (DB_UNIQUE_NAME=cdbtest1,service_name=cdbtest,db_name=cdbtest)

备注：DB_UNIQUE_NAME不能一样

-------------------------------------------------------------------------------

一、创建oracle 12c 单实例的dataguard环境

主库：

mkdir -p /u01/app/oracle/arch/

chown oracle.oinstall /u01/app/oracle/arch/

1. 开启归档模式

sqlplus / as sysdba

startup mount

alter database archivelog;

alter database open;

2. 配置TNS,增加连接到从库的tns:

cat >> $ORACLE_HOME/network/admin/tnsnames.ora << EOF

cdbtest1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.115.20)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = cdbtest)

)

)

EOF

3. 修改主库的dataguard相关参数

alter system set standby_file_management='auto'  scope=both;

alter system set log_archive_config='dg_config=(cdbtest,cdbtest1)'  scope=both;