Home » RDBMS Server » Backup & Recovery » RMAN Fails to backup control file  () 1 Vote
icon8.gif  RMAN Fails to backup control file [message #120479] Fri, 20 May 2005 01:57 Go to next message
lokdaf
Messages: 4
Registered: May 2005
Location: South Africa
Junior Member
I've configured RMAN on a database. The backup succeeds in the datafiles but it seems to fail when getting to the control file:

Starting backup at 20-MAY-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=D:\ORACLEDB\HWDB\HW_OBJECTS_1.DBF
input datafile fno=00003 name=D:\ORACLEDB\HWDB\HW_CONTENTS_1.DBF
input datafile fno=00004 name=D:\ORACLEDB\HWDB\HW_INDEXES_1.DBF
input datafile fno=00001 name=C:\ORACLE\ORADATA\HWDB\SYSTEM01.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\HWDB\UNDOTBS01.DBF
input datafile fno=00009 name=D:\ORACLEDB\ELSDB\WBT.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\HWDB\INDX01.DBF
input datafile fno=00008 name=C:\ORACLE\ORADATA\HWDB\USERS01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\HWDB\TOOLS01.DBF
input datafile fno=00010 name=D:\ORACLEDB\ECSDB\ECS.MDF
channel ORA_DISK_1: starting piece 1 at 20-MAY-05
channel ORA_DISK_1: finished piece 1 at 20-MAY-05
piece handle=D:\BACKUPS\DBS\HW_DF558775195_S32_S1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 20-MAY-05

Starting Control File and SPFILE Autobackup at 20-MAY-05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10038: database session for channel ORA_DISK_1 terminated unexpectedly

Any suggestions?
Re: RMAN Fails to backup control file [message #120515 is a reply to message #120479] Fri, 20 May 2005 05:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is this an reproducible error?
Please post post your oracle version/OS version and RMAN COnfiguration ( issue this. RMAN> show all;)
Are you in catalog mode or nocatalog mode.
Re: RMAN Fails to backup control file [message #120540 is a reply to message #120515] Fri, 20 May 2005 06:39 Go to previous messageGo to next message
lokdaf
Messages: 4
Registered: May 2005
Location: South Africa
Junior Member
I have created a catalog for backup and recovery on a different server than the database. I'm running the RMAN backup utility from the machine contraining the target database.

Running: Oracle version: 9.2.0.6. Down below is the consol information with the 'Show all' dump.

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\Administrator>rman

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> connect catalog RMAN/RMAN@RMAN

connected to recovery catalog database

RMAN> connect Target RMAN/RMAN@HWDB

connected to target database: HWDB (DBID=1318618214)

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "D:\Backups\DBs\
hw_cf%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 CHANNEL DEVICE TYPE DISK FORMAT "D:\Backups\DBs\hw_df%t_s%s_s%p";
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFHWDB.ORA';
# default

RMAN>
Re: RMAN Fails to backup control file [message #120564 is a reply to message #120540] Fri, 20 May 2005 08:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems to be a pretty standard procedure.
Is this error reproducible?
Unfortunately the RMAN errors listed is not giving much information.
Is there any coredumps / trace file generated alongwith?

did you,Try increasing the auto allocation of channels ( atleast 2 two)?

Probably the OSS should look into this.
Re: RMAN Fails to backup control file [message #120713 is a reply to message #120564] Mon, 23 May 2005 03:04 Go to previous messageGo to next message
lokdaf
Messages: 4
Registered: May 2005
Location: South Africa
Junior Member
I've increased the channels to 2. Still no success. There is no valuable information in the trace files. It indicates that the control file backups are started and then no information is supplied in addition.

I've I switch off the control file autobackup feature, and just backup the control file by its own, do you recon I could still recover the database successfully?

Re: RMAN Fails to backup control file [message #120714 is a reply to message #120713] Mon, 23 May 2005 03:37 Go to previous messageGo to next message
lokdaf
Messages: 4
Registered: May 2005
Location: South Africa
Junior Member
I've changed the double quotes to single quotes on the following configuration:

Previous setting
----------------
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "D:\Backups\DBs\hw_cf%F";

New setting
-----------
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\Backups\DBs\hw_cf%F';

I figured this out by clearing all my ControlFile configurations first. This successfully backed up the DB.

Thanks

[Updated on: Mon, 23 May 2005 03:38]

Report message to a moderator

Re: RMAN Fails to backup control file [message #120738 is a reply to message #120714] Mon, 23 May 2005 07:55 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
appreciate the update.
Previous Topic: archive logs don't appear
Next Topic: recovering tablespace files
Goto Forum:
  


Current Time: Fri Mar 29 02:28:12 CDT 2024