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