List of Tables

• 2-1 Determining the Appropriate Protection Mode
• 2-2 Archiving Recommendations
• 2-3 Minimum Recommended Settings for FastStartFailoverThreshold
• 2-4 Comparison of Backup Options
• 2-5 Typical Wait Times for Client Failover
• 3-1 Recommendations for Monitoring Space
• 3-2 Recommendations for Monitoring the Alert Log
• 3-3 Recommendations for Monitoring Processing Capacity
• 3-4 Recommended Notification Rules for Metrics
• 3-5 Recommendations for Setting Data Guard Events
• 4-1 Unscheduled Outages
• 4-2 Recovery Times and Steps for Unscheduled Outages on the Primary Site
• 4-3 Recovery Steps for Unscheduled Outages on the Secondary Site
• 4-4 Scheduled Outages
• 4-5 Recovery Steps for Scheduled Outages on the Primary Site
• 4-6 Managing Scheduled Outages on the Secondary Site
• 4-7 Types of ASM Failures and Recommended Repair
• 4-8 Recovery Options for Data Area Disk Group Failure
• 4-9 Recovery Options for Flash Recovery Area Disk Group Failure
• 4-10 Non Database Object Corruption and Recommended Repair
• 4-11 Flashback Solutions for Different Outages
• 4-12 Summary of Flashback Features
• 4-13 Additional Processing When Restarting or Rejoining a Node or Instance
• 4-14 Restoration and Connection Failback
• 4-15 SQL Statements for Starting Physical and Logical Standby Databases
• 4-16 SQL Statements to Start Redo Apply and SQL Apply
• 4-17 Queries to Determine RESETLOGS SCN and Current SCN OPEN RESETLOGS
• 4-18 SCN on Standby Database is Behind Resetlogs SCN on the Production Database
• 4-19 SCN on the Standby is Ahead of Resetlogs SCN on the Production Database
• 4-20 Re-Creating the Production and Standby Databases
• 4-21 Platform Migration and Database Upgrade Options
• 4-22 Platform and Location Migration Options
• 4-23 Some Object Reorganization Capabilities
• 5-1 Starting configurations Before Migrating to an MAA Environment
• A-1 Generic SPFILE Parameters for Primary, Physical Standby, and Logical Standby Databases
• A-2 RAC SPFILE Parameters for Primary, Physical Standby, and Logical Standby Databases
• A-3 Data Guard SPFILE Parameters for Primary, Physical Standby, and Logical Standby Databases
• A-4 Data Guard Broker SPFILE Parameters for Primary, Physical Standby, and Logical Standby Databases
• A-5 Data Guard (No Broker) SPFILE Parameters for Primary, Physical Standby, and Logical Standby Databases
• A-6 Data Guard SPFILE Parameters for Primary and Physical Standby Database Only
• A-7 Data Guard SPFILE Parameters for Primary and Logical Standby Database Only
• A-8 Data Guard SPFILE Parameters for Primary Database, Physical Standby Database, and Logical Standby Database: Maximum Availability or Maximum Protection Modes
• A-9 Data Guard SPFILE Parameters for Primary Database, Physical Standby Database, and Logical Standby Database: Maximum Performance Mode