RE: replicating an instance
- From: "Vergara, Michael (TEM)" <mvergara@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 1 Feb 2004 10:36:26 -0800
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@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:
