Hi David You spoilt all the fun :-). I was curious if anything else worked :-) regards Hrishy --- David Barbour <david.barbour1@xxxxxxxxx> 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@xxxxxxxxxxx> 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/ -- //www.freelists.org/webpage/oracle-l