Re: Moving VLDB RAC to a new datacenter

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Fri, 28 Feb 2014 09:34:40 +0100
Message-ID: <53104A20.4080001_at_gmail.com>

Hi Kenny,
that will be another migration strategy to consider.

Thanks!

Best regards
Dimitre

On 27/02/2014 17:43, Kenny Payton wrote:
> Here’s an option that requires a little work but could minimize your
> downtime. I do this in our data guard environment when duplicating a
> 18+TB instance several states away and can’t hold the archive logs on
> the primary the entire time.
>
> Enable archiving with a very frequent archive log delete process to
> fit within available space. Archivelog deletion policy will need to
> be “shipped to standby”.
> Setup a temporary minimal instance on the target host using a backed
> up control file. Just enough to mount the instance, offline dropping
> all of the datafiles before doing so.
> Setup archivelog transport services on the primary to ship logs to the
> new instance.
> Duplicate the database across the wire.
> register the shipped log files on the temp instance and apply the logs.
> You can continue the shipping and regularly apply the logs up until
> the cut over time.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 28 2014 - 09:34:40 CET