Home » RDBMS Server » Backup & Recovery » incremental vs. archive logs
incremental vs. archive logs [message #261072] Tue, 21 August 2007 14:04 Go to next message
clintonf
Messages: 82
Registered: May 2006
Member
Hi all,

A quick RMAN question for you.

Is/are there any advantage(s) of performing an incremental backup vs. backing up un-backed up archive logs?

ie.
rman> BACKUP database PLUS archivelog INCREMENTAL LEVEL 1;

(not sure if the syntax is quite right there)

vs.
rman> BACKUP archivelog ALL NOT BACKED UP;


Thanks!
Re: incremental vs. archive logs [message #261086 is a reply to message #261072] Tue, 21 August 2007 15:00 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
rman> BACKUP database PLUS archivelog INCREMENTAL LEVEL 1;


I guess there's no such a command for archive log with database backup.

Quote:
rman> BACKUP archivelog ALL NOT BACKED UP;



This will backup all your archivelogs not backup since last backup.
Re: incremental vs. archive logs [message #261090 is a reply to message #261086] Tue, 21 August 2007 15:27 Go to previous messageGo to next message
clintonf
Messages: 82
Registered: May 2006
Member
DreamzZ wrote on Tue, 21 August 2007 13:00
Quote:
I guess there's no such a command for archive log with database backup.


Are you saying that this command doesn't exist or that you can't include archivelogs in such a command?

Which command would be preferable for bringing your database backup up-to-date? As far as I can tell they would both do the same thing.

Would the second command require that you have the archivelog files as well? Then it would seem to me that the first command would be better.

Thanks!
Re: incremental vs. archive logs [message #261094 is a reply to message #261090] Tue, 21 August 2007 15:51 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
RMAN> BACKUP INCREMENTAL LEVEL 1  database PLUS archivelog;


Starting backup at 21-AUG-07
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=501 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set



rman> BACKUP archivelog ALL NOT BACKED UP;


I would refer this one.^^^
Re: incremental vs. archive logs [message #261097 is a reply to message #261090] Tue, 21 August 2007 16:32 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In addition to what DreamzZ demonstrated, you can also consider setting OPTIMIZATION ON.
Previous Topic: ORA-00280..........
Next Topic: RMAN backup level
Goto Forum:
  


Current Time: Tue Dec 06 12:09:10 CST 2016

Total time taken to generate the page: 0.19141 seconds