Database Reference
In-Depth Information
Figure 10-4: Zoomed area of Figure 10-1 with focus on User-Managed
Complete Recovery. There are two different ways to do such type of
Recovery: ARCHIVELOG mode, NOARCHIVELOG mode. In
ARCHIVELOG mode, there will be Archiver process whose job is to
archive Redo Log files before they get over written by the Redo Log
writer process (LGWR). The data entered/changed after the last backup
will not be recovered in NOARCHIVELOG mode whereas no data will
get lost if you are running Oracle server in ARCHIVELOG mode.
User-Managed Complete Recovery in NOARCHIVELOG
Mode
In NOARCHIVELOG mode the recovery is very simple. All you
have to do is to restore the database files from your backup to the
original location and start the database.
Let's suppose one of your data file got corrupted. The time you
try to start the Oracle Instance, it will give you an error. In this
case shut down the database. Restore all the data files; redo log
files and control file back to their original location from your last
whole/complete cold backup.
Search WWH ::
Custom Search