RE: need to recreate database

[lhoska]

Thank you very much to all who replied to this post and the post about
oradim.  Mission was accomplished successfully and everybody is happy.

-Original Message-
Sent: Wednesday, July 11, 2001 10:09 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]


Lyuda,

If I understand your post correctly, your networking
folks didn't install Oracle on the new server, but
instead just copied the directory structures over. 
This means you don't have any of the registry entries.
 While it is theoretically possible to export the
registry keys from one server and import them into
another, I would NOT recommend doing this - it's far
too easy to make a mistake somewhere and totally mess
things up.  Besides, Oracle Support will tell you
you're unsupported if you do so.

As long as the db was cleanly shut down when the files
were backed up you should be able to open the db OK.

1.  Install the software (select custom install and
don't have it create a starter db for you).

2.  Edit the init.ora and make any changes to
directory locations, as needed.

3.  Create the services for the db (see note: 61621.1
"WINNT/WIN2000 Recreating Oracle Services and
Instances from the Command Line")

4.  If the directory structures (datafiles, online
logs, etc...) and db_name will be the same on the new
server then you don't need to recreate the
controlfile.  If they need to change, see steps 1, 6,
& 8 of note: 73301.1 "How to make a copy of a database
on the same Windows NT machine"

HTH,

-- Anita

--- [EMAIL PROTECTED] wrote:
> Hello,
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: need to recreate database

[tday6]

I've done this myself many times.  This is the easiest way that works for
me.

1.  Install Oracle on the new machine (B) with the starter database.  This
sets up the registry correctly and gives you the database and listener
services.

2.  Delete the ORANT or ORAwhatever folder on B.  You don't need it.

3.  Stop the database and listener on your original machine (A).

4.  Copy the ORANT or ORAwhatever folder on A to B  (that should get you
all your *.ora and pfiles - to say nothing of your executables).

5.  Move all the data files, redologs, archive logs, control files, etc. to
B in the exact same location that they were on A.

6.  Edit the listener.ora to reflect the name of the new machine B.

7.  On machine B, open CONTROL PANEL, then SERVICES and start the Oracle
database and listener services.

8.  If this database is replacing the old database, edit the tnsnames.ora
on B and on other client machines and replace the hostname of A with the
hostname of B.  If it's not replacing it, then edit the tnsnames.ora by
copying the entry for the old database on A and make a new entry, replacing
the hostname of A with B.  If you're using OEM, you've got some work there
too, but I don't use it so I won't presume to advise you on that.

9.  Enjoy your new database.

There is an even easier way but I don't really trust it.

If your new machine is an exact physical clone of the old machine, then
stop the database and listener on your old machine and ask your network
guys to 'ghost' the new machine from the old machine.  You'll still have to
do steps 6 and 8 above.  I don't like ghosted machines because they seem to
end up with less stable operating systems.  However, all Windows machines
that come with the OS installed by the manufacturer have already been
ghosted (you don't really think that Dell and Gateway pay people to sit
around and install Windows from the CD, do you?).

So unless your network guys burned the new machine down to a bare disk and
did their own OS install you probably won't loose anything by having the
old machine ghosted.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: need to recreate database

[A. Bardeen]

Lyuda,

If I understand your post correctly, your networking
folks didn't install Oracle on the new server, but
instead just copied the directory structures over. 
This means you don't have any of the registry entries.
 While it is theoretically possible to export the
registry keys from one server and import them into
another, I would NOT recommend doing this - it's far
too easy to make a mistake somewhere and totally mess
things up.  Besides, Oracle Support will tell you
you're unsupported if you do so.

As long as the db was cleanly shut down when the files
were backed up you should be able to open the db OK.

1.  Install the software (select custom install and
don't have it create a starter db for you).

2.  Edit the init.ora and make any changes to
directory locations, as needed.

3.  Create the services for the db (see note: 61621.1
"WINNT/WIN2000 Recreating Oracle Services and
Instances from the Command Line")

4.  If the directory structures (datafiles, online
logs, etc...) and db_name will be the same on the new
server then you don't need to recreate the
controlfile.  If they need to change, see steps 1, 6,
& 8 of note: 73301.1 "How to make a copy of a database
on the same Windows NT machine"

HTH,

-- Anita

--- [EMAIL PROTECTED] wrote:
> Hello,
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: need to recreate database

[Witold . Iwaniec]

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: need to recreate database

[Jonathan Gennick]

Tuesday, July 10, 2001, 1:26:38 PM, Lyuda wrote:
lcc> I have not done it before and if I was doing it I would probably do
lcc> export/import type of thing but the higher ups would like to have it done
lcc> this way.

Uh oh. Damagement at work again. Let the "higher ups" do it
themselves if they are that picky.

Best regards,

Jonathan Gennick   
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: need to recreate database

[DBarbour]

Lyuda,

My guess is that if your networking folks performed the "copy" for you and
now all you have to do is get it up and running, you're probably better off
starting over.  If the database wasn't shutdown when the controlfiles were
copied, you're hosed.  I have no idea what you mean by copying the
datafiles - if the whole thing was shut down when the copies were made,
then why would you have to do an import/export? - the data is already
there.

Let's suppose that the networking guys knew about Oracle, and had shut
everything down before copying it (and copied) everything they needed to.
Safest bet is to move all the stuff to someplace else on your server or
another server, and follow this advice from Note #1080849.6 :

   

   1. Install the Oracle 
software  
   on server B.  You 
cannot simply 
   copy the orant folder 
to the
   new machine.  Registry 
entries  
   must be modified, file  

   dependencies between 
Oracle and 
   the Operating system, 
and   
   between multiple Oracle 
homes   
   (if applicable) must be 

   checked, services must 
be   
   created, etc.   

   

   2. Shut down the 
instance on
   server A.   

   

   3. Move all the data 
files, 
   redologs, archive logs, 
control 
   files, listener.ora,

   tnsnames.ora, 
init.ora and 
   config.ora to 
server B.
   

   4. On server B, open a 
Command  
   Window and execute the  

   following command:  

   

  oradim80 -new -sid 
sidname   
   -intpwd password -pfile 

   path_to_init_file 
-startmode
   auto

   

   5. Change the 
listener.ora to   
   reflect server B's 
hostname.
   

   6. Change all the 
tnsnames.ora  
   files on the clients to 
reflect 
   server B's hostname.

   

   7. Restart the 
listener.
   

   8. Edit the 
init.ora dna   
   config.ora files 
to
   reflect the correct 
directory   
   paths on server B for 
your  
  

Re: need to recreate database

[Tim Gardner]

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
>--
>Author:
>   INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: need to recreate database

[JOE TESTA]

>>> [EMAIL PROTECTED] 07/10/01 01:26PM 
>>>Hello,I need to recreate a database, basically make a 
complete copy of one of theexisting databases on a new server.  My 
networking people already copied alldatafiles, 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 thedatabase, services, etc and make it run.I have not done 
it before and if I was doing it I would probably doexport/import type of 
thing but the higher ups would like to have it donethis way.One of the 
people has an idea suggesting just recreating the registrysetting 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 toaccept 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: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).