Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!207.115.63.142.MISMATCH!newscon02.news.prodigy.com!newscon06.news.prodigy.com!prodigy.net!border1.nntp.dca.giganews.com!nntp.giganews.com!sn-xit-03!sn-xit-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Rman Restore
Date: Fri, 09 Sep 2005 20:24:20 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <qok3i15lp1vqi6uu46t1dl1e87ge0f6cb5@4ax.com>
Reply-To: sybrandb@hccnet.verwijderdit.nl
References: <1126275500.752747.97500@g43g2000cwa.googlegroups.com>
X-Newsreader: Forte Agent 3.0/32.763
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 40
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251195

On 9 Sep 2005 07:18:20 -0700, "Js" <jagjeet_malhi@hotmail.com> wrote:

>Hi,
>
>I have a tablespace of 10 gb with 1 datafile. I took the backup of this
>tablespace through rman using controlfile.
>
>--It was read only tablespace.
>
>Later I need this I restored it successfully from RMAN on a diff.
>location. -- I Need this for plug [ transport tablepsace ] into an
>other database.
>
>I used this
>
>run
>{
>set newname for datafile '/uu01/tbs.dbf' to '/uu02/tbs.dbf' ;
>restore tablespace tbs;
>}
>
>It restored it successfully.
>
>The same command I am using next day but It is giving error.
>
>can not identify file - ORA-19625 And it is giving the new file name
>where I restored it eariler.
>
>Can someone pls. comment.
>
>Thanks,
>Js

You did rename the datafile, didn't you, using the set newname
command.
You use the set newname command when you want your datafiles to end up
somewhere else.

--
Sybrand Bakker, Senior Oracle DBA