Backup and Recovery - What is Full Backup ?

GeekInterview.com > Interview Questions > Oracle > Backup and Recovery

Go To First | Previous Question | Next Question

Backup and Recovery | Question 5 of 42

What is Full Backup ?

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.

Total Answers and Comments: 9

Last Update: September 10, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: devesh

If you are using the Rman for backup then in Rman full backup means Incremental backup on 0 level.

Above answer was rated as good by the following members:
lakunwa, Kelvin Pang

January 04, 2006 02:54:39

CMANNE

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.

Is this answer useful? Yes | No

January 20, 2006 10:39:48

devesh

RE: What is Full Backup ?

If you are using the Rman for backup then in Rman full backup means Incremental backup on 0 level.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 16, 2006 12:45:56

Nathaniel Edwin

RE: What is Full Backup ?

hi...The online redolog files cannot be backup. Only archival files can be backup. otherwise the offline logfiles can be backup.

Is this answer useful? Yes | No

April 19, 2006 19:27:20

monica choudhury

RE: What is Full Backup ?

Plese give the latest update in software specially in oracle and what course one can do in oracle in order to get an easy job.

Is this answer useful? Yes | No

June 24, 2006 05:15:59

Niranjan

RE: What is Full Backup ?

SO is this same as cold backup . I have taken coldbackup of systems when i bring down the database for copying all the datafiles and the control files.

Is this answer useful? Yes | No

September 20, 2007 00:55:27

Mohammed Abdul Afroze

RE: What is Full Backup ?

A full backup is an operating system backup taken while database is shutdown. And the database may (or) may not be in archivelog mode.

Is this answer useful? Yes | No

October 27, 2007 21:59:33

satyam_2007

Member Since: October 2007 Contribution: 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.

Is this answer useful? Yes | No

August 23, 2008 11:33:55

oracle56

Member Since: August 2008 Contribution: 2

RE: What is Full Backup ?

Full backup means it having datafiles controlfile and parameter file.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 09, 2009 10:54:30

oracleofdelphi

Member Since: September 2009 Contribution: 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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank