URL getting error like HTTP 500 Internal server error after Cloning :

Error:-

URL getting error like HTTP 500 Internal server error after Cloning :

ORA-01578: ORACLE data block corrupted (file # 377, block # 4205)
ORA-01110: data file 392: '/u01/app/oracle/db/apps_st/data/a_txn_data01.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option

Solution:-

Partitions in Workflow Local Tables are Automatically Switched to NOLOGGING [ID 433280.1]

How to identify all the Corrupted Objects in the Database with RMAN [ID 472231.1]

SQL> select b.tablespace_name, count(BLOCK#) from v$database_block_corruption a, dba_data_files b where a.FILE#=b.FILE_ID group by b.tablespace_name

WF_LOCAL_ROLES

WF_LOCAL_USER_ROLES

WF_USER_ROLE_ASSIGNMENTS

Set all partitions and staging tables to use LOGGING.

1) For any partition that is set to NOLOGGING, manually alter it to LOGGING:

1.1) SQL to run to retrieve partitions that are set to NOLOGGING:

select table_name, partition_name

from dba_tab_partitions

where table_name in

('WF_LOCAL_ROLES' ,

'WF_LOCAL_USER_ROLES' ,

'WF_USER_ROLE_ASSIGNMENTS')

and logging = 'NO' ;

1.2) switch all partitions retrieved in step 1.1 to LOGGING = 'YES' using

the following syntax:

alter table applsys.<table_name> modify partition <partition_name> logging;

Example:

alter table applsys.WF_LOCAL_USER_ROLES modify partition ENG_LIST logging;

2) For any stage table that is set to NOLOGGING, manually alter them to LOGGING.

2.1) SQL to run to retrieve stage tables set to NOLOGGING:

select table_name

from dba_tables

where table_name in

('WF_LOCAL_ROLES_STAGE' ,

'WF_LOCAL_USER_ROLES_STAGE' ,

'WF_UR_ASSIGNMENTS_STAGE')

and logging = 'NO' ;

2.2) Switch all the tables retrieved by statement above to LOGGING = 'YES' using the

following syntax:

alter table applsys.<table_name> logging;

example:

alter table applsys.WF_LOCAL_ROLES_STAGE logging;

3) Then run the synchronize WF local tables concurrent program with logging mode = 'LOGGING'.

4) After completion, monitor tables and partitions: they should remain to LOGGING = 'YES'.