OraFAQ Forum: Backup & Recovery » incremental vs. archive logs

Home » RDBMS Server » Backup & Recovery » incremental vs. archive logs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

incremental vs. archive logs [message #261072]

Tue, 21 August 2007 14:04

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.

Code: [Select all] [Show/ hide]

rman> BACKUP database PLUS archivelog INCREMENTAL LEVEL 1;

(not sure if the syntax is quite right there)

vs.

Code: [Select all] [Show/ hide]

rman> BACKUP archivelog ALL NOT BACKED UP;

Thanks!

Report message to a moderator

Re: incremental vs. archive logs [message #261086 is a reply to message #261072]

Tue, 21 August 2007 15:00

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.

Report message to a moderator

Re: incremental vs. archive logs [message #261090 is a reply to message #261086]

Tue, 21 August 2007 15:27

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!

Report message to a moderator

Re: incremental vs. archive logs [message #261094 is a reply to message #261090]

Tue, 21 August 2007 15:51

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Code: [Select all] [Show/ hide]

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

Code: [Select all] [Show/ hide]

rman> BACKUP archivelog ALL NOT BACKED UP;

I would refer this one.^^^

Report message to a moderator

Re: incremental vs. archive logs [message #261097 is a reply to message #261090]

Tue, 21 August 2007 16:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

In addition to what DreamzZ demonstrated, you can also consider setting OPTIMIZATION ON.

Report message to a moderator

Previous Topic:	ORA-00280..........
Next Topic:	RMAN backup level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 21:36:04 CDT 2025