RelationalDBDesign 





Backup Recovery  «Prev  Next»
Lesson 1

Introduction to Oracle Backup and Recovery

Welcome to New Features for Backup and Recovery.
This course introduces you to the newest features introduced in Oracle, which is designed to help you get better database performance. This course covers improvements in Oracle for
  1. indexes,
  2. queries,
  3. the query optimizer;
  4. the use of index-organized tables;
  5. Advanced Queuing.
In addition, Oracle includes a new feature called materialized views that can significantly improve the performance of some queries, such as data warehouse summary queries.
This is the fifth course in the five-part Oracle Certification Series. Taken in conjunction with the other courses within this series, this course will prepare you to pass the Oracle Administrators certification exam. Along the way, you will work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.


Course goals

After completing the course, you will be able to:
  1. Identify elements of Oracle's Recovery Manager (RMAN)
  2. Describe the new backup strategies available with Oracle
  3. Describe other improvements for backup and recovery tasks
  4. Identify tasks that can be performed with Enterprise Manager (regarding backup and recovery)
  5. Start up RMAN and explore its features
  6. Use RMAN to discover backup features of the database
  7. Use line command RMAN and RMAN (GUI tool) to recover a failed database
  8. Identify advantages and components of fast-start recovery
  9. Describe the effect checkpoint parameters and checkpoint command have on recovery
  10. Implement parallel rollback with the fast-start feature
  11. Set up a standby database and start up a read-only database
  12. Describe the improvements in export and import
  13. Implement duplex or multiple archive logs
  14. Detect and repair corrupted block
  15. Describe the functionality of LogMiner
  16. Create reports and lists about backups
  17. Use Enterprise Manager for backup and recovery

The series

Elements for Backup and Recovery is the fifth of five courses in the Oracle Certification Series.
If you are interested in finding out which Oracle courses you should take to help you achieve your learning goals, try our SkillPlanner Maps.
In the next lesson, you will learn about the prerequisites for this course.