Extract from the RMAN User's Guide (Oracle 9iR2) - hope this helps!
Configuring the Control File Autobackup Format
By default, the format of the autobackup file for all configured devices is the substitution variable %F. This variable format translates into c-IIIIIIIIII-YYYYMMDD-QQ, where:
IIIIIIIIII stands for the DBID. The DBID is a unique numerical identifier for the database. The DBID is printed in decimal so that it can be easily associated with the target database.
YYYYMMDD is a time stamp in the Gregorian calendar of the day the backup is generated
QQ is the sequence in hexadecimal number that starts with 00 and has a maximum of FF (256)
You can change the default format by using the following command, where deviceSpecifier is any valid device such as DISK or sbt, and 'string' contains the variable %F and is a valid handle for the specified device:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE deviceSpecifier TO 'string';
For example, you can run the following command:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '?/oradata/cf_%F';
--------------------------------------------------------------------------------
Note:
The format string must contain the %F variable. If the format string does not contain the %F variable, then RMAN issues an error.
--------------------------------------------------------------------------------
You can return the default autobackup format to %F by running this command, where deviceSpecifier is any valid device such as DISK or sbt:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE deviceSpecifier CLEAR;
The SET CONTROLFILE AUTOBACKUP FORMAT command, which you can specify either within a RUN block or at the RMAN prompt, overrides the configured autobackup format in the current session only. The order of precedence is:
SET CONTROLFILE AUTOBACKUP FORMAT (within RUN)
SET CONTROLFILE AUTOBACKUP FORMAT (at RMAN prompt)
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT
*********** ORIGINAL MESSAGE ***********
On 10/09/2004 at 4:22 PM Boog Boog Jean Michel wrote:
Coul you tell me how i can change the default location of the control file
snapshots?
Thanks for your help
-----Message d'origine-----
De : Paul Murgatroyd [mailto:[Email address protected]
Envoyé : vendredi 10 septembre 2004 16:06
À : Boog Boog Jean Michel
Objet : Re: RMAN BACKUP! NEED A HELP
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Not too sure what is going on here - what version of RMAN are you using?
If you use "plus archivelog" as part of the database format, the archive
logs are included in the database backup sets. Are you sure it is not just
the controlfile snapshots you are seeing in $ORACLE_HOME/dbs?
You could choose to backup the archivelogs explicitly in their own backup
set, and also change the default location for control file snapshots.
If you use the Recovery Catalog, check the catalog to see where the backup
sets were actually written to.
Paul
*********** ORIGINAL MESSAGE ***********
On 10/09/2004 at 10:14 AM Boog Boog Jean Michel wrote:
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