Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Move whole database

Re: Move whole database

From: Ian Jones <ijones_nspam_at_pacbell.net>
Date: 1999/12/30
Message-ID: <nndo6s0gj5qsieck8d2jthv55rf6j8an62@4ax.com>#1/1

If you don't move the online redo log files you will lose data.

On Wed, 22 Dec 1999 01:22:10 GMT, sunny3133440_at_my-deja.com wrote:

>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 Thu Dec 30 1999 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US