ORACLE12C_DG配置主庫:orcl備庫:orclbk 1、/etc/hosts配置 172.16.140.3 node1172.16.140.4 node2 2、主庫force logging
背景:Oracle12.2搭建ADG,在主庫創(chuàng)建pdb時發(fā)現(xiàn)備庫告警ora-600。DBCA刪除主庫的pdb后,備庫pdb沒有自動刪除,故手動刪除備庫的pdb備庫:[oracle@master2 ~]
發(fā)現(xiàn)數(shù)據(jù)庫告警,查看alert日志,發(fā)現(xiàn)如下報錯Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_lgwr_26383.
環(huán)境介紹:windows 2012 R2*2臺主庫:安裝oracle軟件、監(jiān)聽、實(shí)例備庫:安裝oracle軟件、監(jiān)聽數(shù)據(jù)庫版本:11.2.0.4主庫:orcl備庫:prod 1、主庫create pf
11g ADG 環(huán)境必須要配置的靜態(tài)監(jiān)聽,復(fù)制粘貼,簡單修改就可以 SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_
Oracle ADG vs DG其實(shí)ADG的實(shí)驗自己早已做過,就是不知道是DG的升級版而已。ADG: Active Data GuardDG: Data GuardWhat is the differ