book

Oracle Data Guard 11g Handbook

by Larry Carpenter, Joseph Meeks, Charles Kim, Bill Burke, Sonya Carothers, Joydip Kundu, Michael Smith, Nitin Vengurlekar

July 2009

Intermediate to advanced

544 pages

19h 15m

English

McGraw Hill Computing

Read now

Unlock full access

Data Guard OverviewWhat Is Redo?Redo Transport ServicesSynchronous Redo TransportAsynchronous Redo TransportRedo Transport CompressionAutomatic Gap ResolutionApply ServicesRedo Apply (Physical Standby)SQL Apply (Logical Standby)Can’t Decide? Then Use Both!Data Guard Protection ModesMaximum PerformanceMaximum AvailabilityMaximum ProtectionRole Management ServicesSwitchoverFailoverData Guard ManagementActive Standby DatabasesOffload Read-Only Queries and ReportingOffload BackupsTestingData Guard and the Maximum Availability ArchitectureConclusion
Plan Before You ImplementDetermining Your RequirementsUnderstanding the Configuration OptionsRelating the RPO and RTO to the Protection ModeCreating a Physical Standby DatabaseChoosing Your InterfaceBefore You StartUsing Oracle Enterprise Manager Grid ControlThe Power User MethodCreating a Logical StandbyData Guard and Oracle Real Application ClustersConclusion
Important Concepts of Oracle RecoveryACID PropertiesOracle RecoveryLife of a TransactionNologging OperationsThe Components of a Physical StandbyReal-time ApplyScaling and Tuning Data Guard Apply RecoveryParallel Media RecoveryTools and Views for Monitoring Physical Standby RecoveryPhysical Standby Corruption Detection11g New Data Protection ChangesData Protection and Checking on a Physical StandbyConclusion

