Re: Best option for moving database of server

From: Oliver <ofabelo_at_gmail.com>
Date: Thu, 3 May 2012 15:07:48 +0100
Message-ID: <CALQkqm_Ab-+QGt=Vd_6Qp8CF2xrRyHvJFPYDxNmoT4D1sxdMjA_at_mail.gmail.com>



Yes, I can do that, no problem.
But it is a explanation for cloning database, isn't it? copy datafiles and so on ... Some manual explaining it?
Thanks.
2012/5/3 Martin Berger <martin.a.berger_at_gmail.com>

> Oliver,
>
> what's about shutdown the source DB and just copy it ( scp ) onto the new
> host?
> If this match your downtime time-frame, it's probably the easiest way?
> (you can even do a dry-run to test how long scp will take - no danger
> here, you just might not be able to open the DB on the target without
> any preparations)
>
> I'd do it that way if it matches the requirements.
>
> hth
> Martin
>
>
> On Thu, May 3, 2012 at 3:29 PM, Oliver <ofabelo_at_gmail.com> wrote:
> > 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.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 03 2012 - 09:07:48 CDT

Original text of this message