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 OCTOBER 31, 2017

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/rapplsysd03.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.

Cause

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