Kanwar, Retention policy is different from what you are actually asking now. Retention policy makes the backups state in the catalog/controlfile as 'obsolete' , prior to retention period , but, doesn't actually delete them until you execute delete obsolete command from the RMAN. See if the following can fit into your requirement: BACKUP ARCHIVELOG ALL NOT BACKUPED UP 1 TIMES; DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'sysdate-16/24'; Jaffar On 6/4/07, Kanwar Plaha <kanwar.plaha@xxxxxx> wrote:
That's what we are currently doing ... ... backup archivelog all delete input; However, our requirement is that the logs should be kept on disk for (say) 13 hours. How do I do that from within RMAN. Even if more than one command is required, its alright. On Mon, 4 Jun 2007 04:41:55 pm Syed Jaffar Hussain wrote: > Kanwar, > > If you afraid that archivedlogs will fill up the directory, why don't > create a script and run the script every 6 hrs. to backup the archived logs > and delete the backed archivelogs from disk. > > Jaffar > > On 6/4/07, Kanwar Plaha <kanwar.plaha@xxxxxx> wrote: > > Hi, > > Due to a backup clashing with one of the automated cloning script for a > > database, the retention policy > > for archivelogs needs to be 12-13 hours. How can I set this? Setting > > retention to 1 day (which I believe is > > the mininum) is too long and I risk the archivelog directory filling up. > > > > The database version is 9.2.0.6. > > > > Thanks, > > Kanwar > > -- > > //www.freelists.org/webpage/oracle-l
-- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."