High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Does a physical standby database require "force logging"?

I know when setting up a physical standby database you are required to put the primary in "force logging" but I'm wondering if the same is true for the physical standby.

It seems to me it would be a good idea to have the standby using "force logging" even if that only prepared you for a role switch.

All the documentation I read only mentions the primary so I want to make sure that there won't be problems if I do put my standby into force logging mode.

Incidentally, the reason this came up is that I had the standby in "snapshot standby" mode, and a process updated a table using NO_LOGGING so I got a data block corruption error. Of course, the error didn't matter since it was in snapshot standby mode, but it got me thinking.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center