Question: I need to restore my Oracle
database, yet I find lots of methods described in the
documentation. How do I know the proper way to restore
my Oracle database?
Answer: The answer to when to restore your
Oracle database depends upon the way that you are taking
backups of the database and how you are managing your
archived redo logs.
1: RMAN: You use the Recovery Manager
to restore the Oracle database files and redo logs.
2: Recover command: You manually restore the
data files from a (hot or cold) backup and manually apply
the archived redo logs with the recover command
Recovery of your Oracle Database with
This section is about using the
backups you made earlier in this chapter, and recovering
your database with them.
Recovery is one of the most complex
Oracle topics. This section addresses basic recovery
scenarios. Before you can restore your database using RMAN,
the following needs to be properly in place (this assumes a
full system loss):
* The operating system must be
* The Oracle software must be
* The RMAN backup files must be
* You must create the file systems
that the database files will be restored to.
Once these pieces are in place you
can restore your database. In the event of a full system
loss you will need to replace:
* The SPFILE
* The Control File
* The database datafiles
If the SPFILE or control file is
intact, you will not need to replace that component. The
following sections walk you through each restore step. We
assume you have followed the backup procedures earlier in
this chapter, including the automated backup of SPFILES and
control files. Please see these detailed notes
restoring an Oracle database with RMAN.
You can use
manual recovery of the Oracle database using OS file
related notes on restoring
your Oracle database: