Oracle 8i雙機(jī)熱備是一種高可用性解決方案，它可以確保在一臺服務(wù)器出現(xiàn)故障時，另一臺服務(wù)器能夠立即接管工作，從而保證數(shù)據(jù)的安全性和系統(tǒng)的連續(xù)性，本文將詳細(xì)介紹如何實現(xiàn)Oracle 8i雙機(jī)熱備。

網(wǎng)站建設(shè)哪家好，找成都創(chuàng)新互聯(lián)公司！專注于網(wǎng)頁設(shè)計、網(wǎng)站建設(shè)、微信開發(fā)、小程序開發(fā)、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了海拉爾免費建站歡迎大家使用！

準(zhǔn)備工作

1、確保兩臺服務(wù)器的硬件配置相同，包括CPU、內(nèi)存、硬盤等。

2、在兩臺服務(wù)器上安裝Oracle 8i數(shù)據(jù)庫軟件，并設(shè)置相同的數(shù)據(jù)庫參數(shù)。

3、在兩臺服務(wù)器上創(chuàng)建相同的表空間、用戶、數(shù)據(jù)文件等。

4、在兩臺服務(wù)器上配置相同的網(wǎng)絡(luò)環(huán)境，包括IP地址、子網(wǎng)掩碼、網(wǎng)關(guān)等。

5、在兩臺服務(wù)器上安裝Oracle GoldenGate軟件，用于數(shù)據(jù)同步。

配置Oracle 8i雙機(jī)熱備

1、在主服務(wù)器上創(chuàng)建一個監(jiān)聽器，監(jiān)聽器的名稱可以自定義，listener_master，編輯listener.ora文件，添加以下內(nèi)容：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 主服務(wù)器IP地址)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

2、在備服務(wù)器上創(chuàng)建一個監(jiān)聽器，監(jiān)聽器的名稱可以自定義，listener_standby，編輯listener.ora文件，添加以下內(nèi)容：

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 備服務(wù)器IP地址)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

3、在主服務(wù)器上創(chuàng)建一個服務(wù)名，服務(wù)名可以自定義，orcl_service，編輯tnsnames.ora文件，添加以下內(nèi)容：

ORCL_SERVICE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 主服務(wù)器IP地址)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl_service)
    )
  )

4、在備服務(wù)器上創(chuàng)建一個服務(wù)名，服務(wù)名可以自定義，orcl_service，編輯tnsnames.ora文件，添加以下內(nèi)容：

ORCL_SERVICE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 備服務(wù)器IP地址)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl_service)
    )
  )

配置數(shù)據(jù)同步

1、在主服務(wù)器上創(chuàng)建一個源連接，源連接的名稱可以自定義，source_goldengate，編輯initsid.ora文件，添加以下內(nèi)容：

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雙機(jī)熱備實現(xiàn)數(shù)據(jù)無縫保障
文章地址：http://uogjgqi.cn/article/dhsjppd.html