My Oracle Support Banner

11.5.10: Workflow Tables: ORA-01578: ORACLE data block corrupted ORA-26040: Data block was loaded using the NOLOGGING option (Doc ID 416476.1)

Last updated on MARCH 05, 2023

Applies to:

Oracle Workflow - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Trying to login to workflow administrator the following error is received:

ORA-01578: ORACLE data block corrupted (file # 377, block # 4205)
ORA-01110: data file 377: '/dev/rac_data2/<filename>.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option


This error reproduces with SELECT * FROM WF_LOCAL_USER_ROLES.

This is a Standby Database but the issue also occurs on a clone.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 Workflow Information Center, Diagnostics, & Community
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.