RE: RMAN Incremental Strategy for Migrating VLDB
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?
- Do a online backup and restore on new site(restore database)
- Take a incremental backup and again do restore (restore latest control file and do restore database) ---> like 2 or 3 iterations
- on cut-over day, take last incremental backup and then do (restore database and recover database)...
- 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-lReceived on Tue Feb 20 2018 - 21:34:19 CET