RMAN Fails to backup control file [message #120479] |
Fri, 20 May 2005 01:57 |
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 #120540 is a reply to message #120515] |
Fri, 20 May 2005 06:39 |
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 #120713 is a reply to message #120564] |
Mon, 23 May 2005 03:04 |
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 |
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
|
|
|
|