Here is a piece of the script I use;


BACKUP_COMMAND="configure backup optimization on;backup ( archivelog until time 'SYSDATE-$DAYSOLD' del
ete input );"

#debug on - Place this on the line after the 'run {'
#
rman msglog \"${RMANMSGLOG}\" << ENDRMAN2 2>&1 | tee -a ${DLOG}
connect target ${AUTH}
connect rcvcat ${RMANAUTH}
set snapshot controlfile name to '$snapshot_cf';
run {
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '/export01/${ORACLE_SID}/${NODE}_%d_al_t%t_s%s_p%p';
set command id to 'rman';
sql 'alter system archive log current';
$BACKUP_COMMAND
}
ENDRMAN2

David Riley
IKON The Way Business Gets Communicated
IKON Data Center
1738 Bass Rd.
Macon, GA 31210
Voice: 478-238-7560
Fax: (912)238-7676
Email; [Email address protected]



-----Original Message-----
From: Bob Kimble
[mailto:oracledba-ezmlmshield-x49143264.[Email address protected]
Sent: Thursday, May 05, 2005 11: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