| |
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. |
| January 01, 2006 02:54:39 |
#1 |
| CMANNE |
Member Since: Visitor Total Comments: N/A |
RE: What is Full Backup ?
|
| A full backup can be consistent and inconsistent backupsConsistent Bakup: When the database is down and the backup of the database taken using the operating system copy command. Most of the times the consistent backup would be taken when the database is not in archivelog mode and also the downtime won't affect the system. In this case one should backup datafiles, redolog files and controlfile.Inconsistent Backup: This type of backup is taken when the database is up and running and the individual tablespaces are kept in backup mode and the the datafiles are copied using the operating system copy command. The database should be in archivelog mode to take this sort of backup. In this case one should backup datafiles, archived redolog files and controlfile. |
| |
Back To Question | |
