Re: Best option for moving database of server

do you can share some informations about your storage infrastructure? Also an accepted downtime and size or your DB might influence the decission.
If it's a SAN, can you just detatch the LUNs from the old server and attach them to the new?

the physical equivalent with built in disks would be removing the disks from old node and attaching them to new one? (I prefer the 'logical only' solution in a SAN, removing hardware is always somehow risky)

Beside that a dataguard comes to my mind - so the new server is just a switchover away.

other solutions are datapump over a DB link, ... do you need still more?

 Martin

On Thu, May 3, 2012 at 10:25 AM, Oliver <ofabelo_at_gmail.com> wrote:
> Hi,
> I have to move a oracle database 10g (10.2.0.5.0) 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 10.2.0.1 (I think that there isn't 10.2.0.5
> full install), I will have to install 10.2.0.5 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?
>
> Cheers...
>
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l