Oracle Database Resource Portfolio - High Availability

Key Backup/Recovery, Corruption, and Data Guard Articles

Best Practice Documents

The following Best Practice Documents are available:

• Oracle Data Guard 11g High Availability Best Practices
• Active Data Guard 11g Best Practices (includes best practices for Redo Apply)
• Getting Started with Recovery Manager (RMAN) [Document 360416.1]
• The Gains and Pains of Nologging Operations [Document 290161.1]
• Best Practices for Avoiding and Detecting Corruption [Document 428570.1]
• Top 10 Backup and Recovery best practices. [Document 388422.1]
• Creating a Physical Standby Database [Document 1475344.1]

Best Practice / New Features Webcasts

The following Best Practice / New Features Webcasts are available:

New Feature 12c for DataGuard	Recording	.pdf
Using RMAN in a Data Guard Environment	Recording	.pdf
Database Rolling Upgrades using Transient Logical Standby Database	Recording	.pdf
Data Guard: Database Duplication for Physical Standby implementation	Recording	.pdf
Active Data Guard and Real Time Query	Recording	.pdf
Snapshot Standby Database and Real Applications Testing	Recording	.pdf
Data Guard: Fast-Start Failover	Recording	.pdf
Data Guard: Overview and Usage of the Data Guard Broker	Recording	.pdf
Recovery Manager - Duplicate Command	Recording	.pdf
Data Recovery Advisor: A Walk Through	Recording	.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• High Availability Check (HA_Check) included in RACCHECK [Document 1505808.1]
• Identify the corruption extension using RMAN/DBV/ANALYZE [Document 836658.1]

Tools

• Oracle11g Data Guard: Database Rolling Upgrade Shell Script [Document 949322.1]
• Script to Collect Data Guard Primary Site Diagnostic Information for Version 10g and above (Including RAC) [Document 1577401.1]
• Script to Collect Data Guard Physical and Active Standby Diagnostic Information for Version 10g and above (Including RAC) [Document 1577406.1]
• Script to Collect Data Guard Logical Standby Diagnostic Information for Version 10g and above (Including RAC) [Document 1577407.1]
• RMAN Backup Shell Script Example [Document 137181.1]

Troubleshooting Assistants

• Get Assistance to understand and solve Oracle Database Server Corruptions [Document 1543698.2]
• Handling Block Corruptions in oracle7 / 8 / 8i / 9i / 10g / 11g [Document 1598103.2]

Premium Knowledge Content Notes

• Information Center: Oracle Data Guard Physical Standby Database [Document 1395508.2]
• Master Note For Oracle Recovery Manager (RMAN) [Document 1116484.1]
• Master Note For Oracle Backup And Recovery [Document 1199803.1]
• Master Note for Handling Oracle Database Corruption Issues [Document 1088018.1]
• Master Note For Oracle Flashback Technologies [Document 1138253.1]
• Introduction to Oracle Fail Safe
• Maximize Availability with Oracle Database 12c - Whitepaper
• Usage, Benefits and Limitations of Standby Redo Logs (SRL) [Document 219344.1]

MOS Communities

• Database Backup & Recovery Community
• High Availability Data Guard Community

How-To / FAQ / Troubleshooting

• Resolving ORA-752 or ORA-600 [3020] During Standby Recovery [Document 1265884.1]
• Diagnosing Connection Problems with an active Data Guard Broker Configuration [Document 745201.1]
• Logs are not shipped to the physical standby database [Document 1130523.1]
• Troubleshooting ORA-16191 and ORA-1017 in Data Guard Log Transport Services [Document 1368170.1]
• Top RMAN 11.2 issues [Document Top RMAN 11.2 issues [Document 1473914.1]
• RMAN Tips, Tricks and Pitfalls [Document 1462118.1]
• Common Causes and Solutions on ORA-1113 Error Found in Backup & Recovery [Document 183367.1]
• RMAN Backup Performance [Document 360443.1]
• RMAN Restore Performance [Document 740911.1]
• How to Recover from a Lost Datafile with Different Scenarios [Document 198640.1]
• How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN [Document 223543.1]
• FAQ - Flash Recovery Area feature [Document 305817.1]

Troubleshooting Webcasts

The following Troubleshooting Webcasts are available:

Recovery Manager - Performance Troubleshooting

Recording

.pdf/scripts

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings