oracle adg介绍，adg搭建指南
作为oracle数据库提供的一种容灾方式，ADG在我们日常生产中还是比较常见的，如何更快更好的搭建一套ADG，也是一个DBA需要掌握的基本技能。
一、环境准备
IP: 172.25.18.251
DATABASE VERSION: 11.2.0.4.0
DB_NAME:ptgbss
DB_UNIQUE_NAME:ptgbss
Standby Database
先搭建好备库的数据库软件，无需建库。保持主库和备库的DB_NAME参数一致，DB_UNIQUE_NAME参数不能一致。
[oracle@localhost ~]$ telnet 172.25.18.252 1521 Trying 172.25.18.252... Connected to 172.25.18.252. Escape character is '^]'. ^C ^CConnection closed by foreign host. [oracle@localhost ~]$
vi /u01/product/11.2.0/db_1/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/product/11.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. PTGBSS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.18.251)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ptgbss) ) ) PTGBSSDG = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.18.252)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ptgbssdg) (UR=A) ) )
tnsping 测试一下是否通：
[oracle@localhost admin]$ tnsping ptgbssdg
2.3 主库开启force_logging
查看是否已经开始强制日志：
select force_logging from v$database;
开启强制日志：
ALTER DATABASE FORCE LOGGING;
2.4 主库配置DG相关参数
主库添加standby 日志，日志大小与online日志保持一致，数量比online日志数量多一组：
set line 200 col member for a50 SELECT * FROM V$LOGFILE;
alter database add standby logfile thread 1 group 10 '/u01/oradata/ptgbss/redo10.log' size 1024M; alter database add standby logfile thread 1 group 11 '/u01/oradata/ptgbss/redo11.log' size 1024M; alter database add standby logfile thread 1 group 12 '/u01/oradata/ptgbss/redo12.log' size 1024M; alter database add standby logfile thread 1 group 13 '/u01/oradata/ptgbss/redo13.log' size 1024M; alter database add standby logfile thread 1 group 14 '/u01/oradata/ptgbss/redo14.log' size 1024M; alter database add standby logfile thread 1 group 15 '/u01/oradata/ptgbss/redo15.log' size 1024M; alter database add standby logfile thread 1 group 16 '/u01/oradata/ptgbss/redo16.log' size 1024M; alter database add standby logfile thread 1 group 17 '/u01/oradata/ptgbss/redo17.log' size 1024M; alter database add standby logfile thread 1 group 18 '/u01/oradata/ptgbss/redo18.log' size 1024M; alter database add standby logfile thread 1 group 19 '/u01/oradata/ptgbss/redo19.log' size 1024M;
修改DG相关参数：
alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(ptgbss,ptgbssdg)' scope=both ; alter system set LOG_ARCHIVE_DEST_1='LOCATION=/data/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ptgbss' scope=both; alter system set LOG_ARCHIVE_DEST_2='SERVICE=ptgbssdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ptgbssdg' scope=both; alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=both; alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=both; alter system set FAL_SERVER=ptgbssdg scope=both; alter system set FAL_CLIENT=ptgbss scope=both; alter system set standby_file_management=auto; alter system set db_file_name_convert='/data/ptgbssdg','/data/ptgbss' scope=spfile; alter system set log_file_name_convert='/u01/oradata/ptgbssdg','/u01/oradata/ptgbss' scope=spfile;
2.5 生成PFILE参数文件
create pfile from spfile;
2.6 传输参数文件和密码文件到备库
[oracle@localhost dbs]$ scp /u01/product/11.2.0/db_1/dbs/initptgbss.ora 172.25.18.252:/u01/product/11.2.0/db_1/dbs [oracle@localhost dbs]$ scp /u01/product/11.2.0/db_1/dbs/orapwptgbss 172.25.18.252:/u01/product/11.2.0/db_1/dbs
本文地址：百科问答频道 https://www.neebe.cn/wenda/903385.html，易企推百科一个免费的知识分享平台，本站部分文章来网络分享，本着互联网分享的精神，如有涉及到您的权益，请联系我们删除，谢谢！
相关阅读
