Skip to Content
avatar image
Former Member

DB13 DBCHECK ended with warning -pls help

Hi All,

From last few days in DB13 dbcheck is showing the following warning regarding tablespace full, aur tablespaces have already been set as "AUTOEXTEND". We have few options to overcome this problem.

1) Increase the maxsize of autoextend

2) Adding a datafile to the particular TS.

Pls suggest

pls find the details of dbcheck log-:

BR0981W Not enough disk space for the total maximum size 50000.000 MB of 5 files of tablespace PSAPXXX640 on disk device 1077149698, missing

at least 21135.719 MB

BR0981W Not enough disk space for the total maximum size 50000.000 MB of 5 files of tablespace PSAPXXX640 on disk device 1077149697, missing

at least 21135.719 MB

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata3, value: 99.94% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata4, value: 99.98% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata2, value: 99.98% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata1, value: 99.99% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata5, value: 99.87% (> 99%)

BR0970W Database administration alert - level: WARNING, type: FILE_SYSTEM_FULL, object: /oracle/XXX/sapdata6, value: 99.17% (> 99%)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/XXX/sapdata1/XXX640_1/ecp640.data1, value: (incr

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/ECP/sapdata1/xxx640_2/xxx640.data2, value: (incr

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/ECP/sapdata1/xxx640_3/xxx640.data3, value: (incr

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/XXX/sapdata1/system_1/system.data1, value: (incr

BR0970W Database administration alert - level: WARNING, type: TABLESPACE_FULL, object: PSAPECP, value: 98.23% (> 95%)

Waiting for your quick responses

Regards,

Prashant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 09, 2008 at 04:07 AM

    Hi All,

    To add one more thing currently all the datafiles in for PSXXX tablespace are in AUTOEXTEND MODE and parameter "INCREMENT_BY" has been defined as "2560".

    Do we need to increase this value or we can directly go for adding a new datafile to this TS.There is enough disk space available in the disk approx 45.52 GB is free.

    Regards,

    Prashant.

    Add comment
    10|10000 characters needed characters exceeded