Database Reference
In-Depth Information
complete we can open the database using the following
statement.
ALTER DATABASE OPEN;
If the database was running under ARCHIVELOG mode then
first we have restore the database files and then issue the
RECOVER DATABASE statement so that all the redo logs will
be applied to the data files. Here “redo logs applied” means that
all those redo logs that were archived by the archiver process.
The database has to be in MOUNT state. Then start and connect
the RMAN with the target database. The following would be
used at the RMAN prompt to recover the database that was
running under ARCHIVELOG mode before the failure detected.
RMAN> RUN {
ALLOCATE CHANNEL ch1 TYPE DISK;
RESTORE DATABASE;
RECOVER DATABASE;
}
Once the recover process complete, open the database using the
following statement.
ALTER DATABASE OPEN;
It's recommended that at this point shutdown the database
normal and reopens it to make sure that the restore process
completed successfully. It everything went well the database will
open with no error.
User-Managed Incomplete Recovery
When the database was running under ARCHIVELOG mode all
the redo log files archived before they gets over written. If
something wrong happens to the database then we first have to
restore the files and then use the RECOVER DATABASE
Search WWH ::
Custom Search