Re: Best option for moving database of server

From: Oliver <ofabelo_at_gmail.com>
Date: Thu, 3 May 2012 14:29:58 +0100
Message-ID: <CALQkqm8JTBpkDHDXwG+NEnu=WtX3dLpGRAUzpGCiGST=ngg_gg_at_mail.gmail.com>

It is all in local physical hard disks, it isn't a important database, it is a testing environment for datawarehouse. I ask about it because I'm not a dba, but I do things of dba :-) (I'm sysadmin) I have many knowledge of Oracle (I think), but I'm not a expert. Downtime is not a problem, but I like do the things well and quick, and I'm asking to you the experts.
First thing that I will do is install oracle 10g (10.2.0.1), install 10.2.0.5 patchset (as source database) and I had thought read about cloning database.
Source database is in archive mode, but I don't know very well how to recovery using rman backup, I've worked more with exp/imp or expdp/impdp. Thanks beforehand.

2012/5/3 Martin Berger <martin.a.berger_at_gmail.com>

> Oliver,
>
> 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

Received on Thu May 03 2012 - 08:29:58 CDT