RE: Best option for moving database of server

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Thu, 3 May 2012 10:20:30 -0700
Message-ID: <D29F9902E534D5478F2E83FD6A44B30649BF83CDE6_at_mail02.mba.xifin.com>



Shameful plug:

http://mdinh.wordpress.com/2011/10/08/create-standby-database-from-active-database/

What about using active database duplication? The above I used for standby, but the concept is pretty much the same, no?

Michael Dinh
Disparity Breaks Automation (DBA)

Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt  When any rule or formula becomes a substitute for thought rather than an aid to thinking, it is dangerous and should be discarded -Thomas William Phelps  
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Oliver Sent: Thursday, May 03, 2012 1:26 AM
To: oracle-l
Subject: Best option for moving database of server

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 Thu May 03 2012 - 12:20:30 CDT

Original text of this message