Re: moving database
From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 14 May 2002 14:51:12 +0200
Message-ID: <3CE10840.377A2D06_at_mytoys.de>
Date: Tue, 14 May 2002 14:51:12 +0200
Message-ID: <3CE10840.377A2D06_at_mytoys.de>
Darek wrote:
>
> Hey !
>
> I'm looking for tools in ORACLE with allow me copy one database to other
> oracle database without stopping any database and losing data. For example -
> I have one database on old server, I've bought new one and want to use it. I
> know I can make dump file and import it to new database - but then I'll lost
> all records which are processed during this operation...
> How can I copy records and then switch the database without losing data ?
You can setup a standby database and at point X you activate the standby db as the master db and stop your old master. And BTW, if you can do it depends on your Oracle version.
Regards,
Knut Received on Tue May 14 2002 - 14:51:12 CEST