Yes, what this is doing is the same as restoring from a cold backup. If
the machines are the same, you can just shutdown Oracle and copy data
files, control files, redo logs and the contents $ORACLE_HOME across to
an identical directory structure on a new machine, change any settings
like tnsnames.ora and listener.ora which might be machine specific, then
start the database on the new machine and you're all set. If the version
of Oracle is only a minor revision, then datafiles, control files et al
will be compatible, just move everything except the software.
We use a similar technique with Sun Jumpstart to create new instances
for our developers.
g
-----Original Message-----
Sent: Thursday, August 09, 2001 3:06 AM
To: Multiple recipients of list ORACLE-L
Hi,
This might be a stupid question, but I'll give it a go anyway.
I have two Unix boxes - a production and a newly created test box. The
production box has 8.0.5 and the test has 8.0.6 installed.
Is it possible to stop the database, take a backup of all the datafiles
(through the operating system) and then move them to the test server (in
the
same directory structure they were in in the production box). Would the
database open successfully?
Thanks in advance for all your help.
Regards,
Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
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: Guy Hammond
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).
