Warning In DB13 ...

[Former Member]

Dear Team,

We have got following warning in DB13 in Check DB please find alert file attached , please revert earliest.

Regards

Yogesh.

BR0981W Not enough disk space for the total maximum size 30000.000 MB of 4 files of tablespace PSAPBWP640 on disk device 3473409, missing at least 1692.695 MB

BR0983I Tablespace fragmentation

Tablespace Files Tables Indexes Extents Total[KB] Used[%] Free[KB] FreeExt. MaxAlloc[KB] Used[%] Free[KB] Largest[KB]

PSAPBWP 108 32766 43983 1124365 1124769792 80.89 214991296 27133 1145966592+ 79.39+ 236188096+ 5734400:4710400:4063232:40632

PSAPBWP640 6 268 373 7285 23715840 99.89 27008 7 44339200+ 53.43+ 20650368+ 7843840:5017600:3276800+:2744

PSAPBWPUSR 2 62 12 2088 2334720 82.56 407168 3 10240000+ 18.82+ 8312448+ 3973120:3932160:207808:198592

PSAPTEMP 3 0 0 0 23846912 0.21 23797760 0 28065792+ 0.18+ 28016640+ 4218880+:0:0:0:0

PSAPUNDO 20 0 0 977 120094720 5.01 114074816 195 120094720 5.01 114074816 4063232:4063232:4063232:4063232

SYSTEM 2 421 447 3199 6533120 81.43 1213248 2 14336000+ 37.11+ 9016128+ 4096000:3706880:1212352:896:0

Total: 141 33517 44815 1137914 1301295104 72.76 354511296 27340 1363042304 69.46 416258496 29929472:21430272:12823424:11070

BR0280I BRCONNECT time stamp: 2008-08-14 07.35.29

BR0818I Number of tables found in DBDIFF for owner SAPBWP: 2431

BR0280I BRCONNECT time stamp: 2008-08-14 07.35.30

BR0818I Number of tables found in DBSTATC for owner SAPBWP: 100

BR0280I BRCONNECT time stamp: 2008-08-14 07.35.42

BR0819I Number of pool and cluster tables found in DDNTT for owner SAPBWP: 60

BR0962I Check conditions for database administration:

Pos. Act. Lev. Condition Object

Description

1 Y W ARCHIVER_STUCK

Out of space in archive directory - more than 90% space used

2 Y E CONTROL_FILE_MIRROR

Control file not mirrored

3 Y E CONTROL_FILE_MISSING

Control file missing on disk

4 Y W CRITICAL_FILE

File autoextend can cause file system overflow

5 Y W CRITICAL_SEGMENT

Segment can cause tablespace overflow - by allocating up to 2 next extent(s)

6 Y E DATA_FILE_MISMATCH

Data file marked as missing in control file

7 Y E DATA_FILE_MISSING

Data file missing on disk

8 Y E FILE_OFFLINE

Database file offline

9 Y W FILE_SYSTEM_FULL

[Former Member]

Hi Yogesh,

please perform below activity after proper analyzation.

1 Y W ARCHIVER_STUCK this warning is for stuck situation.Your archive directory is 90% full.Take the backup of offline redo files and clean the archive directory.

2 Y E CONTROL_FILE_MIRROR

Your control files should be mirrored which is not the case here. You can do it with sql commands and update the same in control file also.

3 Y E CONTROL_FILE_MISSING

some control files missing.copy the existing control file to the specified directory.

4 Y W CRITICAL_FILE

File autoextend can cause file system overflow

One file system is full,extend it.

5 Y W CRITICAL_SEGMENT

Segment can cause tablespace overflow - by allocating up to 2 next extent(s)

you have critical object in your database check which object is this and extend the tablespace for that object.

6 Y E DATA_FILE_MISMATCH

Data file marked as missing in control file

One datafile is missing recover it manually.

Regards

Ashok

[Former Member]

Hi Yogesh,

the warning

BR0981W Not enough disk space for the total maximum size 30000.000 MB of 4 files of tablespace PSAPBWP640 on disk device 3473409, missing at least 1692.695 MB

means that these datafiles are set to autoextend and that there is not enough free space in the filesystem they are located for these to grow up to their maximum allowed size.

Simple example:

say you have 2 datafiles with autoextend max to 10 GB each. If you put these datafiles in a filesystem of 15 GB, you'll get this warning as they wouldn't be able to grow up to 10 GB each

Solution: change the autoextend max size of these files, move them to another filesystem (not my preferred option) or add some space to the filesystem (if possible)

Sébastien