Re: RMAN 9i: Resetting/Clearing name for controlfile backup

On Jul 10, 4:26 pm, Alexander Skwar <alexan..._at_skwar.name> wrote:
> Hello.
>
> In RMAN of Oracle 9i, I made a mistake when I set the name for the
> CONTROLFILE AUTOBACKUP FORMAT. What do I have to do, to "CLEAR" that
> value, so that I can start over again?
>
> I tried:
>
> RMAN> configure CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
>
> old RMAN configuration parameters:
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/backup/cf%F?;';
> RMAN configuration parameters are successfully reset to default value
>
> RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/backup/%d,cf,%Y%M%D,%s_%t,%p_%c,%F';
>
> old RMAN configuration parameters:
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/backup/cf%F?;';
> new RMAN configuration parameters:
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/backup/%d,cf,%Y%M%D,%s_%t,%p_%c,%F';
> new RMAN configuration parameters are successfully stored
>
> RMAN> backup datafile 3;
>
> Starting backup at 10-JUL-07
> using channel ORA_DISK_1
> channel ORA_DISK_1: starting full datafile backupset
> channel ORA_DISK_1: specifying datafile(s) in backupset
> input datafile fno=00003 name=/opt/apps/oracle/oradata/BNRTEST/cwmlite01.dbf
> channel ORA_DISK_1: starting piece 1 at 10-JUL-07
> channel ORA_DISK_1: finished piece 1 at 10-JUL-07
> piece handle=/tmp/backup/BNRTEST,data,20070710,30_627581829,1_1 comment=NONE
> channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
> Finished backup at 10-JUL-07
>
> Starting Control File and SPFILE Autobackup at 10-JUL-07
> piece handle=/tmp/backup/cfc-3007484779-20070710-05?; comment=NONE
> Finished Control File and SPFILE Autobackup at 10-JUL-07
>
> As you can see, the control file was backed up to
> "/tmp/backup/cfc-3007484779-20070710-05?;" which is not a name that I like.
> The "?" is not really a question mark, but some "strange" value:
>
> --($:~/Documents/Downloads/Unix/Oracle)-- ls -la /tmp/backup/cfc-3007484779-20070710-05*
> -rw-r----- 1 oracle dba 2375680 Jul 10 16:17 /tmp/backup/cfc-3007484779-20070710-05?;
>
> What do I have to do, so that RMAN accepts and uses the new value for
> CONTROLFILE AUTOBACKUP FORMAT?
>
> Thanks a lot,
>
> Alexander Skwar

You have to set the autobackup format to something *sensible*, which will actually get recognized by RMAN.
As there can be only one (1) autobackup controlfile backup set, all the formats above don't make any sense.
The only modifier which is allowed in a controlfile autobackup is %F. %F is the DBID followed by the date in YYYYMMDD format and a piece number.
That said, stop trying to do the impossible, reread the documentation to confirm my post and set it to /tmp/backup/%F.ctl

--
Sybrand Bakker
Senior Oracle DBA