I'm really not sure and can't test right now, but you might backup the
archivelogs with its own command -- not part of the database backup.

backup archivelog all delete input until time 'sysdate - 7';

Maybe the "...until time..." part doesn't work as part of the regular backup
command. Sounds silly, but it could be.

-----Original Message-----
From: Bob Kimble
[mailto:oracledba-ezmlmshield-x49143264.[Email address protected]
Sent: Thursday, May 05, 2005 8:47 AM
To: LazyDBA Discussion
Subject: RMAN Question on delete input for Archivelogs

We are just setting up RMAN for our 9.2.0.6 database. We are on Solaris 9.

We backup to tape using Legato NMO. I want to use the backup command with
the 'plus archivelog' syntax as I think this is the best way to do the full
backup, but I also want to manage the archivelog deletion like the "backup
archivelog all delete input until time 'sysdate - 7';" command to keep 7
days worth of archivelogs on disk instead of backing them up to tape then
deleting the disk copies immediately. It would be great if the following
command worked:
"backup full format 'full_%d_%u'(database) plus archivelog delete input
until
time 'sysdate -7';"
but this does not work - it fails with a syntax error RMAN-01005. Is there
a way to accomplish what I am trying to do in RMAN?




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page