Re: Best option for moving database of server

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • To: ofabelo@xxxxxxxxx
  • Date: Mon, 07 May 2012 07:23:40 +0300

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...
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: