Re: Better Way to Do Cross Platform Migration with RMAN(large DB)

From: kyle Hailey <kylelf_at_gmail.com>
Date: Fri, 6 Sep 2013 07:56:49 -0700
Message-ID: <CADsdiQg_oRPRHL+bHRS+L_hEP65Co=q9mt-PcS+ErhgE92zzoQ_at_mail.gmail.com>

There is also incremental cross platform conversion which Martin Bach will be presenting on a webinar with Enkitec and Red Gate http://www.enkitec.com/apex/f?p=15000:410:0::::TRACKBACK:enkitec_announces_new_partnership_with_redgate

example:

1. Convert all user (source) datafiles while they are read-write, it takes 2 days. It produces the incosistent converted target datafilecopies.
2. After the 2 days, take a cross platform incremental backup of the user (source) datafiles while they are read-write, and apply this incremental to the the inconsistent converted target datafilecopies of step 1). Let's say that takes 12 hours.
3. After step 2) finishes, take a second cross platform incremental backup of the user (source) datafiles while they are read-write, and apply this incremental to the the inconsistent converted target datafilecopies of step 2). Let's say that takes 6 hours.
4. After step 3) finishes, take a third cross platform incremental backup of the user (source) datafiles while they are read-write, and apply this incremental to the the inconsistent converted target datafilecopies of step 3). Let's say that takes 2 hours.
5. After step 4) finishes, make all user datafiles read only, take a final consistent cross platform incremental backup of the user (source) datafiles, and apply this incremental to the the inconsistent converted target datafilecopies of step 3). Yielding consistent datafilecopies that can be plugged. Also take the export of the netadata of the user datafiles. Say it takes 30 minutes.
6. Plug the converted datafiles into the already created database, say it takes 6 hours.

The total downtime for the source is 6 hours and a half, versus the one shot conversion that would have mean almost 3 days.

• Kyle http://kylehailey.com

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

Received on Fri Sep 06 2013 - 16:56:49 CEST