Hands-On Oracle Database 11g: Backup, Recovery and Server Tuning

Frequently Asked Questions

What is this course about? The guaranteed continuous operation of Oracle databases is a critical requirement of today's successful companies. The success of the database administrator is vital to ensuring the quality, integrity and availability of a company's data. This course provides you with valuable experience performing the critical tasks of safeguarding and tuning Oracle databases. Through extensive hands-on exercises, you learn how to cope with a range of disasters and performance issues. Detailed aspects of server-side tuning are addressed, as well as hints on performing root cause analysis. This course does not cover parallel server technologies (e.g., RAC) or its grid concepts. However, the course concentrates on the major new features of Oracle Database 11g such as database replay, flashback archive, and other 11g enhancements. The course concentrates on issues that DBAs most commonly face and the skills and techniques required to maintain an efficient and highly available system. Who will benefit from this course? This course is designed for professionals who are or will be involved in the administration of an Oracle 11g database, including: Database administrators who have had experience administering Oracle databases and who need to learn how to backup, recover and tune Oracle databases Application or systems developers who are adopting the role of a DBA, or who are interested in the techniques used to properly safeguard and tune an Oracle RDBMS Systems administrators who are often not DBAs or at least the primary DBA, who want to learn how to maintain, service and optimize database resources to allow an Oracle RDBMS to effectively run on their machines What background should I have? This is not an introductory course. Oracle database management experience or knowledge equivalent toCourse 927, Oracle® Database 11g Administration: Hands-On or Course 594, Oracle® Database 10g Administration: Hands-On, is required. What version of Oracle is used? This course is currently running on Oracle 11g, Release 1 on the Windows platform. Is this course useful if I'm working with an earlier version of Oracle? This course covers the protection and tuning of Oracle 11g databases. If you are using an earlier version but are planning to move to Oracle 11g, then this course is for you. Does this course cover grid computing and RAC? This course covers fundamental backup, recovery and tuning techniques applicable to all Oracle environments. Grid computing and RAC are specialized installations requiring skills and knowledge beyond the scope of this course. Will it matter if I use Oracle on a different platform, such as UNIX or VMS? No, most of the topics covered are not operating system-specific. However, issues that are affected by the operating system are highlighted and the differences noted. I've taken Course 518, should I take this course? No, there is too much overlap in the course to warrant taking both courses. How does this course relate to Course 927? This course provides the follow-on material to Course 927, Oracle® Database 11g Administration: Hands-On. It completes the set of skills needed to fully administer a typical Oracle 11g database. How much time is spent on each topic? Content Hours Configuring the Oracle 11g environment 2.0 Safeguarding the Database 2.0 Performing backup and recovery with RMAN 6.0 Managing backup and recovery with OEM 2.0 Disaster Recovery with Data Guard 4.0 Configuring and tuning the Oracle server 3.0 Oracle 11g server automated tuning 3.0 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. What kinds of hands-on exercises are included? Hands-on exercises provide you with practical experience with Oracle 11g. Exercises include: Building a fault-tolerant database Enabling fast recovery with flashback database Backing up and recovering databases with RMAN and OEM Creating an Oracle 11g Data Guard environment Performing failover to the standby database Improving the performance of commonly used queries with the result cache Diagnosing and relieving lock contention with ADDM Why should I take this course instead of a course offered by Oracle? Learning Tree is dedicated to helping accelerate the careers of our clients by providing them with world-class technology and management training. Our independence from Oracle (and every other vendor) allows us to give an unbiased view of what works and what does not. This course is objective in its approach, having been developed independently from Oracle by industry experts who bring their real-world experience to the classroom. How does this course relate to other Learning Tree courses? Other courses that may be of interest include: 593, Oracle® Database 10g: A Comprehensive Hands-On Introduction  493, Oracle® PL/SQL Programming: Hands-On  234, Developing SQL Queries for Oracle® Databases: Hands-On  492, Application Development and Tuning for Oracle® Databases: Hands-On  535, Developing High-Performance SQL Server® Databases: Hands-On  289, Disaster Recovery Planning: Ensuring Business Continuity  961, Windows Server® 2008 Administration: Hands-On  435, UNIX® Administration and Support: Hands-On  926, Oracle® Database 11g: A Comprehensive Hands-On Introduction

Oracle is a registered trademark of Oracle Corporation.