Title: Section 7 - Exception Handling
Course: Dept MC - ADVANCED ORACLE PL/SQL > Section: Unit 3 - Advanced Oracle PL/SQL

Section 6 took a little detour away from RMAN to cover user-managed recovery techniques. It’s important that you know how to make backups outside of RMAN for three reasons:

■ The complexity of using RMAN might be overkill for a small read-only database.

■ A user-managed backup strategy (including logical backups) can be a fallback for RMAN-created backups in case of a corrupted RMAN backup or bug in RMAN itself (both of which are quite rare).

■ You need to know how to perform user-managed backups for the certification exam!

This chapter moves back into the world of RMAN and covers two important RMAN features: creating a duplicate database, and using tablespace point-in-time recovery (TSPITR).

Section 7 Learning Outcomes:

- Create a duplicate database using RMAN
- Use a duplicate database
- Describe the situations that require TSPITR
- Perform automated TSPITR

One of the most important things to be successful in this course is to learn to navigate and locate assignments and information.  When in doubt, go to Modules!