ORACLE 11G DataGuard 环境搭建、配置和管理
QQ:392815095 MAIL:biyan_111@126.com
)
ADR_BASE_LISTENER = /oracle/app/oracle
注意:这里配置的是静态监听,下面在 duplicate 数据库时启动到 nomount 状态,nomount 状态下数据库不
动态去注册监听。
3. 修改配置 tnsname.ora 文件
说明:ORCL 是主库的服务名,DG 是备库的服务名。
$ vi /oracle/app/oracle/product/11.2/db_2/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File:
/oracle/app/oracle/product/11.2/db_2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PACS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pacs)
)
)
DG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pacs)
)
)
测试服务名连通性:
tnsping PACS
tnsping DG
4. 创建 11g 数据库基本目录
# su - oracle
mkdir -p /oracle/app/oracle/admin/pacs/{adump,dpdump,pfile,scripts}
mkdir -p /oracle/oradata/pacs
mkdir -p /oracle/app/oracle/fast_recovery_area/pacs
mkdir -p /oracle/app/oracle/product/11.2/db_2/dbs/archive
5. 修改 pfile 参数文件
$ vi /home/oracle/initpacs.ora
orcl.__db_cache_size=314572800