Oracle dataguard 11G 配置与维护手册

《Oracle dataguard 11G 配置与维护手册》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle11gR2Dataguard配置手册1．判断DataGuard是否安装select*fromv$optionwhereparameter='OracleDataGuard';2.网络配置192.168.1.10（orcl）------------------------------------192.168.1.20(dg)3.监听配置主库[oracle@node1~]$cd/u01/app/product/11.2.0/db_1/network/admin[oracle@node1admin]$catlistener.oraLIST

2、ENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1521))))[oracle@node1admin]$cattnsnames.oraORCL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))DG=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P

3、ROTOCOL=TCP)(HOST=node2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg)Oracle11gR2Dataguard配置手册))备库[oracle@node1admin]$catlistener.oraLISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521))))[oracle@node1admin]$cattnsnames.oraORCL=(DESCRIPTION=(AD

4、DRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))DG=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg)))4.主库前期准备设置强制写日志SQL>selectFORCE_LOGGINGfromv$database;NOSQL>alterdatabas

5、eforcelogging;SQL>selectFORCE_LOGGINGfromv$database;YESOracle11gR2Dataguard配置手册5.创建口令文件orapwdfile=$ORACLE_HOME/dbs/orapwdb1password=oracleentries=56.修改主库初始化参数创建主库pfilesql>createpfilefromspfile;修改pfileDB_UNIQUE_NAME=orclLOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,dg)'LOG_ARCHIVE_DEST_

6、1='LOCATION=/u01/app/archiveVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=orcl'LOG_ARCHIVE_DEST_2='SERVICE=dgLGWRASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=dg'LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_DEST_STATE_2=ENABLELOG_ARCHIVE_FORMAT=%t_%s_%r.arcFAL_

7、SERVER=dgFAL_CLIENT=orclSTANDBY_FILE_MANAGEMENT=AUTOPfile拷贝到备库上scp–rp/u01/app/product/11.2.0/db_1/dbs/initorcl.oranode2:/u01/app/product/11.2.0/db_1/dbs/7.修改数据库运行在归档模式下SHUTDOWNIMMEDIATE;STARTUPMOUNT;ALTERDATABASEARCHIVELOG;ALTERDATABASEOPEN;8.创建备份库需要的控制文件创建控制文件Shutdownimmedia

8、teSTARTUPMOUNT;ALTERDATABASECREATESTANDBYCONTROLFILEAS'/tmp/orcl.ctl