RE: RMAN Incremental Strategy for Migrating VLDB

From: Reen, Elizabeth <"Reen,>
Date: Tue, 20 Feb 2018 20:34:19 +0000
Message-ID: <258575162B63424EB58DAE3A5475B6ED012CDAE6F3_at_EXNJMB25.nam.nsroot.net>



How big is big?

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930 (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Balwanth B Sent: Saturday, February 17, 2018 1:53 PM To: Peter Gram Miracle A/S
Cc: Andrew Kerber; oracle-l; Peter Gram Subject: Re: RMAN Incremental Strategy for Migrating VLDB

Thanks for sharing that, Is this the only way Transportable Tablespace? I was more of looking a DOC for below way. In general,Is this possible? Is there a DOC for this?

  1. Do a online backup and restore on new site(restore database)
  2. Take a incremental backup and again do restore (restore latest control file and do restore database) ---> like 2 or 3 iterations
  3. on cut-over day, take last incremental backup and then do (restore database and recover database)...
  4. alter database resetlogs; and open for users

Thanks,

Balwanth

On Sat, Feb 17, 2018 at 6:23 AM, Peter Gram Miracle A/S <pgr_at_miracle.dk<mailto:pgr_at_miracle.dk>> wrote: Hi

I think the this is the support note you were looking for "11G - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1)"

Gram/

Med Venlig Hilsen

Peter Gram

Kultur-kustode for Miracle

  • we dare - we share - we care -

Miracle A/S
Borupvang 2c, 2750 Ballerup, Denmark<https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3DBorupvang-2B2c-2C-2B2750-2BBallerup-2C-2BDenmark-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=tJ5XTjoKafsGn0p9yz52mnl8gZTYi01AjPP3Kpke4u0&s=DgcfJnbrTKwmT19MPvw-P6JSWLu0kS8arSJn6pX6uZE&e=> Cell: (+45) 53747107<tel:+45%2053%2074%2071%2007> Office Phone: (+45) 44668855<tel:+45%2044%2066%2088%2055> Mail: peter.gram_at_miracle.dk<mailto:peter.gram_at_miracle.dk>

Home : (+45) 38745696<tel:+45%2038%2074%2056%2096> Home : S├Žbyholmsvej 18<https://urldefense.proofpoint.com/v2/url?u=https-3A__maps.google.com_-3Fq-3DS-25C3-25A6byholmsvej-2B18-26entry-3Dgmail-26source-3Dg&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=tJ5XTjoKafsGn0p9yz52mnl8gZTYi01AjPP3Kpke4u0&s=fY6iPHT9a6y0-U8m2RybDn7jy0Xv3ua8bOVAq0-wEkE&e=> 2500 Valby linkedin: dk.linkedin.com/in/petergram/<https://urldefense.proofpoint.com/v2/url?u=http-3A__dk.linkedin.com_in_petergram_&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=tJ5XTjoKafsGn0p9yz52mnl8gZTYi01AjPP3Kpke4u0&s=jWjMTa9vV1ihDuqXm0To4MpgoE-O4tqWmQZ-qPjlZiU&e=> OakTable : oaktable.net/members <https://urldefense.proofpoint.com/v2/url?u=http-3A__oaktable.net_members&d=DwMFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=tJ5XTjoKafsGn0p9yz52mnl8gZTYi01AjPP3Kpke4u0&s=WHDulD-wZJY_EajVKQ5xVxWeuy4CmkrZ9CzhqY_Bez8&e=>

On 17 February 2018 at 03:47, Balwanth B <balwanthdba_at_gmail.com<mailto:balwanthdba_at_gmail.com>> wrote: Thanks for the response , I will propose this to my management. On other side, can I still get a doc ID or link on how to do Rman incremental strategy for my educational purpose. Thanks in advance!!!

Sent from my iPhone

> On Feb 16, 2018, at 6:45 PM, Andrew Kerber <andrew.kerber_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> wrote:
>
> In that case a dataguard standby is really the way to go.
>
> Sent from my iPad
>
>> On Feb 16, 2018, at 6:28 PM, Balwanth B <balwanthdba_at_gmail.com<mailto:balwanthdba_at_gmail.com>> wrote:
>>
>> Yes we are in EE
>>
>> Sent from my iPhone
>>
>>> On Feb 16, 2018, at 4:37 PM, Andrew Kerber <andrew.kerber_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> wrote:
>>>
>>> <mime-attachment.html>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 20 2018 - 21:34:19 CET

Original text of this message