| 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,
|
|
|
|
| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
