Re: Best option for moving database of server

From: Rodrigo Mufalani <>
Date: Thu, 3 May 2012 11:10:08 -0300
Message-Id: <>


   If you want reduce down time from this operation , can use begin backup end backup to copy entire Db online, then recreate controlfile and apply archives.

Enviado via iPhone

Em 03/05/2012, às 10:56, Martin Berger <> escreveu:

> 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 <> 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 (, install
>> 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.

> --
Received on Thu May 03 2012 - 09:10:08 CDT

Original text of this message