OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN script

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

RMAN script [message #255295]

Tue, 31 July 2007 05:29

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

hi,

I have taken full backup yesterday including archivelog files upto sequence# 2848.Now i need to take incremental backup of database plus archivelog files from that sequence#2848 to till now.
Oracle version :10.2.0
WindowsNT
I tried using this script :
Run
{
allocate channel c1 device type disk format='f:/backup/increment/Increment_bkp_Jul31/db_%U';
backup incremental level 1 database;
backup archivelog from sequence 2849;
}
Is there any other way? if ? guide me plz...

TIA,

Report message to a moderator

Re: RMAN script [message #255432 is a reply to message #255295]

Tue, 31 July 2007 18:32

ebrian
Messages: 2794
Registered: April 2006

Senior Member

RMAN can only create incremental backups of datafiles, not of archived redo log files. If your goal is to avoid unnecessary backups of archive logs (taking into account any retention policy and/or duplexing), you could set OPTIMIZATION ON and simply issue BACKUP ARCHIVELOG ALL;

You can also consider using DELETE [ALL] INPUT when you backup the archive logs.

[Updated on: Wed, 01 August 2007 03:27]

Report message to a moderator

Previous Topic:	raw disks v/s file system
Next Topic:	Duplex Backups

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 01:41:54 CDT 2025