PIXNET Logo登入

DanBrother的部落格

跳到主文

歡迎光臨DanBrother在痞客邦的小天地. 部落格文章同步於=> http://blog.xuite.net/gem083/dba

部落格全站分類:數位生活

  • 相簿
  • 部落格
  • 留言
  • 名片
  • 6月 24 週二 201414:19
  • Oracle Data Guard Protection Modes

Oracle Data Guard provides three protection modes including
Maximum Protection,
Maximum Availability
, and
Maximum Performance modes.
(1) Maximum Protection Mode:

It provides the highest level of data protection which means zero (no) data lost will occur.
However, if connection to the standby database is lost, primary database might incur some downtime.
It requires online redo logs to be written and the SYNC redo transport  mode to be set on at least one standby database.
Oracle recommends that a minimum of two standby databases be used to protect a primary database that runs in this mode to prevent a single standby
database failure from causing the primary database to shut down.
Required Redo Transport Attributes:
a. AFFIRM
b. SYNC  
c. DB_UNIQUE_NAME
(2) Maximum Availability Mode:

It provides very high degree of data protection without compromising the availability of a primary database.
Transactions will not commit until all transaction data has been written to online redo logs and at least one standby database is synchronized within the maximum of NET_TIMEOUT seconds.
Required Redo Transport Attributes:
a. AFFIRM
b. SYNC   
c. DB_UNIQUE_NAME

(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(43)

  • 個人分類:Oracle Data Guard
▲top
  • 9月 27 週五 201312:21
  • Oracle 11gR2 Data Guard & Broker Configuration

Oracle 11gR2 Data Guard Configuration
 
【Prerequisite】
(繼續閱讀...)
文章標籤

DanBrother 發表在 痞客邦 留言(0) 人氣(217)

  • 個人分類:Oracle Data Guard
▲top
1

廣告

個人資訊

DanBrother
暱稱:
DanBrother
分類:
數位生活
好友:
累積中
地區:

熱門文章

  • (58,073)祝福禱告文-為工作祝福
  • (49,259)Excel 2007 中文字顯示亂碼之修復步驟
  • (2,928)ORA-24247: 存取控制清單 (ACL) 拒絕網路存取
  • (626)OSQL公用程式的使用方法
  • (136)crsctl command usage
  • (84)Oracle 11.2.0.3 Grid Infrastructure ora.diskmon shows OFFLINE
  • (59)Reload multipath.conf
  • (15)DB_FILE_MULTIBLOCK_READ_COUNT
  • (6)SQL Server 2005 Reporting Services Permission Settings for Viewing Reports
  • (5)RPM & SRPM

文章分類

  • Android (1)
  • Java (1)
  • MongoDB (1)
  • MariaDB (7)
  • Python (10)
  • HTML (1)
  • ORDS (1)
  • Apache Tomcat (1)
  • Oracle Streams (1)
  • Javascript (1)
  • Oracle Data Guard (2)
  • Oracle VirtualBox (3)
  • Grid Infrastructure (4)
  • Oracle SQL Tuning (6)
  • OEM11g / 12c (28)
  • IT Links (1)
  • 心靈饗宴 (161)
  • Oracle Clusterware (5)
  • ORACLE RAC (21)
  • Oracle ASM (18)
  • Oracle Export/Import (10)
  • MySQL (22)
  • Windows Series (18)
  • Oracle HTTP Server (8)
  • Linux (49)
  • Microsoft Office (6)
  • SQL SERVER (19)
  • Install Apache & PHP (2)
  • Oracle in General (111)
  • RMAN (15)
  • SQL / PL/SQL (30)
  • 未分類文章 (1)

最新文章

  • MySQL Array Simulation in Stored Procedure
  • Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)
  • MySQL Stored Procedure - Nested Loop Example
  • Metabase H2 DB Migration to MySQL 5.7
  • Steps for Upgrading Percona-Toolkit to the Latest Version
  • MySQL Slave - Skip Replication for A Particular Table
  • MySQL - Export & Import Table Data Based on the SQL Query
  • MySQL Table Fragmentation Detection and De-fragmentation Implementation
  • Multiple Log File Viewer (Linux Bash)
  • Solving MySQL slave lag Issues

最新留言

  • [21/08/16] jwang0189 於文章「祝福禱告文-為工作祝福...」留言:
    非常實用的文章,謝謝提供,已點廣告表示支持 https://...
  • [20/04/23] 廣利 於文章「祝福禱告文-為工作祝福...」留言:
    129:8 過路的也不說,願耶和華所賜的福,歸於你們;我們在...
  • [17/10/30] 66國語言翻譯公司 於文章「Download Google Chro...」留言:
    不了走會點中見你隻有果新家而去十走相隻把見作樣 95國...
  • [17/05/06] 50國語言翻譯公司 於文章「Python >>> a, b = b...」留言:
    之的不會然文道果三那大這年來來年物月用理學, 115國...
  • [16/10/13] KK 於文章「How to Change Defaul...」留言:
    感謝您分享的工作禱詞! 真的太感謝了!! 願 平安...
  • [15/08/23] 洪秀柱 於文章「如何在UltraEdit中正常顯示韓文?...」留言:
    此破解法可用於 UEstudio UltraEdit V2...

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣

  • 本日人氣:
  • 累積人氣:

留言板