Databases Reference
In-Depth Information
do not exist on disk, then RMAN will attempt to retrieve them from a backup set. If you want to apply redo as part of
an incomplete database recovery, the following conditions must be true:
•
Your database must be in archivelog mode.
•
You must have a good backup of all data files.
•
You must have all redo required to restore up to the specified point.
When performing an incomplete database recovery with RMAN, you must have your database in mount mode.
RMAN needs the database in mount mode to be able to read and write to the control file. Also, while in mount mode
the database is not open for general use. Any data files in need of recovery cannot be open for regular user transaction
processing while being recovered. Hence the need for the database to be in mount mode.
Not
■
after incomplete database recovery is performed, you are required to open your database with the
alter
database open resetlogs
command.
Depending on your scenario, you can use RMAN to perform a variety of incomplete recovery methods. The first
recipe in this chapter discusses how to determine what type of incomplete recovery to perform.
Determining Type of Incomplete Recovery
Problem
You want to perform an incomplete recovery but don't know which method to use.
Solution
Use Table
12-2
to determine which type of incomplete recovery to perform.
Table 12-2.
Deciding Type of Incomplete Recovery to Perform
Situation
Instructions Location
You know approximately what time you want to stop the recovery process.
Recipe 12-2
You know the particular log file for which you want to stop the recovery process.
Recipe 12-3 or Recipe 12-4
You know the SCN at which you want to end the recovery process.
Recipe 12-6
You want to restore to a defined restore point.
Recipe 12-7
You want to restore one tablespace to a point in time.
Recipe 12-10
You want to restore individual tables to a point in time in the past.
See Chapter 13 for restore table,
flashback table to before drop, and
flashback table to before SCN.
You want to restore and recover a subset of your database's data files.
Recipe 12-11
You have enabled the flashback database feature and want to flash back your
database.
Chapter 13
You have a Data Pump export and want to restore objects to a point in time in
the past.
See Oracle Database Utilities guide
for details on how to use Data Pump.
