Re: Best option for moving database of server

From: Ilmar Kerm <>
Date: Thu, 3 May 2012 12:20:52 +0300
Message-ID: <>

On Thu, May 3, 2012 at 11:25 AM, Oliver <> wrote:
> Hi,
> I have to move a oracle database 10g ( to another server, what
> would you recommend me that is the best option for doing it? Cloning
> database?
> Architecture will be the same in the source and target server, different
> distribution of Linux, but with same architecture (x86-64).
> I had thought install oracle (I think that there isn't
> full install), I will have to install patchset and then cloning
> database :-?
> I know transport tablespaces too ... and export/import. What would be the
> best option? Database is not large/great, and it isn't a important
> database, it can be stopped, although I don't want a large downtime.
> Thanks beforehand.
> P.D.: If you prefer cloning database, some manual about it?

Cloning is an option, but if you are in archivelog mode and using rman backups, then you can also use them to minimize downtime. Or if you are using Enterprise Edition, then Data Guard physical standby is a good option and quite easy to set up using data guard broker.
If you are on standard edition, then the same thing can be done manually using RMAN... restore database from backup on new server, but don't open it. This can be done before switching and while the old database is still open. Until you are ready to switch, backup archivelogs on old server, copy backup to new server, catalog backup and recover database. If you are ready to switch then shutdown&mount the old database, backup the final archivelogs (including online log) and recover the database on new server and open the new server.

Ilmar Kerm
Received on Thu May 03 2012 - 04:20:52 CDT

Original text of this message