Re: RMAN restore - what am I doing wrong?
- From: Steve Baldwin <stbaldwin@xxxxxxxxxxxxxxxx>
- To: oracle_l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Aug 2009 15:39:55 +1000
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.695186369Strangely, 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