Re: Move whole database

1. In source database, Using svrmgrl, first create a sql file for control file: alter database backup controlfile to trace ;
2. Then shutdown the Source database.
3. Then create all the directories for destination database.
4. Then copy all the datafiles, ( Dont copy ONLINE redo log files ) from SOURCE directories to DEST directories.
5. Then, get the init(dest).ora and config(dest).ora files to the appropriate directories.
6. Then, run the above script which creates the control file.

This script can be found under (.trc file) $ORACLE_HOME/rdbms/log.

Harjinders_at_hotmail.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 21 1999 - 19:22:10 CST