Re: RMAN error while restoring datafiles

From: Shastry(DBA) <"Shastry>
Date: Fri, 11 Sep 2009 08:05:45 +0530
Message-ID: <5b294dab0909101935p8c80596u1616a732112f2fcc_at_mail.gmail.com>

Thanks everyone for their inputs and guidance so far. I am working with Unix team to get this mount options done and check again on my restore. Kevin,
Thanks, I did check and find none on two datafiles having the same name. But its a good catch if anyone is running a hotbackup and relax... until they get back a hot reply from users/application team on dataloss or corruption or failures in cloning.

Regards,
An :)

On Thu, Sep 10, 2009 at 7:17 PM, Kevin Lidh <kevin.lidh_at_gmail.com> wrote:

> When I've done duplications in the past, we've run into this error when
> the original database had two datafiles with the same name but in
> different directories. The db_file_name_convert was used to move things
> into the same directory. In this situation, we either over-wrote a
> datafile or we had this locking issue.
>
> So my short answer is to look at your file names.
>
> On Tue, 2009-09-08 at 07:09 +0530, Shastry(DBA) wrote:
> > Hello,
> >
> >
> > While restoring the datafiles using RMAN I am getting this below
> > error. FYI, I am using NFS filer for my restoration purpose due to
> > lack of space in local/SAN mount points. Guess this must be a RMAN
> > bug. Does anyone show light on this please?
> > I have a softlink pointing to NFS (/opt1 --> /backup/).
> >
> >
> > DB -9.2.0.7
> > RMAN -9i
> >
> >
> > using channel ORA_AUX_DISK_1
> > channel ORA_AUX_DISK_1: starting datafile backupset restore
> > channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup
> > set
> > restoring datafile 00001 to /opt1/app/TEST/oradata/system01.dbf
> > restoring datafile 00015 to /opt1/app/TEST/oradata/edi_1.dbf
> > RMAN-00571:
> > ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> > ===============
> > RMAN-00571:
> > ===========================================================
> > RMAN-03002: failure of Duplicate Db command at 09/07/2009 11:32:16
> > RMAN-03015: error occurred in stored script Memory Script
> > ORA-19504: failed to create file "/opt1/app/TEST/oradata/edi_1.dbf"
> > ORA-27086: skgfglk: unable to lock file - already in use
> > SVR4 Error: 46: No record locks available
> > Additional information: 8
> >
> >
> > Recovery Manager complete.
> >
> >
> > Thanks,
> > An
>
>

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

Received on Thu Sep 10 2009 - 21:35:45 CDT