This is the script I use to backup with rman and backup and delete
archive logs:
run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=PRD1,OB2BARLIST=PrdPrd1rman)';
backup incremental level <incr_level> filesperset 1
format 'PrdPrd1rman<PRD1_%s:%t:%p>.dbf'
database
include current controlfile
;
sql 'alter system archive log current'
;
backup archivelog all not backed up 2 times filesperset 1
format 'PrdPRD1rman<PRD1_%s:%t:%p>.dbf'
;
delete archivelog until time 'sysdate - 8' backed up 2 times to sbt_tape
;
}
This goes to tape not disk. format is specified seperately for db backup
and archive logs.
filesperset =1 may be overkill, but is supposed to give faster restore.
The default is all files backedup are put in one big file.
I make sure the archive logs are backed up twice before I delete them
and keep 8 days worth online.
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Boog Boog Jean Michel
[mailto:oracledba-ezmlmshield-x85243682.[Email address protected]
Sent: Friday, September 10, 2004 3:15 AM
To: LazyDBA Discussion
Subject: RMAN BACKUP! NEED A HELP
Hi, Everybody
I use RMAN to backup my database. The command i specifie after been
connected to RMAN is the following:
BACKUP DATABASE FORMAT '/mydirectory/%U' PLUS ARCHIVELOG
I notice that the archivelog backup set is created under
/oracle/oracle9204/dbs/ while the datafile backup set is created under
/mydirectory/.
How can i do to enable RMAN to create the Archivelog backup set under
/mydirectorie as the datafilebackupset?
Any idea will be highly appreciated
Thanks for your help
Jean Michel BOOG BOOG
GEA
12, Chemin Malacher
ZIRST B.P. 85
38243 Meylan Cedex
* Jm.[Email address protected]
* +33 (0)4 7690 7272, Fax: +33 (0) 4 7641 0083
--------
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