Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RMAN 9i: Resetting/Clearing name for controlfile backup

RMAN 9i: Resetting/Clearing name for controlfile backup

From: Alexander Skwar <alexander_at_skwar.name>
Date: Tue, 10 Jul 2007 16:26:39 +0200
Message-ID: <1240493.UQgxmLvFx2@kn.gn.rtr.message-center.info>


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 Received on Tue Jul 10 2007 - 09:26:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US