Re: need to recreate database

From: <Witold.Iwaniec_at_atl.bluecross.ca>
Date: Wed, 11 Jul 2001 05:56:33 -0700
Message-ID: <F001.00346D38.20010711051634@fatcity.com>

Lyuda

That's not terribly difficult and you mentioned registry so I guess it is NT. Make sure the files were copied after the original database was shut down. The easiest way would be to reinstall Oracle and create the default database with the same SID as your original database (maybe you already have it done). It will create the required services, generate the directory tree (if it is 8i) etc. Then shut down your new database. copy your datafiles, control files, log files, init file to right locations (just in case keep copies...) and restart your database. If the directory structure is the same as on the old machine, you should be all set. If the directory structure is different, you have to:

1. start server manager
2. connect as internal
3. execute: startup mount
4. let the database know where datafiles and log files are. I don't remember the

command but I believe it is:

alter database rename 'the_old_path\data01.dbf' to 'the_new_path\data01.dbf';

and you have to do it for each datafile and log file. 5. execute: alter database open

   or shutdown and startup

I have done similar things number of times on NT and never had problems...

HTH Witold

>I need to recreate a database, basically make a complete copy of one of the
>existing databases on a new server. My networking people already copied all
>datafiles, control file, log files, init file, etc to the target server.
>They also reproduced operating system directory structure.
>What I need to do is to make the second part of the task work, create the
>database, services, etc and make it run.
>I have not done it before and if I was doing it I would probably do
>export/import type of thing but the higher ups would like to have it done
>this way.
>One of the people has an idea suggesting just recreating the registry
>setting by exporting it from the existing machine to the new one.
>The other option is to reinstall Oracle but I am not sure how to make it to
>accept existing physical components(datafiles, control file, etc).
>If someone has a suggestion I would greatly appreciate it.
>Thank you in advance.
>
>Lyuda Hoska
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Witold.Iwaniec_at_atl.bluecross.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jul 11 2001 - 07:56:33 CDT