您好,登錄后才能下訂單哦!
一、環(huán)境描述
12C RAC + DATAGUARD+ Broker
二、修改歸檔日志路徑
以下為模擬生產(chǎn)環(huán)境,方法是相同的。
--主庫(kù)RAC
1、Oracle用戶執(zhí)行,先修改主庫(kù)參數(shù)文件
sqlplus / as sysdba
alter system set log_archive_dest_1='LOCATION=+datadg/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl';
2、Oracle用戶執(zhí)行,修改broker配置參數(shù)
DGMGRL> edit instance orcl1 on database orcl set property StandbyArchiveLocation='+datadg/arch';
DGMGRL> edit instance orcl2 on database orcl set property StandbyArchiveLocation='+datadg/arch';
--備庫(kù)單實(shí)例
1、Oracle用戶,再修改備庫(kù)
sqlplus / as sysdba
alter system set log_archive_dest_1='LOCATION=++datadg/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcldg';
2、Oracle用戶執(zhí)行,修改broker配置參數(shù)
DGMGRL> edit database orcldg set property StandbyArchiveLocation='+datadg/arch';
三、遇到的報(bào)錯(cuò)
報(bào)錯(cuò)1:
OERR: ORA-16582 "cannot change instance-specific property" (varies by version) Reference Note (文檔 ID 172958.1)
Error Text, Cause and Action from Message File/s for ORA-16582
Versions 11.1, 11.2, 12.1
Error: ORA-16582 cannot change instance-specific property
Cause: An attempt was made to change an instance-specific property for a
database that had more than one instance.
Action: Retry the command and identify a specific instance whose property
value is to be changed.
解決方法:RAC環(huán)境下修改歸檔路徑使用edit instance xxx ,不要使用edit database
報(bào)錯(cuò)2:
Warning: ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
Warning: ORA-16714: the value of property AlternateLocation is inconsistent with the database setting
解決方法:同時(shí)修改broker配置。
四、小結(jié):
1、RAC+DG+Broker 這樣的環(huán)境需要注意部分參數(shù)需要再數(shù)據(jù)庫(kù)中修改同時(shí)需要再broker里修改。
2、遇到問題不要緊,我們不可能什么問題都遇到,關(guān)鍵在于培養(yǎng)自己解決問題的能力。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。