RMAN delete BEFORE backup
From: Alan Sterger <asterger_at_earthlink.net>
Date: Mon, 07 Feb 2011 13:22:08 -0500
Message-ID: <4D503850.5060202_at_earthlink.net>
Hello Listers,
Date: Mon, 07 Feb 2011 13:22:08 -0500
Message-ID: <4D503850.5060202_at_earthlink.net>
Hello Listers,
Using Oracle 9i RMAN template below. Level 0 executes on Sunday, Level 1 the rest of the week.
Client has limited disk space. Can the 'delete input' and/or 'delete obsolete' be executed BEFORE the two 'backup' commands?
Are there other tweaks that can be applied? Got a better script?
run {
allocate channel Channel1 type disk format 'F:\orabackups\%d_%s_%p_%t';
backup incremental level 1
( database include current controlfile );
backup ( archivelog all delete input );
}
allocate channel for maintenance device type disk;
delete obsolete device type disk;
Cheers,
Alan Sterger
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 07 2011 - 12:22:08 CST