Re: Restore with new name

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Tue, 15 Feb 2005 01:25:29 GMT
Message-ID: <Xns95FDB141E27B1SunnySD@68.6.19.6>

David Gray <police_at_spamcop.net> wrote in news:0ir111dqu8b8l38jk7cdkm7gb16n3nhl44_at_4ax.com:

> That's great thanks.  
> 
> One further question:  Am I going to have to change the location of
> redo logs, tablespaces & control files etc before mounting the DB?
> Reason I ask is that the test server only has one large disk and the
> files are spread out over several on a production box. 
> 
> Cheers
>      Dave. 
> 
> On Mon, 14 Feb 2005 17:57:42 GMT, Mark Bole <makbo_at_pacbell.net> wrote:
> 

>>David Gray wrote:
>>
>>> Hi all,
>>>
>>> Oracle 9i
>>> Windows advanced server 2000
>>>
>>> I would like to test if a cold backup of a 9i database is usable
>>> once restored. Once restored I would like the database to have a
>>> new name so that it does not interfere with the live instance.
>>>
>>> Very new to Oracle so don't really have a clue where to begin. The
>>> only parameter that's obvious is the db_name...
>>>
>>> Any or pointers on how begin greatly received.
>>>
>>> Cheers
>>> Dave.
>>
>>Check the documentation for the DBNEWID utility.
>>
>>http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch1
>>4.htm

>

http://www.dba-oracle.com/oracle_tips_db_copy.htm

Contrary to the website if/when the SID is changed via "SET DATABASE", then RESETLOGS is required.

HTH & YMMV! Received on Mon Feb 14 2005 - 19:25:29 CST