Performing Oracle User-Managed Database Recoveries - OCP: Oracle Database 12c Administrator Certified Professional - page 94

■ Oracle Database parameter file
■ Oracle Database data files
■ Backup control file or CREATE CONTROLFILE command ready to run
The procedure to fully restore your database is as follows:
1. Create any new directories required.
2. Restore the Oracle software.
3. Restore or recreate the Oracle networking parameter files.
4. Restore the Oracle parameter file.
5. Rebuild the Oracle password file if required.
6. Restore the Oracle Database data files.
7. Start up the database in mount mode.
8. Recover the database using the procedure outlined in the section titled “Recovering
from Loss of All Control Files.”
Summary
As you can see, backup and recovery in Oracle can be a big deal. There are a number of
different situations you will find yourself in. Sometimes these situations take some deep
thinking to get out of them. Often, understanding how Oracle actually works will help
guide you through the problem and find a solution.
The Oracle 12 c OCP exam contains a number of recovery-related questions, so you will
want to know this stuff well. You should also work through the different exercises so that
you understand what to do in different situations. In this chapter, we discussed a number
of recovery cases:
■ NOARCHIVELOG recovery
■ ARCHIVELOG recovery
■ Point-in-time recoveries
■ Special recovery cases
It is probably clear to you that recovery in Oracle can be quite complex. It becomes even
harder when you are actually doing it under the gun, when people are breathing down your
neck to get that database up.