Re: Must service be stopped to migrate database ?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 22 Feb 2003 08:52:46 -0800
Message-ID: <92eeeff0.0302220852.2b2a9f59@posting.google.com>

"j" <perseus_medusa_at_hotmail.com> wrote in message news:<3e572b20$1_at_newsgate.hknet.com>...
> Hi all ,
>
> I am wondering if I want to migrate database from one instance to
> another, must the service provided by the database (like web or application)
> be stopped during the process in order to prevent transactions during
> migration ? As I always think that this may cause unsynchronized data
> between the replicated target database and the source database.
>
> If the above question make you confuse, then simply, I am asking if
> someone show me what's the usual practice / procedure of doing migration ?
>
> Thanks.
>
> Perseus

Whenever you want to copy Oracle datafiles on OS level, you MUST stop the database. On Windows, you can stop the database in couple of ways. 1) Just shutdown OracleService<SID>
2) Using server manager/Sqlplus, connect internal/sys as sysdba and issue shutdown immediate command. In this case, stopping OracleService<SID> is optional as you have already shutdown the database.

Regards
/Rauf Sarwar Received on Sat Feb 22 2003 - 10:52:46 CST