RE: replicating an instance

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Sun, 1 Feb 2004 10:36:26 -0800
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91B0D@temmse06.tem.guidant.com>

0. "alter database backup controlfile to trace". Find and rename this

file to something significant like "rename_db.sql".
> 1. Shut down the instance
> 2. Copy all data files to the new locations
2.1 Copy rename_db.sql to new location
> 3. Change the DB_NAME, dump directories, and redo log paths in the =
init.ora file
3.1 modify rename_db.sql to reflect new locations of data files, control = files, etc.

also change CREATE CONTROLFILE REUSE DATABASE "OLD_SID" to CREATE CONTROLFILE REUSE SET DATABASE "NEW_SID" = RESETLOGS
in rename_db.sql
> 4. startup nomount. Rename the redo logs

"Rename the redo logs?" Never done that! 4.1 Startup nomount. @rename_db
> 5. Create control file

See step 4.1
> 6. Open database.

     See step 4.1.  rename_db.sql includes the lines...
        # Database can now be opened normally.
        ALTER DATABASE OPEN;
     ...which you should modify to '...OPEN RESETLOGS'.

HTH,
Mike

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
-----------------------------------------------------------------

Received on Sun Feb 01 2004 - 12:36:26 CST