| Difference between whole and full backup [message #297776] |
Sun, 03 February 2008 11:28  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
When I was reading through 10g Backup and Recovery Bascis Guide I came across the term Full Backup .
I searched in the net for the exact definiton of that term since I was always confusing it with whole backup . In one of the forums the same question was raised and the reply was
| Quote: | Whole backup
Backs up all database files, but this backup is not cataloged, which means that you cannot use it as a reference backup for an incremental backup with RMAN.
Full backup
Backs up all database files. You can perform a full backup with or
without RMAN. If you do not use RMAN, then RMAN is called separately to catalog the backup. This means that you can use this backup as a reference backup for an incremental backup with RMAN.
|
But the reply was not convincing since in the Oracle Documentation it was clearly mentioned as
| Quote: | A level 0 incremental backup is physically identical to a full backup. The only difference is that the level 0 backup is recorded as an incremental backup in the RMAN repository, so it can be used as the parent for a level 1 backup.
|
Can anyone explain me the difference between these two ?
|
|
|
|
|
|
| Re: Difference between whole and full backup [message #301490 is a reply to message #297782] |
Wed, 20 February 2008 18:53  |
aldomenico
Messages: 1
Registered: February 2008
Location: Fort Lauderdale, USA
|
Junior Member |
|
|
Just to add to what has been said already:
In a Full backup all datafile blocks are backed up. As it was said already, a full backup applies to one or more datafiles and up to all of them (database). The opposite of a full backup is an incremental backup. An incremental backup level 0 backs up all datafile blocks that have ever been used, and an incremental level 1 backs up anything that has changed afterwards. One can do full backups with either RMAN or O/S utilities.
A whole backup is a full backup of all datafiles plus the controlfile. The opposite of a whole backup is a partial backup. A partial backup is a full backup of a subset of datafiles.
Hope that clears it out.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
