Lesson 1

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. 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.

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

In the next lesson, you will learn about the prerequisites for this course.