ORACLE RAC+DG(单实例)

ORACLE RAC+DG(单实例)
前提条件：
1.主库RAC已经成功安装,数据库也已经创建。
2.DG备库已经安装完相同版本的oracle软件，无需创建数据库。

1、RAC开启归档。
任意节点:

alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
alter system set log_archive_dest_1='LOCATION=+DATA/arch' scope=spfile sid='*';
srvctl stop database -d racdb -o immediate
startup mount
alter database archivelog;
alter database open;
srvctl start database -d racdb

查看每个节点的归档

alter system switch logfile;
archive log list;

每个节点的归档序号是不一样的。

2、启用force logging功能

select force_logging from v$database;
alter database force logging;

3、查询主库日志文件

select thread#,group#,members,bytes/1024/1024 from v$log;
alter database add standby logfile thread 1 group 11 size 50m;
alter database add standby logfile thread 1 group 12 size 50m;
alter database add standby logfile thread 1 group 13 size 50m;
alter database add standby logfile thread 2 group 14 size 50m;
alter database add standby logfile thread 2 group 15 size 50m;
alter database add standby logfile thread 2 group 16 size 50m;

3、配置主库的初始化参数

alter system set db_unique_name='racdb' scope=spfile;
alter system set log_archive_config='DG_CONFIG=(racdb,racdg)' scope=both sid='*';
alter system set log_archive_dest_1='LOCATION=+data/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdb' scope=both sid='*';
alter system set log_archive_dest_2='SERVICE=racdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdg' scope=both sid='*';
alter system set log_archive_format='%t_%s_%r.arc&#