Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database check error on DB02-->Alert

Dear All,

We found the below errors on DB02 -->Alert .

E 22.12.2010 12:02:31 10 DBA MISSING_INDEX 1 Table: SAPSR3.ZBIMIS # Table has no index

W 22.12.2010 12:02:31 0 DBO ARCHIVE_TOO_OLD 1 Operation: 'Archive log backup' has not been run # Operation too old or has not been run in clean-up period

W 22.12.2010 12:02:31 0 DBO BACKUP_TOO_OLD 1 Operation: 'Complete database backup' has not been run # Operation too old or has not been run in clean-up period

W 22.12.2010 12:02:31 6 DBO OPERATION_TOO_OLD chk 1 Operation: 'chk' has not been run # Operation too old or has not been run in clean-up period

W 22.12.2010 12:02:31 6 DBO STATS_TOO_OLD 1 Operation: 'Update optimizer statistics' has not been run # Operation too old or has not been run in clean-up period

W 22.12.2010 12:02:31 6 ORA 00060 5 Time: 2008-11-07 21.41.35, line: ORA-00060: Deadlock detected. More info in file /oracle/IRP/saptrace/usertrace/irp_ora_606586.t

E 22.12.2010 12:02:31 6 ORA 00376 100 Time: 2008-09-26 17.34.39, line: ORA-00376: file 1 cannot be read at this time

E 22.12.2010 12:02:31 6 ORA 00470 2 Time: 2010-02-25 05.34.41, line: ORA-470 signalled during: ALTER DATABASE DISMOUNT...

E 22.12.2010 12:02:31 6 ORA 00471 3 Time: 2008-10-10 18.05.57, line: ORA-00471: DBWR process terminated with error

E 22.12.2010 12:02:31 6 ORA 00474 1 Time: 2010-03-10 04.47.53, line: ORA-00474: SMON process terminated with error

E 22.12.2010 12:02:31 6 ORA 00600 2 Time: 2010-02-12 11.41.38, line: ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []

E 22.12.2010 12:02:31 6 ORA 01113 10 Time: 2008-11-28 18.38.28, line: ORA-1113 signalled during: ALTER DATABASE OPEN...

W 22.12.2010 12:02:31 6 ORA 01555 1 Time: 2010-09-08 10.01.09, line: ORA-01555 caused by SQL statement below (SQL ID: 6cbacdfn457j9, Query Duration=57100 sec, SCN:

E 22.12.2010 12:02:31 2 ORA 01652 4 Time: 2010-12-20 10.41.41, line: ORA-1652: unable to extend temp segment by 128 in tablespace PSAPTEMP

E 22.12.2010 12:02:31 6 ORA 01653 100 Time: 2010-12-09 16.17.30, line: ORA-1653: unable to extend table SAPSR3.BALDAT by 128 in tablespace PSAPSR3

E 22.12.2010 12:02:31 6 ORA 01691 20 Time: 2010-12-09 16.10.05, line: ORA-1691: unable to extend lobsegment SAPSR3.SYS_LOB0000072694C00007$$ by 128 in tablespace

E 22.12.2010 12:02:31 6 ORA 16038 100 Time: 2008-10-26 13.55.06, line: ORA-16038: log 4 sequence# 1472 cannot be archived

E 22.12.2010 12:02:31 6 ORA 19502 100 Time: 2008-10-26 13.55.06, line: ORA-19502: write error on file "/oracle/IRP/oraarch/IRParch1_1472_664127538.dbf", blockno 79873

E 22.12.2010 12:02:31 6 ORA 19504 1 Time: 2009-07-09 17.34.49, line: ORA-19504: failed to create file "/oracle/IRP/oraarch/IRParch1_14699_664127538.dbf"

E 22.12.2010 12:02:31 6 ORA 19510 11 Time: 2008-10-26 14.17.54, line: ORA-19510: failed to set size of 85896 blocks for file "/oracle/IRP/oraarch/IRParch1_1473_66412

E 22.12.2010 12:02:31 6 ORA 27044 1 Time: 2009-07-09 17.34.49, line: ORA-27044: unable to write the header block of file

E 22.12.2010 12:02:31 6 ORA 27063 100 Time: 2008-10-26 13.55.06, line: ORA-27063: number of bytes read/written is incorrect

E 22.12.2010 12:02:31 6 ORA 27072 2 Time: 2009-06-20 11.03.58, line: ORA-27072: File I/O error

W 22.12.2010 12:02:31 9 ORA Checkpoint not complete 100 Time: 2008-08-29 22.02.36, line: Checkpoint not complete

W 22.12.2010 12:02:31 10 PROF LOG_BUFFER 1 Value: 14238720 (>< 4096,512 KB) # Size of redo log buffer in bytes

W 22.12.2010 12:02:31 10 PROF OPTIMIZER_FEATURES_ENABLE 1 Value: 10.2.0.1 (set in parameter file) # Optimizer plan compatibility parameter

W 22.12.2010 12:02:31 10 PROF OPTIMIZER_INDEX_COST_ADJ 1 Value: 20 (set in parameter file) # Optimizer index cost adjustment

E 22.12.2010 12:02:31 10 PROF REPLICATION_DEPENDENCY_TRACKING 1 Value: TRUE (<> FALSE) # Tracking dependency for Replication parallel propagation

W 22.12.2010 12:02:31 10 PROF STATISTICS_LEVEL 1 Value: TYPICAL (set in parameter file) # Statistics level

W 16.12.2010 08:31:09 6 DBO LAST_ARCHIVE_FAILED 1 Operation: aeeuepco.cds, time: 2010-12-15 15.53.58 failed with rc = 5 # Last archive log backup failed with rc = 5

W 16.12.2010 08:31:09 6 DBO LAST_BACKUP_FAILED 1 Operation: beeuekuv.anf, time: 2010-12-15 15.05.33 failed with rc = 5 # Last complete database backup failed with rc = 5

W 13.12.2010 08:29:12 10 DBA TABLESPACE_FULL 1 Tablespace: PSAPSR3, value: 96.96% (> 95%) # Tablespace full

E 12.12.2010 00:22:33 10 DBA MISSING_STATISTICS 1 Table: SAPSR3.ZMATCOMP # Table or index has no optimizer statistics

Kindly advise

Former Member
Not what you were looking for? View more on this topic or Ask a question