資源描述：
《最簡單的11g Active DataGuard(ADG)搭建配置過程(項目步驟)》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、[-]1.最簡單的11gActiveDataGuardADG搭建配置過程項目步驟1.一環(huán)境介紹2.二11gADG部署1.pri端和sty端配置靜態(tài)監(jiān)聽2.修改primary端初始化參數(shù)文件3.在primary端pfile參數(shù)文件和密碼文件并且拷貝到standby段相應(yīng)位置4.修改standby端的監(jiān)聽文件及初始化參數(shù)文件5.在primary端通過RmanDuplicate創(chuàng)建備庫在db01上執(zhí)行如下命令6.在primary和standby端添加standby日志7.在standby端開啟實時日志應(yīng)用3.三
2、開始測試ADG1.執(zhí)行日志切換測試在pri端切換歸檔在節(jié)點二上檢查是否也發(fā)生了切換2.查看standby啟動的DG進程3.查看數(shù)據(jù)庫的保護模式4.查看DG的日志信息5.OpenReadOnlystandby數(shù)據(jù)庫并且開啟實時日志應(yīng)用6.解鎖scott用戶添加數(shù)據(jù)驗證數(shù)據(jù)是否能同步4.四ADG三種模式切換及介紹1.ADG有三種PROTECTIONAVAILABILITYPERFORMANCE模式具體參考探索Oracle11gR2之DataGuard_03三種保護模式5.五切換測試1.ADG做switchov
3、er切換測試2.ADG做failover切換測試最簡單的11gActiveDataGuard(ADG)搭建配置過程（項目步驟）一、環(huán)境介紹:我在db01和db02兩臺Linux虛擬機上首先分別安裝了一套數(shù)據(jù)庫軟件，在db01主機上創(chuàng)建了名為woo的數(shù)據(jù)庫；我們這次的實驗是要搭建了一套Oracle11gActiveDataGuard；目的是為了實現(xiàn)數(shù)據(jù)庫同步的功能，并且了解Oracle11gDG的基本功能。db01:192.168.1.50db02:192.168.1.51二、11gADG部署：1、pri端
4、和sty端配置靜態(tài)監(jiān)聽[python]viewplaincopyprint?1.[oracle@styadmin]$catlistener.ora2.#listener.oraNetworkConfigurationFile:/DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/listener.ora3.#GeneratedbyOracleconfigurationtools.4.5.SID_LIST_LISTENER=6.(SID_LIST=7.(S
5、ID_DESC=8.(SID_NAME=PLSExtProc)9.(ORACLE_HOME=/DBSoft/oracle/product/11.2.4/dbhome_1)10.(PROGRAM=extproc)11.)12.(SID_DESC=13.(SID_NAME=Woo)14.(ORACLE_HOME=/DBSoft/oracle/product/11.2.4/dbhome_1)15.)16.)17.18.[oracle@styadmin]$cattnsname.ora19.#tnsnames.or
6、aNetworkConfigurationFile:/DBSoft/oracle/product/11.2.4/dbhome_1/network/admin/tnsnames.ora20.#GeneratedbyOracleconfigurationtools.21.22.STY=23.(DESCRIPTION=24.(ADDRESS_LIST=25.(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.51)(PORT=1521))26.)27.(CONNECT_DATA=28.
7、(SERVICE_NAME=woo)29.)30.)31.32.PRI=33.(DESCRIPTION=34.(ADDRESS_LIST=35.(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.50)(PORT=1521))36.)37.(CONNECT_DATA=38.(SERVICE_NAME=woo)39.)40.)2、修改primary端初始化參數(shù)文件[sql]viewplaincopyprint?1.startupmount;2.alterdatabasearchiv
8、elog;3.alterdatabaseforcelogging;4.alterdatabaseopen;5.altersystemsetlog_archive_config='DG_CONFIG=(pri,sty)'scope=spfile;6.altersystemsetlog_archive_dest_1='LOCATION=/DBBackup/ArchiveVALID_FOR=(ALL_LOGFILES,ALL_ROL
