Database Reference
In-Depth Information
Recovering the database running under NOARCHIVE mode is
very simple. All you have to make sure that the target database is
first shunt down NORMAL, IMMEDIATE or
TRANSACTIONAL. Then start the instance with database
mounted on it by first connecting as SYSDBA. Then run RMAN
and issue the RESTORE DATABASE command.
Figure 10-6: Zoomed area of Figure 10-1 with focus on RMAN based
complete recovery. There are two different ways to do such type of
recovery: ARCHIVELOG mode, NOARCHIVELOG mode. No
recovery of database is needed if it was running under
NOARCHIVELOG mode. Two key statements for RMAN recovery
process are RESTORE DATABASE and RECOVER DATABASE.
For the database in ARCIVELOG mode, we have to first restore the
database files and then start the recovery process. In the recovery
process, all the redo logs will get applied to the database.
Since the database was running under NOARCHIVELOG mode
that why no recovery is need. The following RMAN command
can be used to restore the database.
RMAN> RUN {
ALLOCATE CHANNEL ch1 TYPE DISK;
RESTORE DATABASE;
}
This command will restore all the database files from the backed
up location to original position. Once the restore process
Search WWH ::
Custom Search