Re: RMAN restore - what am I doing wrong?

From: Steve Baldwin <stbaldwin_at_multiservice.com>
Date: Wed, 19 Aug 2009 15:39:55 +1000
Message-ID: <D9786A74-94CF-4E08-93A5-3158C73735A9_at_multiservice.com>

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_at_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_at_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

Received on Wed Aug 19 2009 - 00:39:55 CDT