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,
> --
> http://www.freelists.org/webpage/oracle-l
>
>
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-lReceived on Thu May 03 2012 - 09:10:08 CDT