Re: Restore with new name

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 14 Feb 2005 21:26:07 GMT
Message-ID: <PH8Qd.4893$aW6.579@newssvr22.news.prodigy.net>

David Gray wrote:

> 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
>
>

One other comment, before someone else posts it:

Cold backups shouldn't be your first choice for disaster recovery. While I have no problem with user-managed backup and recovery, a better thing to do these days is use RMAN to manage your backup and recovery needs, possibly in conjunction with a physical standby database.

-Mark Bole Received on Mon Feb 14 2005 - 15:26:07 CST