Database Administration (MOSC)

MOSC Banner

Force logging at DB level and Table level

edited Jun 23, 2025 6:16PM in Database Administration (MOSC) 2 commentsAnswered ✓

Hi experts,

I need your help to clarify my doubt about the force logging option.

In one of our oracle databases, user schema tables are loaded with no-logging option to avoid excess logging of information, so data changes are not captured into the archive logs. When we try to restore the database with PITR and open it, it says, user-schema data blocks are corrupted.

So, my question is, if I enable the force the database logging,(force logging at DB level), does it bypass the no-logging enabled at table level?

Thank you,

Ramesh.

Tagged:

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