Re: Best option for moving database of server

From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Thu, 3 May 2012 11:10:08 -0300
Message-Id: <7469773C-0C9D-4F02-9221-4A89CAD387CD_at_mufalani.com.br>



Also,

   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 <martin.a.berger_at_gmail.com> 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 <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
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 03 2012 - 09:10:08 CDT

Original text of this message