ORACLE LINUX 11G RAC 单实例DATAGUARD

《ORACLE LINUX 11G RAC 单实例DATAGUARD》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、ORACLELINUX11GRAC单实例DATAGUARD环境说明：源库：双节点RAC:CPU:12MEM:8G操作系统：Linux2.6.18-194.el510.135.33.17011grac1.fawcar.com.cn11grac110.135.33.17111grac2.fawcar.com.cn11grac210.135.33.17211grac1-vip.fawcar.com.cn11grac1-vip10.135.33.17311grac2-vip.fawcar.com.cn11grac2-vipDB_

2、NAME=oemdb_unique_Name=oemDATAGUARD目标库：单实例CPU:4MEM:6G操作系统：Linux2.6.18-194.el510.135.161.241DB_NAME=oemdb_unique_name=dgtest安装步骤一、源库设置强制归档：二、源库设置参数，设置完毕后参数如下所示DB_NAME=oemDB_UNIQUE_NAME=oemLOG_ARCHIVE_CONFIG='DG_CONFIG=(oem,oem_dg)'LOG_ARCHIVE_DEST_1='LOCATION=/dbf

3、s_backup/oemVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=oem'LOG_ARCHIVE_DEST_2='SERVICE=oem_dgLGWRAFFIRMVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=oem_dg'LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_DEST_STATE_2=ENABLEREMOTE_LOGIN_PASSWORDFILE=EXCL

4、USIVELOG_ARCHIVE_FORMAT=%t_%s_%r.arcLOG_ARCHIVE_MAX_PROCESSES=4FAL_SERVER=oem_dgDB_FILE_NAME_CONVERT='/oradata/oem_dg/datafile/','+DATA/oem/datafile/'LOG_FILE_NAME_CONVERT='/oradata/oem_dg/','+DATA/oem/STANDBY_FILE_MANAGEMENT=AUTO执行如下命令设置：altersystemsetLOG_ARCHIV

5、E_CONFIG='DG_CONFIG=(oem,oem_dg)'scope=bothsid='*';altersystemsetLOG_ARCHIVE_DEST_1='LOCATION=/dbfs_backup/oemVALID_FOR=(ALL_LOGFILES,ALL_ROLES)DB_UNIQUE_NAME=oem'scope=bothsid='*';altersystemsetLOG_ARCHIVE_DEST_2='SERVICE=oem_dgLGWRAFFIRMVALID_FOR=(ONLINE_LOGFIL

6、ES,PRIMARY_ROLE)DB_UNIQUE_NAME=oem_dg'scope=bothsid='*';altersystemsetlog_archive_format='%t_%s_%r.arc'scope=spfilesid='*';altersystemsetlog_archive_max_processes=4scope=bothsid='*';altersystemsetfal_server=oem_dgscope=bothsid='*';altersystemsetDB_FILE_NAME_CONVE

7、RT='/oradata/oem_dg/datafile/','+DATA/oem/datafile/'scope=spfilesid='*';altersystemsetLOG_FILE_NAME_CONVERT='/oradata/oem_dg/,'+DATA/oem/'scope=spfilesid='*';altersystemsetstandby_file_management=AUTOscope=bothsid='*';一、重启源库，设置为归档模式。srvctlstopdatabase–doem–oimmed

8、iate;srvctlstartdatabase–doem注：重启11grac2报错：srvctlstopdatabase–doem–oimmediate;srvctlstartdatabase–doem+ASM2ORA-00600:internalerrorcode,arguments:[spstp:ORACLE_