資源描述:
《ORACLE LINUX 11G RAC 單實(shí)例DATAGUARD》由會(huì)員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、ORACLELINUX11GRAC單實(shí)例DATAGUARD環(huán)境說明:源庫:雙節(jié)點(diǎn)RAC:CPU:12MEM:8G操作系統(tǒng):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目標(biāo)庫:?jiǎn)螌?shí)例CPU:4MEM:6G操作系統(tǒng):Linux2.6.18-194.el510.135.161.241DB_NAME=oemdb_unique_name=dgtest安裝步驟一、源庫設(shè)置強(qiáng)制歸檔:二、源庫設(shè)置參數(shù),設(shè)置完畢后參數(shù)如下所示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執(zhí)行如下命令設(shè)置: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='*';一、重啟源庫,設(shè)置為歸檔模式。srvctlstopdatabase–doem–oimmed
8、iate;srvctlstartdatabase–doem注:重啟11grac2報(bào)錯(cuò):srvctlstopdatabase–doem–oimmediate;srvctlstartdatabase–doem+ASM2ORA-00600:internalerrorcode,arguments:[spstp:ORACLE_