Re: How to duplicate whole database from one machine to another machine in Windows 2000?

If you don't want to mess around with recovery after you copy to the new machine, don't forget to shut down the database first. And if the database is shut down, you can just copy your control file instead of rebuilding it from a trace.

One caveat - if you want to use RMAN to control both databases, they'll have the same DBID (select dbid from v$database) and RMAN won't know which you want when you specify a target. If you don't use RMAN, forget what I just said.

tesst wrote:
> You can create a trace of the controlfile, copy all the databasefiles to
> another machine, and follow the steps to create a new controlfile on the
> other machine.
> It is all described in the "backup and recovery guide".
>
> Regards,
> Audun
>
>
> On Wed, 4 Dec 2002 13:51:40 +0800, HK Chang
> <REMOVETHIS_hkchang_at_bigfoot.com> wrote:
>

>> Dear All,
>>
>> Do you know how I can duplicate the whole database from one Windows 2000
>> machine to another Windows 2000 machine?
>>
>> Thanks.
>>
>> Regards,
>> HK Chang
>>