Characterizing the Dataset Available at the Logical StandbyCharacterizing the Dataset Replicated from the Primary DatabaseProtecting Replicated Tables on a Logical StandbyCustomizing Your Logical Standby Database (or Creating a Local Dataset at the Logical Standby)Understanding the Operational Aspects of a Logical StandbyLooking Inside SQL ApplyTuning SQL ApplySome Rules of ThumbDetermining Whether SQL Apply Is LaggingDetermining Whether SQL Apply Is the BottleneckDetermining Which SQL Apply Component Is the BottleneckTroubleshooting SQL ApplyUnderstanding Restarts in SQL ApplyTroubleshooting Stopped SQL ApplyConclusion
Overview of the Data Guard BrokerThe Broker Process ModelThe Broker Process FlowThe Broker Configuration FilesThe Broker CLIGetting Started with the BrokerConfiguring the Broker ParametersThe Broker and Oracle Net ServicesRAC and the BrokerConnecting to the BrokerManaging Data Guard with the BrokerCreating and Enabling a Broker ConfigurationChanging the Broker Configuration PropertiesChanging the State of a DatabaseChanging the Protection ModeMonitoring Data Guard Using the BrokerRemoving the BrokerConclusion
Accessing the Data Guard FeaturesConfiguring Data Guard Broker with OEM Grid ControlVerify Configuration and Adding Standby Redo LogsViewing MetricsModifying MetricsViewing the Alert Log FileEnabling Flashback DatabaseReviewing PerformanceChanging Protection ModesEditing Standby Database PropertiesPerforming a SwitchoverPerforming a Manual FailoverFast-Start FailoverCreating a Logical StandbyManaging Active StandbyManaging Snapshot StandbyRemoving a Standby Database from Broker ControlKeeping an Eye on AvailabilityConclusion
Monitoring the Data Guard EnvironmentMining the Alert Log File (PS+LS)Gathering Statistical Information from Archive Log History (PS+LS)Detecting Archive Log Gaps (PS+LS)Identifying Delays in Redo Transport (PS)Monitoring Archive Log Destinations (PS+LS)Examining Apply Rate and Active Rate (PS)Reviewing Transport and Apply Lag (PS+LS)Determining the Current Time on the Standby Database (PS)Reporting the Status of Managed Recovery Process (PS)Data Guard Menu UtilityReviewing the Current Data Guard EnvironmentChecking the Password File (PS+LS)Checking for Nologging Activities (PS+LS)Looking at Archivelog Mode and Destinations (PS+LS)Checking Standby File Management (PS)Revealing Errors in the Data Guard Status View (PS)Logical Standby Data Guard MenuConclusion
Introduction to Role TransitionSwitchoverFailoverSwitchover vs. FailoverFlashback Technologies and Data GuardPerforming a SwitchoverConfiguration Completeness CheckPreparatory ChecksPreprocessing StepsSwitching over to a Physical StandbySwitching over to a Logical StandbyUsing the Broker or Grid Control to SwitchoverSwitchover Health CheckPerforming a FailoverFailing over to a Physical StandbyFailing over to a Logical StandbyBringing Back the Old PrimaryUsing the Broker or Grid Control to FailoverAutomatic FailoverA Final Word on Multiple StandbysConclusion
Physical Standby—Open Read-OnlyWhy Read-Only?The Downside of Read-Only or Read-Write ModeSnapshot Standby for QA and Test EnvironmentsRead Write Standby in Oracle Database 10gSnapshot Standbys in Oracle Database 11gReal Application TestingDatabase ReplaySQL Performance AnalyzerActive Data GuardConfiguring Active Data GuardConclusion
Defining the ProblemComplete Site FailoverPartial Site FailoverThe Nitty GrittyConnection Load Balancing and Connect Time FailoverOutbound Connect TimeoutTransparent Application FailoverFast Application NotificationThe DB_ROLE_CHANGE System EventImplementing Client FailoverComplete Site Failover ConfigurationConclusion
Overview of Planned MigrationLeveraging Data Guard Switchover for Planned MigrationCase 1–New Data CenterCase 2–Move to ASMPerforming a Database Rolling Upgrade Using Data GuardLeveraging Rolling Upgrades Using SQL ApplyRolling Upgrades Using Transient Logical StandbyConclusion
RMAN BasicsRMAN Integration with Data GuardBlock Change Tracking SupportControl File ManagementResynchronizing the RMAN CatalogRMAN Configuration in Data GuardExample Configuration for a Primary DatabaseExample Configuration for a Backup Standby DatabaseExample Configuration for Other Physical Standby DatabasesBackup StrategiesBackup ScenariosBackup Database Not Backed UpFull Backups on PrimaryBackup as CopyImage Copy Rolled ForwardStandby Database CreationBackups on a Standby DatabaseArchive BackupsGeneral Recovery StrategiesMedia FailureBlock CorruptionUser ErrorsRecovery ScenariosLoss of a Datafile on a Primary DatabaseLoss of a Datafile on a Standby DatabaseLoss of Standby ControlfileLoss of Primary ControlfileLoss of an Online Redo Log FileIncomplete Recovery of the Primary DatabaseRecovering from a Dropped TableRecover a Missing Datafile from a Backup Taken on the StandbyGeneral Best PracticesConclusion
Diagnostic InformationDatabase Alert LogsObserver Log FilesData Guard Trace FilesData Guard Broker Log Files and ToolsDynamic Performance ViewsData Guard Configuration and Management ErrorsCommon Management IssuesPhysical Standby IssuesLogical Standby Database FailuresSwitchover IssuesFailover IssuesData Guard Broker IssuesErrors Converting to a Snapshot StandbyHelpful Hints and TipsAvoid Refreshing the Standby Control FileAvoid Using the NOLOGGING ClauseOMF—Copying Control FileConclusion
Manufacturing Company: HA ConfigurationUtility Company: Zero Data Loss HA/DRRetail Brokerage Firm: HA/DR with Zero Data Loss and Extended Geographic SeparationGovernment Agency: Protection from Multi-site ThreatsPharmaceutical Company: Centralized HA/DR and Data DistributionWeb Retailer: HA/DR with Reader-farm Scale OutInsurance Company: Maximum Availability ArchitectureConclusion
The BasicsTopologyPerformanceReliabilityFinal Thoughts
ch01fn01

Overview

Master Oracle Data Guard 11g

Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download.

Develop a disaster recovery plan for your Oracle database to meet your organization's requirements
Configure and deploy Oracle Data Guard for your environment
Tune and troubleshoot your physical and logical standby databases
Implement the Oracle Data Guard Broker management framework
Integrate with Oracle Grid Control
Monitor your Oracle Data Guard environment
Enable read-only services and disaster recovery with Oracle Active Data Guard
Configure seamless database and application failover
Minimize planned downtime using Oracle Data Guard switchover
Handle backup and recovery with Oracle Recovery Manager

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Oracle Data Guard 11gR2 Administration : Beginner's Guide

Publisher Resources

ISBN: 9780071621113

Oracle Data Guard 11g Handbook

by Larry Carpenter, Joseph Meeks, Charles Kim, Bill Burke, Sonya Carothers, Joydip Kundu, Michael Smith, Nitin Vengurlekar

Overview

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Oracle Data Guard 11gR2 Administration : Beginner's Guide

Oracle Database 12c Security

Oracle GoldenGate 11g Handbook

Oracle Database 12c DBA Handbook

Publisher Resources

Overview

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Oracle Data Guard 11gR2 Administration : Beginner's Guide

Oracle Database 12c Security

Oracle GoldenGate 11g Handbook

Oracle Database 12c DBA Handbook

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.