oracle DG搭建(使用DGbroker)
来源:互联网 发布:2016最新癌症数据统计 编辑:程序博客网 时间:2024/06/05 15:09
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;
d.启用配置文件:enable configuration
e.查看配置:show configuration
- oracle DG搭建(使用DGbroker)
- oracle数据库使用dgbroker搭建DG以及一些常见的小问题
- oracle 11g dgbroker搭建dataguard
- ORACLE之搭建DG(ADG方式)
- ORACLE之搭建DG(ADG方式)
- oracle DG搭建
- Oracle DG broker搭建
- [oracle]Oracle 11g DG搭建(备库使用ASM)
- Oracle DG -Data Guard 搭建
- oracle 11g DG 搭建
- oracle DG模式搭建详解
- ORACLE之搭建DG(COPY数据文件方式)
- ORACLE之搭建DG(RMAN Duplicate方式)
- Oracle 12C DG 搭建(RAC-RAC/RAC-单机)
- Oracle 11g搭建DG(ADG方式)
- [oracle]Oracle 11g 逻辑DG搭建
- 单机搭建oracle dg 实验与总结
- Oracle之DataGurd(DG)环境搭建
- 操作系统---基础题目汇总七
- 一个小白对auth的理解
- C-054.学习OC之前,需要掌握和理解的C语言的基础部分基本写完了
- PAT乙级 德才论 (25)
- Nginx的负载均衡 - 加权轮询 (Weighted Round Robin) 下篇
- oracle DG搭建(使用DGbroker)
- online_judge_1025
- eclipse 在复制/粘贴 时很卡
- hdoj--1023 Train Problem II (高精度乘除法)
- centos7折腾-我要关机
- File基本操作
- 项目二——(2)
- Atom前段编辑工具
- 本地推送