Re: Restore with new name

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/ch14.htm
Received on Mon Feb 14 2005 - 12:34:24 CST