Re: Move whole database

From: <sunny3133440_at_my-deja.com>
Date: 1999/12/22
Message-ID: <83p93v$m3q$1_at_nnrp1.deja.com>#1/1

In source database, Using svrmgrl, first create a sql file for control file: alter database backup controlfile to trace ;

Then shutdown the Source database.

Then create all the directories for destination database.

Then copy all the datafiles, ( Dont copy ONLINE redo log files ) from SOURCE directories to DEST directories.

Then, get the init(dest).ora and config(dest).ora files to the appropriate directories.

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 Wed Dec 22 1999 - 00:00:00 CET

This message: [ Message body ]
Next message: Michel Gauthier: "Re: Move whole database"
Previous message: westprod_at_my-deja.com: "Unbelievable offers on computer books !!"
Maybe in reply to: immo: "Move whole database"
Next in thread: Michel Gauthier: "Re: Move whole database"
Reply: Ian Jones: "Re: Move whole database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message