oracle DG搭建（使用DGbroker）

最新推荐文章于 2025-03-10 14:58:12 发布

vijayfly

最新推荐文章于 2025-03-10 14:58:12 发布

阅读量434

点赞数

本文链接：https://blog.youkuaiyun.com/ilai0091/article/details/50197931

版权

本文详细介绍了在CentOS 6.5环境下部署Oracle 11.2.0.4双活数据库集群的全过程，包括环境准备、主从库设置、备份与克隆等关键步骤，确保数据库系统的高可用性和数据一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.环境：

a.主机环境：centos6.5

b.软件环境：oracle 11.2.0.4

DG1：192.168.100.51（数据库sid：atest）

DG2：192.168.100.52

2.前提工作（主从都要设置）：

a.关闭防火墙：/etc/init.d/iptables stop

b.关闭selinux：setenforce 0

查看状态：getenforce（关闭状态：Permissive）

3.主库设置：

a.设置主库db_unique_name：alter system set db_unique_name='patest' scope=spfile;

b.设置主库为强制记录日志：alter database force logging;

检查状态(YEs为强制)：select name,force_logging from v$database;

c.设置standy_file_management：alter system set standby_file_management ='AUTO';

检查状态：show parameter standby

d.创建standbylog：

<span style="white-space:pre">	</span># mkdir $ORACLE_BASE/oradata/ATEST/standbylog
<span style="white-space:pre">	</span>sql> alter database add standby logfile group  11 '/u01/app/oracle/oradata/ATEST/standbylog/standby11.log' size 50M;
<span style="white-space:pre">	</span>sql> alter database add standby logfile group  12 '/u01/app/oracle/oradata/ATEST/standbylog/standby12.log' size 50M;
<span style="white-space:pre">	</span>sql> alter database add standby logfile group  13 '/u01/app/oracle/oradata/ATEST/standbylog/standby13.log' size 50M;
<span style="white-space:pre">	</span>sql> alter database add standby logfile group  14 <span style="font-family: Arial, Helvetica, sans-serif;">'/u01/app/oracle/oradata/ATEST/standbylog/standby14.log' size 50M;</span><span style="font-family: Arial, Helvetica, sans-serif;"></span>

e.开启归档：alter database archivelog;

alter system set log_archive_dest_1='location=/u01/app/oracle/oradata/ATEST/archivelog';

f.传输pfile和密码文件：

create pfile from spfile;

scp initatest.ora orapwatest 192.168.100.52:/u01/app/oracle/product/11.2.0/db1/dbs/

g.开启DGbroker：alter system set DG_BROKER_START=TRUE

h.设置监听：atest,patest,patest_DGMGRL

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = atest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = patest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = patest_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = vijay01.database.com)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

i.设置tnsnames.ora

ATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.51)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )


PATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.51)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

SATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.52)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

4.备库设置：

a.设置监听：atest,satest,satest_DGMGRL

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = atest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = satest)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = satest_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db1)
      (SID_NAME = atest)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = vijay02.database.com)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

b.设置tnsnames.ora

ATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.52)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )


SATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.52)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

PATEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.51)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = atest)
    )
  )

5.备份主库：

a.rman target /

b.backup database;

6.在备库上克隆主库：

a.修改备库pfile上的db_unique_name=satest

b.启动数据库到nomount：startup nomount

c.登陆rman：rman target sys/123456@patest auxiliary sys/123456@satest

d.开始克隆： duplicate target database for standby nofilenamecheck from active database;

7.设置DGbroker：

a.登陆dgmgrl：dgmgrl sys/123456@patest

b.设置主库：create configuration dgc as primary database is patest connect identifier is patest;

c.添加备库：add database satest as connect identifier is satest maintained as physical;