RE: replicating an instance

  • From: "Pete Sharman" <peter.sharman@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 3 Feb 2004 03:50:25 +1100

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ryan
Sent: Monday, February 02, 2004 12:37 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: