|
|
|
You Will Learn How To
- Implement backup and recovery strategies to safeguard Oracle 11g databases
- Configure the database for fault tolerance
- Perform backup and recovery with Recovery Manager and Oracle Enterprise Manager
- Maintain high availability with hot standby databases using Oracle Data Guard
- Alleviate bottlenecks by tuning the Oracle 11g server memory components
- Automate server tuning with the workload repository and diagnostics information
Course Benefits Oracle Database 11 g includes an increased range of tools that can be used to ensure full protection and recovery from failure. Those responsible for administering Oracle data need an in-depth knowledge of these tools to ensure optimal database availability. In this course, you gain extensive hands-on experience with backup strategies and recovery techniques on Oracle databases. You employ a set of automated tuning tools to mitigate poor resource allocation and enhance database performance.
Who Should Attend Those interested in safeguarding and tuning Oracle 11 g databases. Knowledge of database administration at the level of Course 927, " Oracle Database 11g Administration", is assumed.
Hands-On Training Hands-on exercises provide you with practical experience with Oracle 11 g. 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
- Activating the standby database
- Improving the performance of commonly used queries with the result cache
- Diagnosing and relieving lock contention with ADDM
Course Content Safeguarding the Database
Ensuring resilience
- Configuring and protecting redo logs and control files
- Achieving total recall with Flashback Data Archive
Performing backups
- Selecting appropriate backup strategies
- Implementing hot and cold backups
- Managing the Flash Recovery Area
Recovering the database
- Database, tablespace and datafile recoveries
- Flashing back the database to a recent point in time
Performing Backup and Recovery with Recovery Manager (RMAN)
Setting up Recovery Manager
- Creating and merging recovery catalogues
- Registering databases for recovery
- Modifying catalogue contents
- Implementing virtual private catalogues
- Configuring channels and redundancy
Backup operations with RMAN
- Working with full and incremental backups
- Scripting the backup activity
- Listing and reporting on RMAN operations
- Maintaining the redo stream with archival backups
- Protecting very large datafiles with multisection backups
Performing automated recovery
- Backup sets and image copies for restore and recovery
- Rolling forward image copies with incremental backups
- Tuning backup processing with block change tracking
Managing Backup and Recovery with Oracle Enterprise Manager (OEM)
Automating backup and recovery operations
- Configuring default settings
- Navigating the screens to perform backup and recovery
Repairing lost data with Data Recovery Advisor
- Obtaining advice for repairing data failures
- Executing repairs
- Classifying and closing failures
Disaster Recovery with Data Guard
Establishing the standby environment
- Building and synchronising the standby database
- Creating the standby with active database duplication
- Controlling log shipping and redo apply mechanisms
- Applying data protection policies
- Physical vs. logical standby databases
Managing the standby database
- Maintaining a read-only standby during managed recovery
- Synchronising the standby with incremental backups
- Preserving the performance of the primary database
Moving operations to the standby
- Failing over and switching to the standby facility
- Achieving No-Data-Loss and delayed recovery
Configuring and Tuning the Oracle Server
Tuning the SGA
- Maximising the use of the shared pool
- Tuning the buffer cache with the Buffer Cache Advisor
- Reducing I/O with multiple buffer pools
- Monitoring latch contention
Enhancing query performance with the result cache
- Controlling result cache usage with table annotations
- Monitoring the result cache with DBMS_RESULT_CACHE
Oracle 11g Server Automated Tuning
Automatic Workload Repository (AWR)
- Performing root cause analysis with the Automatic Database Diagnostics Monitor (ADDM)
- Tracking session activity with Active Session History (ASH)
- Handling logging and tracing with Automated Diagnostics Repository (ADR)
- Gathering statistics with user-specified preferences
- Managing deferred and historical statistics
Automatic Memory Management (AMM)
- Tuning memory with the memory advisors
- Enabling total memory management with AMM
Generating workloads for predictive testing
- Capturing workloads with Database Replay
- Analysing and evaluating the results of the replay session
|
<< Back to Oracle Databases
Related Courses
Oracle is a registered trademark of Oracle Corporation.
|
|
Course Dates
UK Dates | | 10-13 Jul | London enrol | | 4-7 Dec | London enrol | US East Coast Dates | | 20-23 Mar | Washington, DC enrol* | | 2-5 Apr | New York enrol* | | 22-25 May | Washington, DC enrol* |
*New York and Washington DC Courses – Available online with a run time of 2pm to 9pm BST. For AnyWare enrolments, please register at least 10 days prior to the start of the course.
More Dates and Locations.
|
|
|
|
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customised for your organisation.
|
Participants successfully recovering an Oracle 11g database.
|
|
Average Attendee Evaluation
|
Evaluations in the last 12 months |
|
5 stars:
|
|
77% |
|
4 stars:
|
|
19% |
|
3 stars:
|
|
4% |
|
2 stars:
|
|
0% |
|
1 star:
|
|
0% |
|
"Other training provider's course content is usually too general. Learning Tree classes really get down to the details where I live".
– M. Yake
Commonwealth Solutions, Inc.
|
|
 |
 |
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
