oracle data guard英文.ppt

Oracle Data Guard Introduction Benefit of Data Guard High Availability Data Protection Disaster Recovery Data Guard Example Primary Database Production Database The Database That Most Application Connect to. Single Instance or Real Application Cluster. Standby Database Transactionally Consistent Copy of Primary Database Initially Backup Copy of Primary Database Single Instance or Real Application Cluster Physical Standby Database and Logical Standby Database Data Guard Service Log Transport Service Automated Transfer of Redo LogControl Data Protection Level Log Apply ServiceApply Redo to Physical Standby DatabaseApply SQL to Logical Standby Database Role Management ServiceControl the Shift of Primary and Standby Data Protection Mode Maximum ProtectionTransaction committed until redo data is available at least one standby database Maximum AvailabilityRedo data transferred synchronously as possiblePrimary database does not wait if standby failure Maximum PerformanceRedo data transferred asynchronously, Primary database does not wait if standby failure Oracle Data Guard Getting Started Standby Database Type Physical Standby DatabaseManaged Recovery ModeOpen in Read Only Mode Logical Standby DatabaseOpen in normal mode Combination of Physical and Logical Benefit of Physical Standby Disaster Recovery and High Availability Data Protection Reduce Workload from Primary DatabaseBackup can take from Physical StandbyReport can be made in Read Only Mode PerformanceLow level recovery mechanism offer better performance Benefit of Logical Standby Disaster Recovery and High Availability Data Protection Efficient use of Hardware ResourceCan be used for other purpose Reduce Primary Database Workloadfor Query, Summation and Report activity Data Guard User Interface SQL * PLUS and Initialize Parameter File Data Guard Broken Command Line Oracle Data Guard Manager Data Guard Prerequisites Primary Database in Archivelog Mode Same Edition and Release of Oracle Same Hardw