Title: Section 6 - Using Composite Datatypes
Course: Dept MC - ADVANCED ORACLE PL/SQL > Section: Unit 3 - Advanced Oracle PL/SQL

In Section 5 you learned about the intricacies of using RMAN for recovering your database, which Oracle considers a server-managed recovery operation. In contrast, using operating system commands and SQL commands to restore and recover your database is known as user-managed backup and recovery. In this chapter, the focus is on user-managed backup and recovery, although some of the scenarios presented here will appear to be similar to the scenarios presented in Chapter 5 using the equivalent RMAN commands.

Section 6 Learning Outcomes:

- Recover from a lost TEMP file
- Recover from a lost redo log group
- Recover from the loss of password file
- Perform user-managed complete database recovery
- Perform user-managed incomplete database recovery
- Perform user-managed and server managed backups
- Identify the need of backup mode
- Back up and recover a control file

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!