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 | ||
Using RMAN in a Data Guard Environment | ||
Database Rolling Upgrades using Transient Logical Standby Database | ||
Data Guard: Database Duplication for Physical Standby implementation | ||
Active Data Guard and Real Time Query | ||
Snapshot Standby Database and Real Applications Testing | ||
Data Guard: Fast-Start Failover | ||
Data Guard: Overview and Usage of the Data Guard Broker | ||
Recovery Manager - Duplicate Command | ||
Data Recovery Advisor: A Walk Through |
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
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 |
For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings
