RE: replicating an instance

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Tue, 3 Feb 2004 03:50:25 +1100
Message-ID: <00cf01c3e9ac$ac2071c0$6f4f8790@PETE>

And of course, in addition to the answers you've already received which cover what you really wanted to do rather than what you asked for, remember you're copying the database, not the instance! :)

Pete

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

"Oh no, it's not. It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ryan Sent: Monday, February 02, 2004 12:37 AM To: oracle-l_at_freelists.org
Subject: replicating an instance

I do development so please bare with the stupid question. To copy an instance I do the following right?

1. Shut down the instance
2. Copy all data files to the new locations
3. Change the DB_NAME, dump directories, and redo log paths in the

init.ora file

4. startup nomount. Rename the redo logs
5. Create control file
6. Open database.

I think Im missing some steps.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Mon Feb 02 2004 - 10:50:25 CST