3/21

List of Tables

• 2-1 Tradeoffs for Different Test and QA Environments
• 8-1 Backup and Recovery Summary
• 8-2 Sample Situations that Require Database Backup
• 8-3 Comparing Backup to Disk Options
• 9-1 Requirements and Data Guard Deployment Options
• 9-2 Archiving Recommendations
• 9-3 Parallel Recovery Coordinator Wait Events
• 9-4 Parallel Recovery Slave Wait Events
• 9-5 Comparing Fast-Start Failover and Manual Failover
• 9-6 Minimum Recommended Settings for FastStartFailoverThreshold
• 12-1 Recommendations for Monitoring Space
• 12-2 Recommendations for Monitoring the Alert Log
• 12-3 Recommendations for Monitoring Processing Capacity
• 12-4 Recommendations for Performance Related Metrics
• 12-5 Recommendations for Setting Data Guard Metrics
• 13-1 Recovery Times and Steps for Unscheduled Outages on the Primary Site
• 13-2 Recovery Steps for Unscheduled Outages on the Secondary Site
• 13-3 Types of Oracle ASM Failures and Recommended Repair
• 13-4 Recovery Options for Data Area Disk Group Failure
• 13-5 Recovery Options for Fast Recovery Area Disk Group Failure
• 13-6 Flashback Solutions for Different Outages
• 13-7 Summary of Flashback Features
• 13-8 Additional Processing When Restarting or Rejoining a Node or Instance
• 13-9 Restoration and Connection Failback
• 13-10 SQL Statements for Starting Standby Databases
• 13-11 SQL Statements to Start Redo Apply and SQL Apply
• 13-12 Queries to Determine RESETLOGS SCN and Current SCN OPEN RESETLOGS
• 13-13 SCN on Standby Database is Behind RESETLOGS SCN on the Primary Database
• 13-14 SCN on the Standby is Ahead of Resetlogs SCN on the Primary Database
• 13-15 Re-Creating the Primary and Standby Databases
• 14-1 Solutions for Scheduled Outages on the Primary Site
• 14-2 Managing Scheduled Outages on the Secondary Site
• 14-3 Database Upgrade Options
• 14-4 Platform and Location Migration Options