11gR2
OL6
We have restored full backup and applied daily archived logs to the last minute.
But when we run gather schema stats, we encountered error below:
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.1
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDGSCST: Gather Schema Statistics
+---------------------------------------------------------------------------+
Current system time is 22-FEB-2018 16:25:42
+---------------------------------------------------------------------------+
**Starts**22-FEB-2018 16:25:42
**Ends**22-FEB-2018 16:28:15
ORA-0000: normal, successful completion
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= MSC percent= 50 degree = 4 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_BOM_COMPONENTS***ORA-01578: ORACLE data block corrupted (file # 20, block # 192723)
ORA-01110: data file 20: '/oracle/ASCP/db/apps_st/data/a_txn_data05.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_DEMANDS***ORA-01578: ORACLE data block corrupted (file # 20, block # 205443)
ORA-01110: data file 20: '/oracle/ASCP/db/apps_st/data/a_txn_data05.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_ITEM_CATEGORIES***ORA-01578: ORACLE data block corrupted (file # 20, block # 203123)
ORA-01110: data file 20: '/oracle/ASCP/db/apps_st/data/a_txn_data05.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
Error #4: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_REGION_LOCATIONS***ORA-01578: ORACLE data block corrupted (file # 403, block # 259325)
ORA-01110: data file 403: '/oracle/ASCP/db/apps_st/data/a_txn_ind02.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
Error #5: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_ROUTING_OPERATIONS***ORA-01578: ORACLE data block corrupted (file # 405, block # 194237)
ORA-01110: data file 405: '/oracle/ASCP/db/apps_st/data/a_txn_ind04.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
Error #6: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_SUPPLIES***ORA-01578: ORACLE data block corrupted (file # 404, block # 214829)
ORA-01110: data file 404: '/oracle/ASCP/db/apps_st/data/a_txn_ind03.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
Error #7: ERROR: While GATHER_TABLE_STATS:
object_name=MSC.MSC_SYSTEM_ITEMS***ORA-12801: error signaled in parallel query server P002
ORA-01578: ORACLE data block corrupted (file # 20, block # 210755)
ORA-01110: data file 20: '/oracle/ASCP/db/apps_st/data/a_txn_data05.dbf'
ORA-26040: Data block was loaded using the NOLOGGING option***
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Gather Schema Statistics" has completed with error.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 22-FEB-2018 16:28:16
+---------------------------------------------------------------------------+
How to find all objects with disabled logging and
How to enable logging to those objects with disabled logging?
Kind regards,
jc