Re: RMAN Incremental Strategy for Migrating VLDB

Ok, then why don’t you want to do a standby? In any case, if you insist on this incremental process, the basic steps are as follows:

Backup dB on current server, including archive logs Restore and recover on new server (do not open DB). The next day, backup archivelogs and copy to new server (or just copy them). Catalog backup files or archive logs using rman ‘catalog start with...’ command. Recover database on new server (do not open db). Repeat each day, or whatever interval is required.

The key to the process is you only restore the control file the day you run the restore command, the following days you use the same control file because it keeps track of your recovery state.

Sent from my iPad

> On Feb 17, 2018, at 2:05 PM, Balwanth B <balwanthdba_at_gmail.com> wrote:
> 
> Same endian format
> 
> RHEL 5 ———> RHEL 6
> 
> Sent from my iPhone
> 
>> On Feb 17, 2018, at 11:59 AM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:
>> 
>> If you are changing endian format that’s you only option.  The file formats between big endian and little endian are not compatible. 
>> 
>> Sent from my iPhone
>> 
>>> On Feb 17, 2018, at 12:52 PM, Balwanth B <balwanthdba_at_gmail.com> wrote:
>>> 
>>> 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 17 February 2018 at 03:47, Balwanth B <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> 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> 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> wrote:
>>>>> >>>
>>>>> >>> <mime-attachment.html>

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