Re: RMAN Duplicate Fails - Suggestions?

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Mon, 17 Mar 2008 16:30:56 +0000 (GMT)
Message-ID: <179661.89616.qm@web27801.mail.ukl.yahoo.com>

Hi David

You spoilt all the fun :-).

I was curious if anything else worked :-)

regards
Hrishy
--- David Barbour <david.barbour1_at_gmail.com> wrote:

> Thanks for the suggestions. Yeah, everything is a
> hot backup and my
> restores tend to be until specific times to
> correlate with our legacy
> systems. Ended up restarting (and completing) the
> restore. Went through
> 16 different variations with Oracle Support on this.
> We were using Metalink
> like IM. Guess the folks on that queue didn't have
> a lot of calls. Anyway,
> nothing worked. They're "intrigued" and have
> indicated they might do some
> further investigation and update the note.
>
> On 3/17/08, hrishy <hrishys_at_yahoo.co.uk> wrote:
> >
> > Hi
> >
> > How about slight modification to the Metalink
> script
> > with a connection to the catalog ?
> >
> > [code]
> > $ export ORACLE_SID=<auxiliary>
> > $ rman target / catalog rmanadmin/<password>@rcat
> >
> >
> > RMAN> run {
> > set until scn 1412841;
> > set newname for datafile n to
> '<newfilename_n>';
> > set newname for datafile n2 to
> '<newfilename_n2>';
> > ….etc
> > restore datafile n,n2…etc;
> > }
> >
> > [/code]
> >
> >
> >
> >
> >

>

---

> > Rise to the challenge for Sport Relief with Yahoo!
> For Good
> >
> > http://uk.promotions.yahoo.com/forgood/
> >
>

---

Rise to the challenge for Sport Relief with Yahoo! For Good

http://uk.promotions.yahoo.com/forgood/

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

Received on Mon Mar 17 2008 - 11:30:56 CDT