Delegates: |
|
This course is designed for database administrators and technical support staff who are required to plan and implement database backup and recovery strategies for Oracle Database 11g. This course is also suitable for delegates who need to be able to monitor and improve the database performance. |
Objectives: |
|
This course introduces delegates to the main concepts of Oracle backup and recovery. They will learn how to plan and implement a backup and recovery strategy using RMAN. Delegates will also learn to manage memory effectively, carry out some evaluation and tuning exercises, control database resources using Resource Manager, automate tasks with the Scheduler and use Automatic Storage Management (ASM).
|
Topics Covered: |
- Manage Memory
- Plan a Backup and Recovery Strategy
- Oracle Recovery Structures
- Create and Manage a RMAN Recovery Catalog
- Configure Backup Settings
- Use RMAN to Perform Backups
- Use RMAN to Restore and Recover
- Monitor and Tune RMAN
- Perform Tablespace Point-in-Time Recovery
- Create a Duplicate Database with RMAN
- Additional Recovery Issues
- Use Flashback Technology to Recover a Database
- Use Flashback to Recover from User Errors
- Diagnostic Sources
- Use ASM
- Manage Database Performance
- Monitor and Manage Storage with the Segment Advisor
- Control Database Resources using Resource Manager
- Automate Management Tasks with the Scheduler
- Administer the Scheduler
- Use Globalization
|
Requirements:
|
|
A working knowledge of Oracle SQL and Oracle Database Administration. This can be obtained by attendance on the pre-requisite courses. Knowledge of PL/SQL would be beneficial.
|
