使用DGBROKER配置dataguard测试.docx

使用DGBROKER配置dataguard测试 环境准备： 准备两台电脑安装好linux X64，配置相同的环境变量，安装好oracle数据库软件，做为主端的数据库上建立好一个数据库实例，做为备端的数库库仅装好软件即可。主、备端都建好监听。 测试： 1、主库开启强制日志 [oracle@ADGTEST1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 16 15:02:17 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL alter database force logging; Database altered. SQL 2、主库开归档日志 SQL shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL startup mount; ORACLE instance started. Total System Global Area 1620115456 bytes Fixed Size 2253704 bytes Variable Size 1073745016 bytes Database Buffers 536870912 bytes Redo Buffers 7245824 bytes Database mounted. SQL alter database archivelog; Database altered. SQL alter database open; Database altered. SQL 3、主库修改相关数据库参数 a) 修改db_unique_name SQL alter system set db_unique_name=porcl scope=spfile; System altered. SQL b) 修改standby_file_management SQL alter system set standby_file_management=AUTO scope=spfile; System altered. SQL 4、主库配置静态网络监听 采用图形方式进行配置，运行netmgr。 \ 完成后，保存退出。 注：“Oracle 主目录”框中的路径最后结尾的那个“/”需要删除。 完成后的内容： [oracle@ADGTEST1 ~]$ cd $ORACLE_HOME/network/admin [oracle@ADGTEST1 admin]$ cat listener.ora # listener.ora Network Configuration File: /mnt_array/OracleDB/DB/oracle/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /mnt_array/OracleDB/DB/oracle) (SID_NAME = orcl) ) (SID_DESC = (GLOBAL_DBNAME = porcl) (ORACLE_HOME = /mnt_array/OracleDB/DB/oracle) (SID_NAME = orcl) ) (SID_DESC = (GLOBAL_DBNAME = porcl_DGMGRL) (ORACLE_HOME = /mnt_array/OracleDB/DB/oracle) (SID_NAME = orcl) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADD