环境
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&