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?



Oracle LazyDBA home page