Re: Move whole database
From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: 1999/12/31
Message-ID: <386D4A3F.CDB4F85D_at_wolfenet.com>#1/1
Date: 1999/12/31
Message-ID: <386D4A3F.CDB4F85D_at_wolfenet.com>#1/1
Ian Jones wrote:
>
> If you don't move the online redo log files you will lose data.
If the instance is shut down immediate or normal, then the active online log is archived prior to shutdown. There is no need to copy the onine redologs. No data will be lost. If you move the online logs they will just get reinitialized when the create cotrolfile command is executed.
-- JeremiahReceived on Fri Dec 31 1999 - 00:00:00 CET
> 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.