Sumário Itens Encontrados: 2581 Data Guard Architecture 1Data Guard Overview 2What Is Redo? 2Redo Transport Services 5Synchronous Redo Transport 5Asynchronous Redo Transport 7Redo Transport Compression 9Automatic Gap Resolution 9Apply Services 11Redo Apply (Physical Standby) 12SQL Apply (Logical Standby) 15Canât Decide? Then Use Both! 17Data Guard Protection Modes 18Maximum Performance 18Maximum Availability 18Maximum Protection 19Role Management Services 19Switchover 20Failover 21Data Guard Management 24Active Standby Databases 26Offload Read-Only Queries and Reporting 26Offload Backups 27Testing 27Data Guard and the Maximum Availability Architecture 29Conclusion 292 Implementing Oracle Data Guard 31Plan Before You Implement 32Determining Your Requirements 33Understanding the Configuration Options 35Relating the RPO and RTO to the Protection Mode 62Creating a Physical Standby Database 63Choosing Your Interface 63Before You Start 64Using Oracle Enterprise Manager Grid Control 65The Power User Method 78Creating a Logical Standby 98Data Guard and Oracle Real Application Clusters 105Conclusion 1063 Redo Processing 107Important Concepts of Oracle Recovery 108ACID Properties 108Oracle Recovery 109Life of a Transaction 111Nologging Operations 111The Components of a Physical Standby 114Real-time Apply 117Scaling and Tuning Data Guard Apply Recovery 118Parallel Media Recovery 119Tools and Views for Monitoring Physical Standby Recovery 120Physical Standby Corruption Detection 12411g New Data Protection Changes 124Data Protection and Checking on a Physical Standby 125Conclusion 1264 Logical Standby 127Characterizing the Dataset Available at the Logical Standby 129Characterizing the Dataset Replicated from the Primary Database 129Protecting Replicated Tables on a Logical Standby 134Customizing Your Logical Standby Database (or Creatinga Local Dataset at the Logical Standby) 141Understanding the Operational Aspects of a Logical Standby 145Looking Inside SQL Apply 145Tuning SQL Apply 157Some Rules of Thumb 158Determining Whether SQL Apply Is Lagging 158Determining Whether SQL Apply Is the Bottleneck 159Determining Which SQL Apply Component Is the Bottleneck 159Troubleshooting SQL Apply 164Understanding Restarts in SQL Apply 164Troubleshooting Stopped SQL Apply 167Conclusion 1705 Implementing Oracle Data Guard Broker 171Overview of the Data Guard Broker 172The Broker Process Model 173The Broker Process Flow 174The Broker Configuration Files 176The Broker CLI 178Getting Started with the Broker 179Configuring the Broker Parameters 179The Broker and Oracle Net Services 183RAC and the Broker 187Connecting to the Broker 190Managing Data Guard with the Broker 193Creating and Enabling a Broker Configuration 193Changing the Broker Configuration Properties 200Changing the State of a Database 211Changing the Protection Mode 212Monitoring Data Guard Using the Broker 214Removing the Broker 216Conclusion 2176 Oracle Enterprise Manager Grid Control Integration 219Accessing the Data Guard Features 220Configuring Data Guard Broker with OEM Grid Control 221Verify Configuration and Adding Standby Redo Logs 224Viewing Metrics 226Modifying Metrics 227Viewing the Alert Log File 228Enabling Flashback Database 230Reviewing Performance 231Changing Protection Modes 234Editing Standby Database Properties 236Performing a Switchover 238Performing a Manual Failover 240Fast-Start Failover 243Creating a Logical Standby 244Managing Active Standby 250Managing Snapshot Standby 250Removing a Standby Database from Broker Control 250Keeping an Eye on Availability 252Conclusion 2557 Monitoring Data Guard Implementations 257Monitoring the Data Guard Environment 258Mining the Alert Log File (PS+LS) 259Gathering Statistical Information from Archive Log History (PS+LS) 264Detecting Archive Log Gaps (PS+LS) 266Identifying Delays in Redo Transport (PS) 268Monitoring Archive Log Destinations (PS+LS) 269Examining Apply Rate and Active Rate (PS) 271Reviewing Transport and Apply Lag (PS+LS) 272Determining the Current Time on the Standby Database (PS) 273Reporting the Status of Managed Recovery Process (PS) 275Data Guard Menu Utility 276Reviewing the Current Data Guard Environment 277Checking the Password File (PS+LS) 278Checking for Nologging Activities (PS+LS) 279Looking at Archivelog Mode and Destinations (PS+LS) 282Checking Standby File Management (PS) 284Revealing Errors in the Data Guard Status View (PS) 284Logical Standby Data Guard Menu 285Conclusion 2978 Switchover and Failover 299Introduction to Role Transition 300Switchover 300Failover 302Switchover vs Failover 309Flashback Technologies and Data Guard 309Performing a Switchover 311Configuration Completeness Check 311Preparatory Checks 311Preprocessing Steps 314Switching over to a Physical Standby 315Switching over to a Logical Standby 320Using the Broker or Grid Control to Switchover 323Switchover Health Check 324Performing a Failover 324Failing over to a Physical Standby 326Failing over to a Logical Standby 328Bringing Back the Old Primary 329Using the Broker or Grid Control to Failover 334Automatic Failover 335A Final Word on Multiple Standbys 348Conclusion 3489 Active Data Guard 349Physical StandbyâOpen Read-Only 350Why Read-Only? 351The Downside of Read-Only or Read-Write Mode 352Snapshot Standby for QA and Test Environments 353Read Write Standby in Oracle Database 10g 353Snapshot Standbys in Oracle Database 11g 357Real Application Testing 364Database Replay 365SQL Performance Analyzer 370Active Data Guard 371Configuring Active Data Guard 374Conclusion 37610 Automating Site and Client Failover 377Defining the Problem 378Complete Site Failover 378Partial Site Failover 379The Nitty Gritty 379Connection Load Balancing and Connect Time Failover 380Outbound Connect Timeout 381Transparent Application Failover 382Fast Application Notification 384The DB_ROLE_CHANGE System Event 386Implementing Client Failover 387Complete Site Failover Configuration 387Conclusion 39411 Minimizing Planned Downtime Using Data Guard Switchover 395Overview of Planned Migration 396Leveraging Data Guard Switchover for Planned Migration 397Case 1âNew Data Center 397Case 2âMove to ASM 397Performing a Database Rolling Upgrade Using Data Guard 398Leveraging Rolling Upgrades Using SQL Apply 399Rolling Upgrades Using Transient Logical Standby 402Conclusion 40812 Backup and Recovery Considerations 409RMAN Basics 410RMAN Integration with Data Guard 411Block Change Tracking Support 411Control File Management 412Resynchronizing the RMAN Catalog 412RMAN Configuration in Data Guard 412Example Configuration for a Primary Database 414Example Configuration for a Backup Standby Database 415Example Configuration for Other Physical Standby Databases 415Backup Strategies 415Backup Scenarios 417Backup Database Not Backed Up 417Full Backups on Primary 417Backup as Copy 419Image Copy Rolled Forward 420Standby Database Creation 423Backups on a Standby Database 423Archive Backups 426General Recovery Strategies 426Media Failure 426Block Corruption 426User Errors 429Recovery Scenarios 430Loss of a Datafile on a Primary Database 430Loss of a Datafile on a Standby Database 431Loss of Standby Controlfile 432Loss of Primary Controlfile 432Loss of an Online Redo Log File 432Incomplete Recovery of the Primary Database 436Recovering from a Dropped Table 437Recover a Missing Datafile from a Backup Taken on the Standby 437General Best Practices 440Conclusion 44113 Troubleshooting Data Guard 443Diagnostic Information 444Database Alert Logs 444Observer Log Files 447Data Guard Trace Files 447Data Guard Broker Log Files and Tools 448Dynamic Performance Views 449Data Guard Configuration and Management Errors 450Common Management Issues 450Physical Standby Issues 456Logical Standby Database Failures 459Switchover Issues 461Failover Issues 463Data Guard Broker Issues 464Errors Converting to a Snapshot Standby 468Helpful Hints and Tips 468Avoid Refreshing the Standby Control File 468Avoid Using the NOLOGGING Clause 468OMFâCopying Control File 469Conclusion 47014 Deployment Architectures 471Manufacturing Company: HA Configuration 473Utility Company: Zero Data Loss HA/DR 476Retail Brokerage Firm: HA/DR with Zero Data Loss andExtended Geographic Separation 478Government Agency: Protection from Multi-site Threats 480Pharmaceutical Company: Centralized HA/DR and Data Distribution 483Web Retailer: HA/DR with Reader-farm Scale Out 484Insurance Company: Maximum Availability Architecture 486Conclusion 488A Data Guard vs Array-based Remote Mirroring Solutions 491The Basics 492Topology 493Performance 493Reliability 494Final Thoughts 495Index 497