RE: RMAN error while backing up control file

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 30 Sep 2005 14:28:14 -0400
Message-ID: <01d101c5c5ec$b836f3d0$bb59000a@vttaxnet.tax.state.vt.us>

Have you looked for the control file backup and found it not there? Did you check for the snapshot control file? Is it in O_H/dbs with the name you gave it?

If it your autobackup controlfile that is missing, just do a controlfile backup to the directory where you put the autobackup controlfiles so you are sure to have a copy which knows about all of the backupsets and where the datafile backups are so you won't get stuck if you have to do a restore/recovery.

Regards,
Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fred Smith Sent: Friday, September 30, 2005 10:50 AM To: oracle-l_at_freelists.org
Subject: RMAN error while backing up control file

Hi all,
I keep getting a nagging RMAN error, perhaps someone out there can help.

My RMAN setup works great to backup the database, etc. .... but I tried to set it to "auto backup" the control file. However, everytime after a backup, when the "auto backup" starts, I get an error:

Starting Control File Autobackup at 29-SEP-05

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03015: error occurred in stored script full_bell1_nic_backup_plus_archlogs
RMAN-03002: failure of backup command at 09/29/2005 14:53:46 ORA-19715: invalid format for piece name

Here are my config settings:

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/xfer/rman_backups/bell1_nic/bell1_nic_control_files/ctl_file_%T_%U_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/xfer/oracle/app/oracle/product/920/dbs/snapcf_nic.f';

Any ideas why it won't successfully backup the controlfile??

Thanks,
-Fred S.

Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 30 2005 - 13:30:40 CDT