oracle11g dataguard安装实施

最新推荐文章于 2024-10-23 09:47:46 发布

原创

最新推荐文章于 2024-10-23 09:47:46 发布 · 8.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #11g #dataguard #安装 #dg

本文详细介绍了如何在Oracle 11g中设置DataGuard，包括环境准备、修改配置文件、设置主库参数、创建全备份集和控制文件，以及在备机上恢复数据库和建立主备库的standby关系。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle DataGuard 实施

1.环境准备
1.1 修改主备机hosts文件

vi /etc/hosts
128.160.11.84 wang
128.160.11.218 dg2

1.2 修改(添加）主备机listener.ora和tnsnames.ora文件

vi $ORACLE_HOME/network/admin/listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = softdb)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1/)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wang)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = /u01/app/oracle

vi $ORACLE_HOME/network/admin/tnsnames.ora

SOFTPRI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = wang)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = softdb)
)
)
SOFTSTD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = softdb)
)
)

1.3 确定主备机parameter/control/data/log/archivelog file 的路径

audit_file_dest='/u01/app/oracle/admin/softdb/adump'

1.4 设置主库强制写日志

SQL> select force_logging from v$database;

FOR
---
NO

SQL> alter database force logging;

Database altered.

SQL> select force_logging from v$database;

FOR
---
YES

1.5 设置主库归档模式

SQL> archive log list;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQ

最低0.47元/天解锁文章