Error messages

[Former Member]

Hi Friends,

We have following errors in our R/3 system, this system didn’t show any kind of parameter errors for the last 2yrs and suddenly it comes up with the following errors.

Ours is R/3 4.6c on HPUX/oracle.

BR0970W Database administration alert - level: ERROR, type: NOARCHIVELOG_MODE, object: BRD

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/BRD/sapdata1/ddicd_2/ddicd.data2, value: (max_extn) 1077248 KB (> 760248 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/BRD/sapdata1/docud_2/docud.data2, value: (max_extn ) 825344 KB (> 760248 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/BRD/sapdata1/system_1/sysaux01.dbf, value: (max_ex ) 1024000 KB (> 760248 KB)

BR0970W Database administration alert - level: ERROR, type: MISSING_INDEX, object: (table) SAPR3.ZMMW

BR0280I BRCONNECT time stamp: 2008-03-26 08.01.04

BR0972I Checking database operations...

BR0973W Database operation alert - level: WARNING, operation: sdxkdbzo.tsc, time: 2008-03-04 15.00.04, condition: Last successful 'tsc' operation older than 10 days

BR0973W Database operation alert - level: WARNING, operation: sdxkdbsy.tse, time: 2008-03-04 14.57.12, condition: Last successful 'tse' operation older than 10 days

BR0973W Database operation alert - level: WARNING, operation: sdxjzytw.dfa, time: 2008-03-03 23.45.00, condition: Last successful 'dfa' operation older than 10 days

BR0973W Database operation alert - level: WARNING, operation: bdwzokqb.dbv, time: 2008-01-08 18.00.41, condition: Last successful 'dbv' opera tion older than 10 days

BR0280I BRCONNECT time stamp: 2008-03-26 08.01.04

BR0974I Checking database messages i/oracle/BRD/saptrace/background/alert_BRD.log ...

BR0280I BRCONNECT time stamp: 2008-03-26 08.01.06

BR0977I Checking database profile...

BR0978W Database profile alert - level: ERROR, parameter: FILESYSTEMIO_OPTIONS, value: ASYNCH (<> SETALL)

BR0978W Database profile alert - level: WARNING, parameter: LOG_CHECKPOINTS_TO_ALERT, value: FALSE (<> TRUE)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_FEATURES_ENABLE, value: 9.2.0 (set in parameter file)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_INDEX_CACHING, value: 0 (>< 100,20)

BR0978W Database profile alert - level: WARNING, parameter: OPTIMIZER_MODE, value: CHOOSE (set in parameter file)

BR0978W Database profile alert - level: WARNING, parameter: PARALLEL_EXECUTION_MESSAGE_SIZE, value: 2152 (>< 16384,4096)

BR0978W Database profile alert - level: ERROR, parameter: REPLICATION_DEPENDENCY_TRACKING, value: TRUE (<> FALSE)

BR0978W Database profile alert - level: WARNING, parameter: TIMED_STATISTICS, value: TRUE (set in parameter file)

BR0280I BRCONNECT time stamp: 2008-03-26 08.01.06

BR0980I Number of changed database profile parameters: 0

Please help friends, I will reward points.

Thanks and regards,

anuropp

[Former Member]

Look like the Database size has reached the max threshold.

Check at OS level :

> bdf | grep sapdata

if required Extend tablespace and change it to ARCHIVE MODE as explained above

Cheers

Shaji

[Former Member]

Hi,

Below is my answer:

NOARCHIVELOG_MODE= if the error was not there before, did you change the the archive log mode. This mean that your archivelog mode was not running and you cannot perform any forward recovery in case your system was crashed. To change the database to archivelog mode follow the below step:

Arrange for downtime, then do the following from sqlplus:

SQL> CONNECT sys AS SYSDBA

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ALTER DATABASE OPEN;

CRITICAL_FILE= checked from db02 if any tablespace going to fully utilize. If any please increase the tablespace using brtools or sapdba

MISSING_INDEX=checked from db02 if any missing index occured. if yes you can recreate it via db02 as well. please do it during less user on the system.

As for other warning, please advice which oracle version that you are using.

Thanks and REgards

Tarmizee