RMAN problem

From: <DMina_at_laiki.com>
Date: 18 Jan 2006 08:03:03 -0800
Message-ID: <1137600183.835408.28050@g43g2000cwa.googlegroups.com>

Hello people,

I have this strange behaviour on one of my Oracle9i databases. I am trying to backup the database though RMAN (using controfile). I am shutting the following:

shutdown immediate;
startup force dba;
shutdown immediate;
startup mount;
BACKUP FULL DATABASE INCLUDE CURRENT CONTROLFILE FORMAT = 'D:\DB_cold_%U.RBK';
alter database open;

But i get the following error:

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

RMAN-03002: failure of backup command at 01/18/2006 17:26:07 RMAN-06056: could not access datafile 14

The datafile 14 if you look into the alert log and the trace that is produced refers to:

ORA-01157: cannot identify/lock data file 14 - see DBWR trace file
ORA-01110: data file 14: 'D:\ORACLE\ORADATA\ONLDB1\ONLINE02-02.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

The name if the file if you look includes a '-'. I though that might be the problem and i changed the name of the file where instead of '-' i put '_'.
Run the backup again but i got the same error, which refers to datafile 14 and the name includes the '-' instead of '_'

Any ideas?

Thanks Received on Wed Jan 18 2006 - 10:03:03 CST