Re: need to recreate database

Lyuda,

If the database is still running on the old server, and the disk structure is the same on the new server, the easiest way is to do an export of the old database and an import with full=Y on the new server.

If the database was shut down before the files were copied, this should also work, but you will need to set up the SID on the new server and have the init.ora point to the copied files.

Tim

>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>http://www.orafaq.com
>--
>Author:
> INET: lhoska_at_calibresys.com
>
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gardner
  INET: tgardner_at_codeHorse.com

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