Re: Need some suggestions - DataGuard Physical Standby DB out of sync

Glad to hear it..

On Mon, Jan 22, 2018 at 11:32 AM, Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> Yeah it's set to auto - so, that would make sense so I I restarted the
> standby apply.
>
> Since the datafiles weren't in the dictionary on the Standby yet, they
> were correctly added when the redo apply got to the time the datafiles were
> added to the primary.
>
> Thanks for the suggestion.
>
> I think I got "turned around" a bit because the initial incremental roll
> forward we did also had 15 new datafiles in it that weren't on the standby
> so I was thinking I would have to repeat that whole process for the next 8
> that were added. But we're all good now.
>
> Thanks for the help!
>
> Chris
>
>
> On Mon, Jan 22, 2018 at 10:41 AM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
>> Good question. Is standby file management set to auto? If so the data
>> files should be created as the standby rolls forward.
>>
>> On Mon, Jan 22, 2018 at 10:38 AM, Chris Taylor <
>> christopherdtaylor1994_at_gmail.com> wrote:
>>
>>> Here's the scenario:
>>>
>>> 12.1.0.2 Standby database fell behind by about 2 days - my question is
>>> at the bottom, past the scenario:
>>>
>>> So, I followed:
>>> * Steps to perform for Rolling Forward a Physical Standby Database
>>> using RMAN Incremental Backup. (Doc ID 836986.1)*
>>>
>>> And that "mostly" worked - the standby database recovered up to the
>>> fuzzy point and was able to open and continue recovering.
>>>
>>> *HOWEVER*, datafiles were added to Prod while Standby Was Recovering.
>>> So I followed:
>>> *Steps to perform for Rolling forward a standby database using RMAN
>>> incremental backup when datafile is added to primary (Doc ID 1531031.1)*
>>>
>>> And that worked mostly - Database was open and begin applying
>>> archivelogs again.
>>> *HOWEVER, *datafiles were AGAIN added while standby was recovering and
>>> these new datafiles are NOT in the data dictionary of the standby.
>>>
>>> So I "think" I need to follow *Doc ID 1531031.1 *again to get an
>>> incremental backup plus these new datafiles.
>>>
>>> Problem is the incrementals take FOREVER because the database is so
>>> busy. An incremental takes about 24 hours on this busy system.
>>>
>>> QUESTION:
>>> . Am I missing something? I have this niggle that there's an easier way
>>> to add these datafiles to the standby controlfile and recover them without
>>> doing the incremental on the primary but I can't remember how?
>>>
>>>
>>> Right now, the Standby is not complaining about the missing datafiles
>>> because it hasn't recovered that far yet through the archivelogs.
>>>
>>> Chris
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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