Home » RDBMS Server » Backup & Recovery » Incremental backup
Incremental backup [message #149019] Tue, 29 November 2005 13:36 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
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 Go to previous message
Mahesh Rajendran
Messages: 10706
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

Previous Topic: 9i windows rollback segment file cannot be read urgent problem
Next Topic: Incremental Backup
Goto Forum:
  


Current Time: Thu Dec 01 14:19:00 CST 2022