Re: Best option for moving database of server

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 07 May 2012 07:23:40 +0300
Message-id: <4FA74E4C.8000105_at_inter.net.il>



In your case I will create a new DB with the same directory structure and name as the source and then choose:
1) Just copy the whole database files to the new location. 2) Use impdp with network link to copy the data.

Yechiel Adar

On 03/05/2012 11:25, Oliver 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
Received on Sun May 06 2012 - 23:23:40 CDT

Original text of this message