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

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.'
>

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