Home » RDBMS Server » Backup & Recovery » RMAN script
RMAN script [message #255295] Tue, 31 July 2007 05:29 Go to next message
Messages: 71
Registered: July 2007
Location: chennai

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

I tried using this script :
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...

Re: RMAN script [message #255432 is a reply to message #255295] Tue, 31 July 2007 18:32 Go to previous message
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:

Current Time: Sun Oct 23 04:40:56 CDT 2016

Total time taken to generate the page: 0.10562 seconds