Oracle Database Resource Portfolio - RAC/Scalability

Key RAC/ScalabilityArticles

Best Practice Documents

The following Best Practice Documents are available:

• RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) [Document 810394.1]
• RAC: Frequently Asked Questions [Document 220970.1]
• Top 11 Things to do NOW to Stabilize your RAC Cluster Environment [Document 1344678.1]
• Top 11gR2 RAC Installation Issues [Document 1372375.1]
• Top 11gR2 Grid Infrastructure Upgrade Issues [Document 1366558.1]
• How to Modify Private Network Information in Oracle Clusterware [Document 283684.1]
• How to Modify Public Network Information including VIP in Oracle Clusterware [Document 276434.1]
• How to update the IP address of the SCAN VIP resources [Document 952903.1]
• Using Oracle Clusterware with Vendor Clusterware FAQ [Document 332257.1]

Best Practice Webcasts

The following Best Practice Webcasts are available:

How To Setup 12c ACFS RAC Filesystem Through EM Cloud Control 12c

Recording

.pdf

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

Health Checks

• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]

Tools

• Cluster Health Monitor (CHM) FAQ [Document 1328466.1]
• TFA Collector- The Preferred Tool for Automatic or ADHOC Diagnostic Gathering Across All Cluster Nodes [Document 1513912.1]
• CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [Document 330358.1]
• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]

Troubleshooting Assistants

• Oracle Grid Infrastructure Install [Document 1551639.2]
• Oracle Grid Infrastructure Upgrade [Document 1553630.2]
• Oracle Grid Infrastructure Patching [Document 1553605.2]

Premium Knowledge Content Notes

• Information Center: Oracle Scalability Grid Infrastructure / Clusterware and Real Application Clusters (RAC) [Document 1452965.2]
• Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure [Document 1096952.1]

MOS Communities

• RAC/Scalability MOS Community

Troubleshooting Documents

The following Troubleshooting Documents are available:

• Troubleshooting Clusterware Node Evictions (Reboots) [Document 1050693.1]
• Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions [Document 559365.1]
• Top 5 RAC Instance Crash Issues [Document 1375405.1]
• Top 5 Issues That Cause Troubles with Scan VIP and Listeners [Document 1373350.1]
• Top 5 Database and/or Instance Performance Issues in RAC Environment [Document 1373500.1]
• Top 5 (RAC Specific) Database Management Issues With DBCA, NETCA, DBUA and Other Tools [Document 1371066.1]
• Top 5 CRS Cluster Patching Issues [Document 1372859.1]
• Top 5 issues for Instance Eviction [Document 1374110.1]
• Troubleshooting "Global Enqueue Services Deadlock detected" [Document 1443482.1]
• Troubleshooting: "log file sync" Waits [Document 1376916.1]

Read More

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

Read More