Dataguard配置手册.docx

DATAGUARD 配置手册一、 DATAGUARD 体系架构图二、配置步骤 1. 首先在节点 1用 dbca 创建实例, 节点 2 不安装实例, 只装数据库软件即可, 如果节点 1 是现成运行的数据库, 则不需要新建; 2. 把主节点 1的 配置成如下,并把该文件复制到备节点 2 的相同目录下: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl ))) ORCLBAK = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orclbak )))注: 这里要注意红色部分,要根据自己的情况对 IP 和服务名进行调整; 3. 配置两个节点的监听: 设置如下( 用现成的监听文件即可,无需修改): 主节点 1 设置: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = shck70data279 )(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) )) 红色部分位节点 1 的主机名,确认好配置后把这个监听文件拷贝到节点 2 相同的目录下,并调整: 备节点 2 设置: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = shck70data280 )(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) )) 注:这里将红色的主机名改为节点 2 的主机名 4. 主节点设置强制写日志 SQL> select FORCE_LOGGING from v$database; NO SQL> alter database force logging; SQL> select FORCE_LOGGING from v$database; YES 5. 把主节点的密码文件拷到备节点相同的目录下(名字要一样,别改名,本例是 文件): 6. 主节点创建 PFILE 并增加修改如下: SQL>create pfile from spfle; 找到 文件: =5251268608 =16777216 =16777216 ='E:\u01'#ORACLE_BASE set from environ