Database check error on DB02-->Alert

[Former Member]

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 answered

[Former Member]

>>Not answered

Unless you provide requested information you will not get the soltuion.

[Former Member]

Dear,

your first error -->MISSING_INDEX ,so create table index to help APAPER,

2& 3->ARCHIVE_TOO_OLD,your system online/offline redo log backup not take for long time so...

4-->DBO STATS_TOO_OLD ,throw db13 to run database/stats update job(daily seclude) ,

regard

vinod

[former_member256254]

Looks like very serious problem is occured with the ORACLE.

I would suggest prepare a backup to restore, then do roll forward.

Thanks

[Former Member]

Is your database and SAP is up?

as I can see few error are occured 2 years back, see below:

>>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

Is any error/warnings in DB check in DB13?

[Former Member]

Hi,

1. Check the table index for ZBIMIS, ZMATCOMP

2. In this system Redo log backup was not executed for more than a months

3.Complete database backup was not performed in this system

4. Check the tablespace - PSAPTEMP,PSAPSR3 whether its in auto extend is switched on.

5. Check the oraarch/IRParch1_1472_664127538.dbf", blockno 79873

6. PSAPSR3 tablespace shows 97% show extend it.

BR,

Jai

[Syamkriz]

I am sure you are facing serious perfomance issues by now!

1)check db13-> is update statistics running? what is the color displayed?

is checkdisk running? what is the color displayed?

is backup running? what is the color displaye

2)Check file system, Is there any disk full? possible the disk partition containing oracle/sid/saparch will be full

Thanks and Regards

Syam