Oracle 11g DataGuard 配置详细说明
1.判断DataGuard是否安装
select * from v$option where parameter = 'Oracle Data Guard';
2. 数据库环境说明
主库配置:IP:192.168.228.133(Oracle11g1),数据库名:db1,监听服务名:db1pri,网络服务名:pri
从库配置:IP:192.168.229.134(Oracle11g2),数据库名:db1,监听服务名:db1dg ,网络服务名:dg
数据库程序安装路径:/oracleapp/oinstall/oracle/product/11.2.0/dbhome_1/dbs
数据库存放路径:/oracledata/db1
3.监听配置
在做oracle dataguard主从库配置时候,一定要配置静态监听,否则可能出现监听服务解析错误,不能连接的问题,监听配置如下:
主库配置如下:
[oracle@Oracle11g1 admin]$ pwd
/oracleapp/oinstall/oracle/product/11.2.0/dbhome_1/network/admin
[oracle@Oracle11g1 admin]$ cat listener.ora
# listener.ora Network Configuration File:
/oracleapp/oinstall/oracle/product/1.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
WU =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Oracle11g2)(PORT = 1521))
)
)
SID_LIST_WU =
(SID_LIST =