| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: need to recreate database
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<SID>.ora and
config<SID>.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<SID>.ora dna
config<SID>.ora files
to
reflect the correct
directory
paths on server B for
your
control_file,
background_dump_dest,
user_dump_dest, etc.
9. Do a startup mount
pfile
=<location of pfile> .
10.Unless the full path
to the
directory where all
your
datafiles/logfiles/controlfiles
are on server A is the
same as
the path on server B,
you will
have to now tell Oracle
where
to find your new files.
You can
either:
--Use a series of
ALTER
DATABASE RENAME FILE
commands
to rename each file to
its new
location
or
--Recreate the
controlfile
to specify the new file
paths/names. This
method is
easier if you have a
LOT of
files.
11.Startup the
Database. If it
tells you that recovery
is
necessary, issue the
recover
database command.
Hope this helps, it's a
lot
easier on UNIX.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
lhoska_at_calibre
sys.com To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
Sent by: cc:
root_at_fatcity.c Subject: need to recreate database
om
07/10/2001
12:26 PM
Please respond
to ORACLE-L
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: lhoska_at_calibresys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: DBarbour_at_austin.isd.tenet.edu
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Tue Jul 10 2001 - 14:37:49 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |