Shulou(Shulou.com)06/01 Report--

Comparison of DG and ADG:

DG can only use Real-Time Apply

What is real-Time Apply? first take a look at the application of master and slave database logs.

Explanation:

The default slave library only applies MRP logs to archived redo log. Enable real-Time Apply (real-time application), and the slave library can apply logs to standby redolog.

You need to prepare the library to create a standby redolog.

Let's take a look at ADG,ADG 's main applications in real-time Oracle data protection, availability and disaster recovery.

.

Although many people look confused at English, they still show English to their families in order to restore the most original explanation.

Data Guard Architecture Overview

Data Guard provides the management, monitoring, and automation software to create and maintain one or more synchronized copies of a production database to protect Oracle data from failures, disasters, human error, and data corruptions while providing high availability for mission critical applications. Data Guard is included with Oracle Database Enterprise Edition.

Active Data Guard Functionality

Active Data Guard is an option license for Oracle Database Enterprise Edition. Active Data Guard enables advanced capabilities that that extend basic Data Guard functionality. These include:

Real-Time Query-offload read-only workloads to an up-to-date standby database

Automatic Block Repair-automatic repair of physical corruption transparent to the user

Far Sync-zero data loss protection across any distance

Standby Block Change Tracking-enable incremental backups on an active standby

Active Data Guard Rolling Upgrade-make it simple to reduce planned downtime

Global Database Services-load balancing and service management across replicated databases. See Global Data Services

Application Continuity-make outages transparent to users. See Application Continuity

The translation is as follows:

Overview of Data Guard architecture

Data Guard provides management, monitoring and automation software to create and maintain one or more synchronous copies of production databases to protect Oracle data from failures, disasters, human errors and data corruption, while providing high availability for mission-critical applications. Data Guard is included in Oracle Database Enterprise Edition.

Active data protection function

Active Data Guard is an option license for Oracle Database Enterprise Edition. Active Data Guard supports advanced features that extend basic Data Guard functionality. These include:

Real-time query-responsible for refreshing the latest data from the main database to the physical backup database

Automatic block repair-automatic repair repairs bad data blocks

Remote synchronization-active and standby synchronization in any case to achieve zero data loss protection.

Enable block tracking in slave database-enable incremental backup on standby database by enabling block tracking in standby database.

Active Data Guard rolling upgrade-simplifies planned downtime

Global database service-load balancing and service management across replicated databases. Please refer to Global data Services

Application continuity-makes interrupts transparent to users. Please refer to the application continuity, which I am also confused about. The official document explains as follows:

Application continuity

Application continuity (AC) is a feature of the Oracle Real Application Clusters (RAC), Oracle RAC One Node and Oracle Active Data Guard options that shield end users and applications from interruptions by resuming ongoing database sessions after recoverable interruptions. Application continuity shields end users and applications from interruptions by resuming the ongoing work of the affected database session after the interruption. Application continuity performs this recovery under the application to interrupt execution that appears to be slightly delayed in the application.

Application continuity is used to improve the user experience when dealing with unexpected interruptions and planned maintenance. Application continuity enhances the fault tolerance of systems and applications that use Oracle databases.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.