| |
GeekInterview.com > Interview Questions > Oracle > Backup and Recovery
| Print | |
| Question: What is Full Backup ?
Answer: A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter. |
| October 10, 2007 21:59:33 |
#7 |
| satyam_2007 |
Member Since: October 2007 Total Comments: 5 |
What is Full Backup ?
|
The first choice to be made is whether a backup should be of the entire database, or just a part of it.
A full backup is the is a backup of all Datafiles, control files and the spfile. Remember that as all multiplexed copies of the control files are identical, So, it is necessary to backup only one of them. We do not backup the on line Redo logs! Online redo logs are protected by multeplexing, and optionally by archiving. Also, note that only datafiles, for permanent tablespace can be backed up. The tempfiles used for your tablespace cannot be backed up by RMAN, nor they can be put into backup mode for an operating system backup.
A whole backup can be made with RMAN or with operating system commands, while the database is open or closed.
As a general rule, if your database is not running in archive log mode, you must always do whole backups.
Backup tools:
Backup can be made using straight forward operating system utilities, such as copy or winzip or windows, or cp, tar or cpi on Unix. However, oracle strongly recommends
the use of the Recovery manager(RMAN). RMAN is now its fourth generation originally introduced with release 8.0 and perfectly functional then and it has been substantilally enhanced through 8i,9i and 10G. |
| |
Back To Question | |
