oracle_11g_dataguard配置

《oracle_11g_dataguard配置》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oracle11gR2Dataguard配置手册目录1．判断DataGuard是否安装22.网络配置23.监听配置24.主库前期准备45.创建口令文件46.修改主库初始化参数47.修改数据库运行在归档模式下48.创建备份库需要的控制文件59.备份生产数据库510.修改备库pfile511.将控制文件612.在备库上创建口令文件613.在备库上创建spfile614.启动物理备用数据库615．配置StandbyRedoLog616.StartRedoApply6Oracle11gR2Dataguard配置手册1．判断DataGuar

2、d是否安装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.oraLISTENER=(DESCRIPTION_LIST=(DESC

3、RIPTION=(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=(PROTOCOL=TCP)(HOST=no

4、de2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dg)))备库[oracle@node1admin]$catlistener.oraOracle11gR2Dataguard配置手册LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1521))))[oracle@node1admin]$cattnsnames.oraORCL=(DESCRIPTION=(ADDRESS_LIST=(

5、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>alterdatabasefor

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

7、EST_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_%

8、s_%r.arcFAL_SERVER=dgFAL_CLIENT=orclSTANDBY_FILE_MANAGEMENT=AUTOPfile拷贝到备库上scp–rp/u01/app/product/11.2.0/db_1/dbs/initorcl.o