Sumário Itens Encontrados: 331Preface 1Chapter 1: Getting Started 7What is Data Guard? 7Standby database 8Physical standby database 9Logical standby database 10Snapshot standby database 10Oracle Data Guard evolution 11Version 7.3 â stone age 11Version 8i â first age 11Version 9i â middle age 12Version 10g â new age 12Version 11g â modern age 13Oracle Data Guard architecture 14Data Guard services 15Redo transport services 15Apply services 18Time for action â monitoring Redo Apply 19SQL Apply (logical standby databases) 23Role transitions 23Switchover 24Failover 24User interfaces for administering Data Guard 25SQL*Plus 25DGMGRL 25Enterprise Manager 25Time for action â using interfaces to monitor Data Guard 26Data Guard background processes 29Other replication solutions and Data Guard 30Storage-based replication solutions 30GoldenGate and Streams 31Summary 34Chapter 2: Configuring the Oracle Data Guard Physical Standby Database 35Preconfiguration for Data Guard 35Data loss consideration 36Network bandwidth consideration 37Preparing the primary database 37Archive log mode 37Time for action â enabling the archive log mode 38Force logging 39Time for action â enabling force logging 40Standby redo logs 40Time for action â configuring standby redo logs on primary 41Fast recovery area (FRA) 42Time for action â enabling FRA 43Understanding initialization parameters 44DB_NAME 44DB_UNIQUE_NAME 44LOG_ARCHIVE_CONFIG 45LOG_ARCHIVE_MAX_PROCESSES 46LOG_ARCHIVE_DEST_n 46LOCATION and SERVICE 47VALID_FOR 47SYNC and ASYNC 48AFFIRM and NOAFFIRM 49COMPRESSION 49MAX_CONNECTIONS 49MAX_FAILURE 50REOPEN 50NET_TIMEOUT 51DELAY 51LOG_ARCHIVE_DEST_STATE_n 52Creating the physical standby database 53Standby database related initialization parameters 53FAL_SERVER 53STANDBY_FILE_MANAGEMENT 54DB_FILE_NAME_CONVERT 54LOG_FILE_NAME_CONVERT 55The physical standby database instance 55Time for action â starting the physical standby instance and making it readyfor the RMAN duplicate 55Using RMAN duplicate to create physical standby databases 61Time for action â running an RMAN duplicate 62Post-installation steps 65Verifying the standby database configuration 65Time for action â verifying the standby database configuration 65Managing Redo Apply 67Time for action â starting, stopping, and monitoring MRP 67Verifying synchronization between the primary and standby databases 71Time for action â verifying synchronization between the primary andstandby databases 72Time for action â testing real-time apply 74Summary 77Chapter 3: Configuring Oracle Data Guard Logical Standby Database 79Logical standby database characteristics 79Not everything must be duplicated 80Use for reporting at all times 80Independent standby database objects 80Protecting writes on replicated standby tables 81Limitation for specific data types and objects 81High availability and disaster recovery considerations 82Preparation for the configuration 82Time for action â checking for the unsupported data types 83Time for action â searching for and fixing any table row uniqueness problem 85Creating a logical standby database 87Time for action â making a physical standby database environment readyfor conversion 88Time for action â converting a physical standby database into a logicalstandby database 90Verifying the logical standby database 94Time for action â checking the redo transport service status 94Time for action â checking the SQL Apply service status 96Customization and management in a logical standby database 98Selective replication in a logical standby database 98Time for action â working with skip rules on a logical standby database 98Data base Guard settings for the logical standby database 103Time for action â changing the Database Guard setting 104Disabling database guard for a session 105Creating objects on the logical standby database 106Creating and re-creating tables 106Creating scheduler jobs 106Creating materialized views 107Time for action â creating objects on the logical standby database 107Automatic deletion of archived logs 111Deletion of the foreign archived logs 111Deletion of the local archived logs 113Summary 113Chapter 4: Oracle Data Guard Broker 115Introduction to Data Guard broker 115Data Guard broker features and benefits 117Centralized and simple management 117Cloud Control integration 117Oracle Data Guard and RAC 117Role transition with Data Guard broker 118Data Guard fast-start failover 118Recommendation 118Data Guard broker components 119Oracle Data Guard broker server-side components 119Data Guard Monitor process (DMON) 120Configuration file 121Oracle Data Guard broker client-side components 121DGMGRL utility 121Enterprise Manager Cloud Control client 121Implementation of Oracle Data Guard broker 122Time for action â initial setup of Data Guard broker 122Time for action â connecting to Data Guard broker 125Time for action â basic monitoring with Data Guard broker 127Management with Data Guard broker 131Enabling and disabling broker configuration 131Time for action â disabling broker configuration 131Enabling and disabling a standby database 132Time for action â disabling and enabling database 133Changing configuration and database properties using broker 134Time for action â changing the database name 135Changing the state of the database 137Troubleshooting Data Guard broker 138Data Guard tracing 139Most Common Data Guard broker issues 139ORA-16797: database is not using a server parameter file 139ORA-10458:standby database requires recovery 140ORA-16737:the redo transport service for standby database "string"has an error 141ORA-16715:redo transport-related property string of standbydatabase "string" is inconsistent 142ORA-12514:TNS:listener does not currently know of service requestedin connect descriptor 143Current listener description 143Oracle Data Guard fast-start failover 144Time for action â configuring fast-start failover 146Troubleshooting observer configuration 149Script to stop and start observer 151Summary 151Chapter 5: Data Guard Protection Modes 153The Maximum Protection mode 154The Maximum Performance mode 155The Maximum Availability mode 155Choosing the correct mode for your requirements 156Changing Data Guard protection mode 157Time for action â changing the protection mode with SQL*Plus 157Time for action â changing the protection mode with Data Guard broker 163Time for action â changing the protection mode with Enterprise ManagerCloud Control 165Summary 172Chapter 6: Data Guard Role Transitions 173Role transition considerations 173Switchover 174Performing switchover with a physical standby database using SQL*Plus 176Time for action â preliminary tests before performing switchover 176Time for action â switchover with a physical standby using SQL*Plus 179Performing switchover with a physical standby database using broker 184Time for action â switchover with a physical standby using broker 184Performing switchover with a physical standby database usingEM Cloud Control 185Time for action â switchover with a physical standby using EM Cloud Control 186Performing switchover with a logical standby database using SQL*Plus 187Time for action â switchover with a logical standby database using SQL*Plus 188Performing switchover with a logical standby database using broker 192Time for action â switchover with a logical standby using broker 192Failover 194Performing failover with a physical standby database 195Time for action â failover with a physical standby database using SQL*Plus 196Performing failover with a logical standby database 199Time for action â failover with a logical standby using broker 199Summary 201Chapter 7: Active Data Guard, Snapshot Standby, andAdvanced Techniques 203Oracle Active Data Guard 204Why Active Data Guard? 204Oracle Data Guard license 207Enabling Active Data Guard 208Time for action â enabling Active Data Guard if Redo Apply is runningusing SQL *PLUS 208Time for action â enabling Active Data Guard if the standby database isshut down 209Time for action â enabling Active Data Guard using broker 210Monitoring Active Data Guard 212From primary 212From standby 213Active Data Guard with applications 213Active Data Guard with PeopleSoft 214Time for action â Active Data Guard with PeopleSoft 215Active Data Guard with EBS 216Active Data Guard with TopLink 217Active Data Guard with Oracle BI 218Active Data Guard with SAP 218Active Data Guard features 219EXPDP from standby database using NETWORK_LINK (ADG) 219Time for action â exporting a database backup from Active Data Guard 219Time for action â using the ASH report from the standby database 220Using a snapshot standby database 223Time for action â converting to a snapshot standby database 223Time for action â converting to a physical standby database 225Cascade standby databases 227Limitations with cascade standby database 228Time for action â cascade standby database 228Advanced compression in Data Guard 231Time for action â enabling advanced compression 231Preparation of standby on a cross-platform Data Guard 233Time for action â creating a cross-platform Data Guard setup 234Data Guard tuning and wait events 237Network tuning 237Redo transport and apply tuning 238Data Guard wait events 240Summary 241Chapter 8: Integrating Data Guard with the Complete Oracle Environment 243The Oracle Enterprise Manager Cloud Control integration 243Time for action â adding the Data Guard configuration into Cloud Control 244Cloud Control Data Guard administration home page 250Modifying the Data Guard configuration 251Time for action â enabling/disabling fast-start failover 254Monitoring Data Guard performance 258Using Incident Manager to monitor Data Guard 259Time for action â setting the threshold and creating an incident forestimated failover time metric 261RMAN integration 264Integration requirements and best practices 264Physical standby requirement 264RMAN Catalog requirement 264Using a different DB_UNIQUE_NAME 265General RMAN best practices 265RMAN settings for the Data Guard environment 265Registering primary database in the catalog 266Configuring RMAN settings for primary database: 266Configuring RMAN settings for standby database 268Checking the RMAN configuration 268Time for action â recovering a primary database using a standbydatabase disk backup 270Using block change tracking with Data Guard 272RAC integration 273A RAC primary database with a single instance standby database 274A RAC primary database with a RAC standby database 275Summary 275Chapter 9: Data Guard Configuration Patching 277What is patch and what are patch types? 277Interim patch 278CPU/SPU patches 278PSU patches 278Patch set 278Patching on Data Guard 279Best practices of patching 279Upgrading OPatch 279Performing prerequisite checks of patch 280How to clean up patch history? 281Patching on Data Guard configuration 282How to apply an interim/bug patch on logical standby? 282Time for action â applying a patch on logical standby 283How to apply a PSU patch on physical standby database using broker? 287Time for action â applying PSU on a physical standby database 288How to apply patch set on physical standby (11.2.0.1 to 11.2.0.3)? 296Time for action â patch set upgrade of physical standby 296Summary 304Chapter 10: Common Data Guard Issues 305Recreating the standby control file 306Time for action â recreating the standby control file 307Dealing with redo transport authentication problems 311Time for action â changing the SYS password in a Data Guard environment 311Time for action â changing the redo transport user 313Dealing with UNNAMED datafiles 315Time for action â resolving UNNAMED datafile errors 315Closing a gap with an RMAN incremental backup 317Time for action â closing a gap with an RMAN incremental backup 318Fixing NOLOGGING changes on the standby database 322Time for action â fixing NOLOGGING changes on a standby database withincremental datafile backups 323Time for action â fixing NOLOGGING changes in the standby database withincremental database backups 325Turning on Data Guard tracing 326Gathering diagnostic data 328Alert log and trace files 328Time for action â monitoring the database alert log using ADRCI 330Data Guard broker logs 334Dynamic performance views 335Summary 338Chapter 11: Data Guard Best Practices 339Configuring a connection failover 339Transparent Application Failover (TAF) 340Configuring the client-side TAF 341Configuring the server-side TAF 341Fast Connection Failover (FCF) 344Time for action â configuring FCF for JDBC connections 344Fast Application Notification (FAN) 346The archived log deletion policy on the standby database 347Time for action â the recommended configuration for archived logmaintenance on a standby database 347Using flashback on a standby database 348Time for action â using flashback on a standby database 349Database rolling upgrade using the transient logical standby database 355Time for action â performing a rolling upgrade using the transientlogical standby database 355Corruption detection, prevention, and automatic repair with Oracle Data Guard 366DB_BLOCK_CHECKSUM 367DB_BLOCK_CHECKING 368DB_LOST_WRITE_PROTECT 369Automatic block media repair 369Summary 370Pop Quiz Answers 371Chapter 1, Getting Started 371Chapter 5, Data Guard Protection Modes 371Chapter 9, Data Guard Configuration Patching 372Chapter 10, Common Data Guard Issues 372Index 373