on 12-18-2014 11:57 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Can someone help me on this issue.
The issue is getting repeated daily.
Thanks in advance!
Uday.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.