Best option for moving database of server
From: Oliver <ofabelo_at_gmail.com>
Date: Thu, 3 May 2012 09:25:59 +0100
Message-ID: <CALQkqm-XtFtx3i_fqAAEYJZfNwZv8NEL7Xcv=Ue9JnokG2oEiA_at_mail.gmail.com>
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?
Date: Thu, 3 May 2012 09:25:59 +0100
Message-ID: <CALQkqm-XtFtx3i_fqAAEYJZfNwZv8NEL7Xcv=Ue9JnokG2oEiA_at_mail.gmail.com>
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-lReceived on Thu May 03 2012 - 03:25:59 CDT