Database Software

Hi all,

I'm playing around with RMAN on a test instance, and am trying to just restore and recover a datafile. I can't see what I'm doing wrong.

I've renamed the users01.dbf file like it is lost...

I get RMAN going...I do a startup mount;

When I try:

RMAN> sql "alter database datafile '/data1/oradata/testdb5/users01.dbf' offline";

sql statement: alter database datafile '/data1/oradata/testdb5/users01.dbf' offline
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 04/06/2009 16:13:28
RMAN-10015: error compiling PL/SQL program

Now....I did this with the number of the datafile, and it let me do the offine that way
RMAN> sql "alter database datafile 4 offline";

sql statement: alter database datafile 4 offline

But, I want to try it with the file name, and I can't understand why it is giving me an error.

Any suggestions?

TIA,

cayenne

Edited by: cayenne on Apr 6, 2009 2:01 PM