Oracle ADG vs DG

創新互聯建站專業為企業提供瀘溪網站建設、瀘溪做網站、瀘溪網站設計、瀘溪網站制作等企業網站建設、網頁設計與制作、瀘溪企業網站模板建站服務，10余年瀘溪做網站經驗，不只是建網站，更提供有價值的思路和整體網絡服務。

其實ADG的實驗自己早已做過，就是不知道是DG的升級版而已。

ADG: Active Data Guard

DG: Data Guard

What is the difference between DG and ADG ? 

From the docs: 
Oracle Data Guard ensures high availability, dataprotection, and disaster recovery for enterprise data. Oracle Data Guardprovides a comprehensive set of services that create, maintain, manage, andmonitor one or more standby databases to enable production Oracle databases tosurvive disasters and data corruptions. Oracle Data Guard maintains thesestandby databases as copies of the production database. Then, if the productiondatabase becomes unavailable because of a planned or an unplanned outage, OracleData Guard can switch any standby database to the production role, minimizingthe downtime associated with the outage. Oracle Data Guard can be used withtraditional backup, restoration, and cluster techniques to provide a high levelof data protection and data availability. 
Oracle dg保證高可用性、數據保護、企業數據的災難恢復。Oracle dg提供一系列的綜合性服務，如一個或多個備庫的創建、維護、管理和監控，使得生產庫從災難、數據崩潰中得以恢復。Oracle dg維護這些備庫作為生產庫的副本。如果生產庫因計劃或非計劃的中斷，dg可切換任何一個備庫當人生產庫的角色，最小化因中斷造成的宕機時間。DG也可用作傳統的備份、恢復、提供數據高可用和保護的集群技術。
So both DG and ADG provide those additional copiesof the database. Early DG versions provided that facility solely for disasterrecovery. Nowadays, there are many other things you can use DG for, eg, youcould backup the DG copy rather than the production database to ease resourceconsumption etc. 
因此DG和ADG都提供數據庫的附加復制。早期版本的DG只提供數據的災難恢復。現在你通過DG有很多其他的東西可以使用，如你可備份DG庫而不是生產庫來達到降低資源消耗的目的。
Where ADG offers more is that you can have thedatabase open for read-only (eg reports) whilst it is still being kept in syncwith your primary database. With normal DG, if you want it open read-only, youmust pause the sync process. 

ADG能提供更多的就是你能使DG庫以只讀狀態打開，同時DG庫保持和主庫的同步。對于普通的DG，你以只讀形式打開DG庫，必須暫停同步進程。

What is the difference betweenADG and GoldenGate ? 

ADG maintains a physical copy of yourprimary database (that can be read by queries). You are100% positive that it and the primary are the same.

 

Goldengate replicates *changes* from yourprimary database to a secondary but quite separate copy of your database. This second copy might be a subset, or superset, or simply bedivergent from your primary. The advantage is that this secondarydatabase can be read-write...its really a *different* database into whichchanges are being pushed.

新聞標題：OracleADGvsDG
轉載注明：http://www.yijiale78.com/article34/ghdope.html

成都網站建設公司_創新互聯，為您提供網站收錄、網站排名、網站制作、外貿建站、網站導航、網站策劃

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