CHECKDB warning

[Former Member]

Hello,

We get the following warning in daily db check which runs on our SCM system running on oracle 11.2.0.4.0.

-----------------------------------------------------

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 38 files on disk 26) 198841344 KB (> 39780800 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 6 files on disk 26) 39905280 KB (> 39780800 KB)-

----------------------------------------------------------

Not able to understand the info in bold.

Please find the tablespace PSAPSR3 extension info from brtools.

List of database data files

Pos.  Tablespace     Status  Type  File

        Id.    Size[KB]     Device  Back.  AuExt.  MaxSize[KB]  IncrSize[KB]

   1 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_1/sr3.data1

         4     5079040          26  NO     YES       10240000         20480

   2 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_2/sr3.data2

         5     5201920          26  NO     YES       10240000         20480

   3 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_3/sr3.data3

         6     5058560          26  NO     YES       10240000         20480

   4 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_4/sr3.data4

         7     4915200          26  NO     YES       10240000         20480

   5 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_5/sr3.data5

         8     5017600          26  NO     YES       10240000         20480

   6 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_6/sr3.data6

         9     5017600          26  NO     YES       10240000         20480

   7 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_7/sr3.data7

        10     4915200          26  NO     YES       10240000         20480

   8 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_8/sr3.data8

        11     5079040          26  NO     YES       10240000         20480

   9 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_9/sr3.data9

        12     4997120          26  NO     YES       10240000         20480

  10 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_10/sr3.data10

        13     4956160          26  NO     YES       10240000         20480

  11 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_11/sr3.data11

        14     4997120          26  NO     YES       10240000         20480

  12 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_12/sr3.data12

        15     4894720          26  NO     YES       10240000         20480

  13 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_13/sr3.data13

        16     4956160          26  NO     YES       10240000         20480

  14 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_14/sr3.data14

        17     4874240          26  NO     YES       10240000         20480

  15 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_15/sr3.data15

        18     4853760          26  NO     YES       10240000         20480

  16 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_16/sr3.data16

        19     5160960          26  NO     YES       10240000         20480

  17 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_17/sr3.data17

        20     5017600          26  NO     YES       10240000         20480

  18 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_18/sr3.data18

        21     5038080          26  NO     YES       10240000         20480

  19 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_19/sr3.data19

        22     5181440          26  NO     YES       10240000         20480

  20 - PSAPSR3        ONLINE  FILE  /oracle/P43/sapdata2/sr3_20/sr3.data20

        23     5181440          26  NO     YES       10240000         20480

KINDLY HELP ME UNDERSTAND THE INFO IN BOLD in the warning(dotted lines).

Thanks  in advance!

Uday

[Former Member · Accepted solution]

Hi,

You are getting this message because your tablespace files are in auto extend mode that is the have some minimal size and will extend until reaches maximum defined size.

The message is because if all the current files reaches their maximum value will exceed your total OS space.

To ignore the message, either switch off auto extend mechanism or increse the os space greater than the total of the maximum size of data files.

Regards,

Nikhil

[former_member182657]

Hi Uday,

BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3, value: (max_extn of 38 files on disk 26) 198841344 KB (> 39780800 KB)
BR0970W Database administration alert - level: WARNING, type: CRITICAL_TABLESPACE, object: PSAPSR3700, value: (max_extn of 6 files on disk 26) 39905280 KB (> 39780800 KB)-

Here system is checking for free space on the disk 26 to extend the files to the maximum size (max_extn) as your data files are under Auto extend on mode.It's basically new critical table space check conditions in brconnect,for same you could check with SAP Note  849484 - New CRITICAL_TABLESPACE check condition in BRCONNECT

Hope this will be helpful for you.

Regards,

Gaurav

[Former Member]

Hi ,

Can someone help me on this issue.

The issue is getting repeated daily.

Thanks in advance!

Uday.

[Nicolas]

Hello,

Your datafiles are in autoextend mode and the maximum size is higher than the space available on the disk. Please check this link: BRCONNECT Default Conditions for Database Administration - SAP Database Guide: Oracle (BC-DB-ORA-DBA...

Edit: And check also the following thread

Regards,

Nicolas Vander Auwera