建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
熱備Oracle8i雙機熱備實現(xiàn)數(shù)據(jù)無縫保障
Oracle 8i雙機熱備是一種高可用性解決方案，它可以確保在一臺服務器出現(xiàn)故障時，另一臺服務器能夠立即接管工作，從而保證數(shù)據(jù)的安全性和系統(tǒng)的連續(xù)性，本文將詳細介紹如何實現(xiàn)Oracle 8i雙機熱備。
網(wǎng)站建設哪家好，找成都創(chuàng)新互聯(lián)公司！專注于網(wǎng)頁設計、網(wǎng)站建設、微信開發(fā)、小程序開發(fā)、集團企業(yè)網(wǎng)站建設等服務項目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了海拉爾免費建站歡迎大家使用！
準備工作
1、確保兩臺服務器的硬件配置相同，包括CPU、內存、硬盤等。
2、在兩臺服務器上安裝Oracle 8i數(shù)據(jù)庫軟件，并設置相同的數(shù)據(jù)庫參數(shù)。
3、在兩臺服務器上創(chuàng)建相同的表空間、用戶、數(shù)據(jù)文件等。
4、在兩臺服務器上配置相同的網(wǎng)絡環(huán)境，包括IP地址、子網(wǎng)掩碼、網(wǎng)關等。
5、在兩臺服務器上安裝Oracle GoldenGate軟件，用于數(shù)據(jù)同步。
配置Oracle 8i雙機熱備
1、在主服務器上創(chuàng)建一個監(jiān)聽器，監(jiān)聽器的名稱可以自定義，listener_master，編輯listener.ora文件，添加以下內容：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主服務器IP地址)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
2、在備服務器上創(chuàng)建一個監(jiān)聽器，監(jiān)聽器的名稱可以自定義，listener_standby，編輯listener.ora文件，添加以下內容：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 備服務器IP地址)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
3、在主服務器上創(chuàng)建一個服務名，服務名可以自定義，orcl_service，編輯tnsnames.ora文件，添加以下內容：
ORCL_SERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 主服務器IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl_service)
)
)
4、在備服務器上創(chuàng)建一個服務名，服務名可以自定義，orcl_service，編輯tnsnames.ora文件，添加以下內容：
ORCL_SERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 備服務器IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl_service)
)
)
配置數(shù)據(jù)同步
1、在主服務器上創(chuàng)建一個源連接，源連接的名稱可以自定義，source_goldengate，編輯initsid.ora文件，添加以下內容：
SOURCE_GOLDENGATE = source_goldengate USERID=dba FAILOVER=ON ALLOWTIMEOUT=60 SECONDS RETRYCOUNT=300 CONNECTTIMEOUT=60 SECONDS TARGET=orcl_service MESSAGES='DISCARD ALL' AUXILIARY=OFF PROPAGATEERRORS=OFF ISSUERCOMPLETEOK=ON SUPPRESSSQLWARNINGS=OFF XIDVALIDATION=OFF ENCRYPTDATA=OFF ENCRYPTOPTIONS='XEXTERNAL' DDLCOLLECTION=FALSE DMLCOLLECTION=TRUE LOGDIRECT=OFF OPERATION=TABLE OPERAND=(all tables with read access) TRACEFILEGROUP='/u01/app/oracle/diag/rdbms/orcl/orcl/trace' MIRRORINGMODE=ENABLE PRIMARYROLE=PRIMARY SECONDARYROLE=SECONDARY FILTERVALIDATION=FALSE FILTERINVALIDATIONACTION=IGNORE INVALIDATIONACTION=IGNORE INCLUDENULLVALUESRELATIONSHIPS=FALSE INCLUDEBLANKVALUESRELATIONSHIPS=FALSE INCLUDEFIELDVALUESRELATIONSHIPS=FALSE INCLUDEGLOBVALUESRELATIONSHIPS=FALSE INCLUDESCHEMANAMESRELATIONSHIPS=FALSE INCLUDESCHEMAOWNERSRELATIONSHIPS=FALSE INCLUDEDDLLSCHEMASRELATIONSHIPS=FALSE INCLUDEDTABLESPACESRELATIONSHIPS=FALSE INCLUDEDTABLESPACEOWNERSRELATIONSHIPS=FALSE INCLUDEDEFAULTVALUESRELATIONSHIPS=FALSE INCLUDECOMMENTSRELATIONSHIPS=FALSE INCLUDEINDEXEDCOLUMNSTORELATIONSHIPS=FALSE INCLUDEINDEXEDCOLUMNSTOREOWNERSRELATIONSHIPS=FALSE INCLUDEINDEXEDCOLUMNSTORETABLESPACESRELATIONSHIPS=FALSE INCLUDEINDEXEDCOLUMNSTORETABLESPACEOWNERSRELATIONSHIPS=FALSE INCLUDEPARTITIONINFORREPLICATION=TRUE INCLUDEPARTITIONKEYINFORREPLICATION=TRUE INCLUDEPARTITIONSTATISTICSFORREPLICATION=TRUE INCLUDEPARTITIONSUBPARTITIONINFORREPLICATION=TRUE INCLUDEPARTITIONSUBPARTITIONKEYINFORREPLICATION=TRUE INCLUDEPARTITIONSUBPARTITIONSTATISTICSFORREPLICATION=TRUE INCLUDEALLROWSINVALIDATION=TRUE INCLUDEALLROWSONTHEPRIMARYINVALIDATION=TRUE INCLUDEALLROWSONTHESECONDARYINVALIDATION=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATION=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHUPDATES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHMERGEUPDATES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHMERGEDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHMERGEINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDMERGEUPDATES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDMERGEDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDMERGEINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDMERGEUPDATES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDMERGEDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDMERGEINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDAPPENDDELETES=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESANDAPPENDINSERTS=TRUE INCLUDEALLROWSONTHEPRIMARYANDSECONDARYINVALIDATIONWITHAPPENDUPDATESAND
分享標題：熱備Oracle8i雙機熱備實現(xiàn)數(shù)據(jù)無縫保障
轉載源于：http://www.dlmjj.cn/article/dhsjppd.html
