CentOS7.5搭建ORACLE RAC+DG

环境

RAC+DG	RAM:4G  ,OS:CENTOS7.5
HOSTNAME:RAC1：	PUBLIC IP:162.168.145.244，PRIV IP:192.168.89.219，VIP:192.168.145.144,scanip:192.168.145.140
HOSTNAME:RAC2：	PUBLIC IP:162.168.145.245，PRIV IP:192.168.89.220，VIP:192.168.145.145,scanip:192.168.145.140
备库(hostname:racdg):	ip:192.168.145.247
rac DB	DB_NAME=oem      db_unique_Name=oem
备库	DB_NAME=oem      db_unique_name=oem_dg

安装步骤

1.主库（也就是RAC）设置强制归档

sql> alter database force loggin

如果数据库未开启归档,通过以下的方式进行开启

查看数据库是否运行在归档模式：

sql>archive log list;

如上所示未开启归档，可按下面方法开启数据库归档

SQL> shutdown immediate    #关闭数据库

SQL> startup mount;    #启动到mount状态

SQL> alter database archivelog;    #开启归档

SQL> alterdatabase open;   #open数据库

2.主库设置参数

alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(oem,oem_dg)' scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oem' scope=both sid='*';
alter system set LOG_ARCHIVE_DEST_2='SERVICE=oem_dg LGWR AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=oem_dg' scope=both sid='*';
alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
alter system set log_archive_max_processes=4 scope=both sid='*';
alter system set fal_server=oem_dg scope=both sid='*';
alter system set DB_FILE_NAME_CONVERT='/oradata/oem_dg/datafile/','+DATADG/oem/datafile/' scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT&