During a Backup, WF_LOCAL_ROLES Is Showing Corrupt Block (Doc ID 369535.1)

Last updated on OCTOBER 24, 2016

Applies to:

Oracle Workflow - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 29-JAN-2011


Goal

Several weeks ago the cloned database showed corrupt blocks in
WF_LOCAL_ROLES table  due to being loaded with NOLOGGING.

The complete error is : ORA-01578 ORACLE data block corrupted (file # %s, block # %s)

1. Why is this happening intermittently?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms