Performing Database Recovery
The "Performing Database Recovery" module shows how to use the Data Recovery Advisor, which can help find and recover the database: Performing Recovery Operations, Recovering from User Errors, Recovering from Loss of Control Files, Recovering from Loss of Redo Log Files, Recovering from Loss of Non-System Critical Data Files, Recovering..
Already have an account? Sign In »

Introduction
The Performing Database Recovery module shows how to use the Data Recovery Advisor, which can help find and recover the database.
- Performing Recovery Operations
- Recovering from User Errors
- Recovering from Loss of Control Files
- Recovering from Loss of Redo Log Files
- Recovering from Loss of Non-System Critical Data Files
- Recovering from Loss of System Critical Data Files
Exercise 1 - Performing Recovery Operations
In this exercise you will learn the following about performing recovery operations:
- Establishing a connection to the database
- Understanding Instance Start-up
Exercise 2 - Recovering from User Errors
In this exercise, you will learn the following about how to recover from user errors:
- Using Flashback Query
- Using Flashback Drop and the Recycle Bin
- Using Flashback Table
Exercise 3 - Recovering from a Loss of a Control File
In this exercise, you will learn the following about recovering a control file loss:
- Recovering a Control File Loss
Exercise 4 - Recovering from the Loss of a Redo Log File
In this exercise, you will learn the following about recovering a redo log file loss:
- Recovering a Redo Log File Loss
Exercise 5 - Recovering from a Loss of a Non-System Critical Data File
In this exercise, you will learn the following about recovering a non-system critical data file loss:
- Recovering a Non-System Critical Data File Loss
If a non-system-critical data file (not the system or UNDO tablespace) is lost, most of your recovery efforts in the ARCHIVELOG mode take place while the database is still open to users who can use tablespaces except the one that is being recovered. The loss can occur in two modes: NOARCHIVELOG Mode and ARCHIVELOG Mode.
Exercise 6 - Recovering from a Loss of a System Critical Data File
In this exercise, you will learn the following about recovering a system critical data file loss:
- Recovering a System Critical Data File Loss
When a system critical data file is lost, the kinds of recovery available depend on whether the mode of operation is ARCHIVELOG mode or NOARCHIVELOG mode. Oracle strongly recommends operating in ARCHIVELOG mode for any production database that is not read-only.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.