Re: RMAN restore - what am I doing wrong?

It turns out the problem was due to incorrect permissions on the backup files. Once I corrected them, everything was fine.


I must say, that was not the first thing that came to mind when I saw the error message :-).

creating datafile file number=1 name=+DATA/rac21d/datafile/system. 259.682280555
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/18/2009 03:20:17
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+DATA/rac21d/datafile/system.259.682280555'

How hard would it have been to have a message like 'No backup files found' or something like that?

Thanks to all for your help.

Steve

On 19/08/2009, at 5:51 AM, Steve Baldwin wrote:

Thanks Robert. The directory doesn't exist. I didn't think it needed to as it would create directories as required. It certainly did that when it restored the control file.

(System B)
[oracle@lwdbc21 ~]$ asmcmd
ASMCMD> ls
DATA/
FRA/
ASMCMD> ls data
RAC21D/
ASMCMD> ls data/rac21d
CONTROLFILE/
ASMCMD> ls data/rac21d/controlfile
current.256.695186369

Strangely, rman says it restored the spfile but there is no spfile in ASM. From system A ...

[oracle@msdbc21 ~]$ asmcmd
ASMCMD> ls data
RAC21D/
ASMCMD> ls data/rac21d
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfilerac21d.ora

Not sure if that is significant.

Thanks again,

Steve

------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email.

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


Other related posts: