日韩无码专区无码一级三级片|91人人爱网站中日韩无码电影|厨房大战丰满熟妇|AV高清无码在线免费观看|另类AV日韩少妇熟女|中文日本大黄一级黄色片|色情在线视频免费|亚洲成人特黄a片|黄片wwwav色图欧美|欧亚乱色一区二区三区

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

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

準(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)建一個(gè)監(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)建一個(gè)監(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)建一個(gè)服務(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)建一個(gè)服務(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)建一個(gè)源連接，源連接的名稱可以自定義，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ī)熱備實(shí)現(xiàn)數(shù)據(jù)無縫保障
本文路徑：http://m.5511xx.com/article/dhsjppd.html