
VALID_FOR ONLINE_LOGFILES or VALID_FOR ONLINE_LOGFILE ?
This will be a very short blogpost.
It started with an internal question and looking into the documentation, I have noticed that in the VALID_FOR specification for configuration a Log Archive Dest (LAD ), there was some confusion about how you need to specify this.
So after a bit of research, Oracle Data Guard accepts these keywords in the VALID_FOR clause:
1 2 3 4 5 6 7 8 9 10 11 12 |
"ONLINE_LOGFILE", "STANDBY_LOGFILE", "ALL_LOGFILES", "PRIMARY_ROLE", "STANDBY_ROLE", "ALL_ROLES", "ONLINE_LOGFILES", "STANDBY_LOGFILES", "ALL_LOGFILES", "PRIMARY_ROLES", "STANDBY_ROLES", "ALL_ROLES" |
Take into account, that this might change over time.
As always, questions, remarks?
find me on twitter @vanpupi