Answer Detail: RE: What is Full Backup ?

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

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.

September 09, 2009 10:54:30	#9
oracleofdelphi	Member Since: September 2009 Total Comments: 6
RE: What is Full Backup ?
When using logical backup if we give full=y - that is a full backup. When using RMAN by default it takes full backup and image copy is also full backup since it contains all blocks used and not used ones. But in RMAN terms full backup is part of incremental backup strategy level 0 is full backup and rest is incremental. We can make image copy as part of incremental backup by using level 0 keyword. The difference between full and whole backup is that full contains all the used locks whereas whole means all datafiles and control file backup.

Back To Question