Incremental backup [message #149019] |
Tue, 29 November 2005 13:36 |
toshidas2000
Messages: 120 Registered: November 2005
|
Senior Member |
|
|
what is Incremental Backup and how do we do it, not using RMAN, general backup script.
If the database is not in archivelog mode, can we do incremental backup.
Thanks
Toshi
|
|
|
Re: Incremental backup [message #149020 is a reply to message #149019] |
Tue, 29 November 2005 13:38 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>If the database is not in archivelog mode, can we do incremental backup.
>>not using RMAN,
It is not possible.
Even if it would be possible, since the database is in noarchivelog mode, it would make absolutely NO sense.
[Updated on: Tue, 29 November 2005 13:42] Report message to a moderator
|
|
|
Re: Incremental backup [message #149023 is a reply to message #149020] |
Tue, 29 November 2005 13:50 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>> what is Incremental Backup
A backup of whatever changed , after the last backup.
RMAN does it in the lowest granularity. Blocks.
quoting documentation
Quote: | An incremental backup reads the entire file and then backs up only those data blocks that have changed since a previous backup. You can use RMAN to create incremental backups of datafiles, tablespaces, or the whole database. Note that RMAN can include a control file in an incremental backup set, but the control file is always included in its entirety--no blocks are skipped.
|
[Updated on: Tue, 29 November 2005 13:56] Report message to a moderator
|
|
|