Warning in DB13 Check DB "BR0970W Database administration alert"

[Former Member]

Hi

We have an alert message in DB13 when we check the checkdb log. Log details are as below

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: /oracle/EPR/sapdata10/btabd_11/btabd.data11, value: (max_size) 30466040 KB (> 29439485 KB)

This warning is for all the datafiles; I did just give the sample log above.

Can you please suggest and help resolving this issue?

Thanks in advance.

[Former Member]

Hi Kasinath,

Generaly this warning is due to redo logs size.

Try this first:

Go to sql prompt & run the command alter system switch logfile;

Run the same command for 5-6 times. & run the check DB

BR,

Darshan

[Former Member]

Darshan,

sorry to disagree.

This warning is definitely not due to redo logs size.

Kasinath,

follow Eric's advice.

regards

[former_member204746]

Pravin, changing your alert levels will not fix the problem. This warning is important and could cause a database standstill if it is not corrected. it must be taken care of.

ds6478, changing redolog size had no relations with this problem. it will not fix it. Have you really read the error message?

[Former Member]

Eric,

The comment was made in jest.

You had already pointed out the obvious and it is pretty clear from the message what needs to be done or not done.

Datafiles are larger than the maxsize indicated so to be sure they need to change the max_size

Pravin

[Former Member]

Hi,

The issue here is that there is no enough disk space for the datafiles to extend. In this case you can turn off the auto extend or Increase the disk space of sapdata10 or decrease the max_size or you can move some of the datafiles to other directory or filesystem.

You can turn off the auto extend while the database is online. After turning off the auto extend, you need to monitor the datafile/tablespace size periodically.

Regards,

Varadhu

[former_member204746]

possible solutions:

1. add more disk space for /oracle/EPR/sapdata10

2. change max_size for your datafiles: brconnect -c -u / -f dfalter

3. move offending datafiles on another disk

4. hire a DBA.

[Former Member]

Change your alert levels

Pravin