销售系统数据库DataGuard方案配置实施步骤

Dataguard配置实施方案目录1.DataGuard配置条件................................................................................................22.实施计划...................................................................................................................23.判断DataGuard是否安装.......................................................................................22.网络配置：主库和备库..............................................................................................24.配置hosts文件：主库和备库................................................................................35.监听配置：主库和备库...........................................................................................36.修改主库备库到归档模式.......................................................................................55.创建主库口令文件......................................................................................................67.修改主库初始化参数pfile.......................................................................................68.创建备份库需要的控制文件...................................................................................89.创建主库的spfile.....................................................................................................810.备份生产数据库...................................................................................................811.修改备库初始化参数pfile...................................................................................912.复制备库控制文件.............................................................................................1013.在备库上创建口令文件.....................................................................................1014.创建备库的spfile...............................................................................................1015.启动物理备用数据库.........................................................................................1016.配置StandbyRedoLog.......................................................................................1017.RedoApply的启动和停止.................................................................................11Dataguard配置实施方案1.DataGuard配置条件DataGuard的备库有物理standby和逻辑standby两种，由于逻辑standby的局限性，生产环境选择物理standby作为DataGuard的备库。实现物理standby需要具备以下条件：1、oralce数据库必须是企业版，企业版才支持DataGuard；2、DataGuard中的数据库运行的平台必须相同；3、DataGuard中的主库和备库必须运行于归档模式；4、DataGuard中的主库和备库的db_name必须相同、db_unique_name必须不同；5、使用具有相关sysdba权限的用户管理primary和standby数据库。2.实施计划对于在DataGuard实施的第一步的实施计划如下：日期工作内容备注2013-11-18检查数据库是否满足配置要求2013-11-19配置DataGuard，并进行相关验证2013-11-20进行DataGuard管理，验证主备库切换3.判断DataGuard是否安装Sqlselect*fromv$optionwhereparameter='OracleDataGuard';返回结果为空，DG没有配置。2.网络配置：主库和备库主库操作系统版本：centos5.4数据库版本:Database11gEnterpriseEditionRelease11.2.0.1.0Ip地址：172.34.21.204Db_name：standbydDb_unique_name：standbydinstance_name：primaryservice_names：standbyd备库操作系统版本：centos5.4数据库版本:Database11gEnterpriseEditionRelease11.2.0.1.0Ip地址：172.34.21.205Db_name：standbydDb_unique_name：standbydbinstance_name：standbyDataguard配置实施方案service_names：standbydb4.配置hosts文件：主库和备库vi/etc/hosts#Donotremovethefollowingline,orvariousprograms#thatrequirenetworkfunctionalitywillfail.127.0.0.1hlht-db1localhost.localdomainlocalhost::1localhost6.localdomain6localhost610.52.151.102hlht-db110.52.151.103hlht-db25.监听配置：主库和备库主库：配置主库监听和tns:[oracle@hlht-db1~]$cd$ORACLE_HOME/network/admin[oracle@hlht-db1admin]$catlistener.ora#listener.oraNetworkConfigurationFile:/opt/oracle/112/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.#addSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=/opt/oracle/112)(PROGRAM=extproc))(SID_DESC=(GLOBAL_DBNAME=primary)(ORACLE_HOME=/opt/oracle/112)(SID_NAME=primary)))#addLISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.132.204)(PORT=1561))#(ADDRESS=(PROTOCOL=TCP)(HOST=172.34.21.204)(PORT=1561))))Dataguard配置实施方案[oracle@hlht-db1admin]$cattnsnames.ora#tnsnames.oraNetworkConfigurationFile:/opt/oracle/112/network/admin/tnsnames.ora#GeneratedbyOracleconfigurationtools.STANDBYD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.132.204)(PORT=11731))#(ADDRESS=(PROTOCOL=TCP)(HOST=172.34.21.204)(PORT=11731))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=primary)))STANDBYDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.132.205)(PORT=11731))#(ADDRESS=(PROTOCOL=TCP)(HOST=172.34.21.205)(PORT=11731))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=standby)))备库：配置备库监听和tns:[oracle@hlht-db2~]$cd$ORACLE_HOME/network/admin[oracle@hlht-db2admin]$catlistener.ora#listener.oraNetworkConfigurationFile:/opt/oracle/112/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=/opt/oracle/112)(PROGRAM=extproc))(SID_DESC=(GLOBAL_DBNAME=standby)(ORACLE_HOME=/opt/oracle/112)(SID_NAME=standby))Dataguard配置实施方案)LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.132.205)(PORT=11731))#(ADDRESS=(PROTOCOL=TCP)(HOST=172.34.21.205)(PORT=11731)))[oracle@hlht-db2admin]$cattnsnames.ora#tnsnames.oraN