error during DB check

[Former Member]

Hi Experts,

We are getting error message(detail log is attached) in our Production server during the DB check through planning clander.As per mu understanding it shows the error related to space .

Please suggest for the corrective action.

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK_1\SKK.DATA1, value: (max_size) 8192000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK_2\SKK.DATA2, value: (max_size) 8192000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK_3\SKK.DATA3, value: (max_size) 8192000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK640_1\SKK640.DATA1, value: (max_size) 8192000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK640_2\SKK640.DATA2, value: (max_size) 8192000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK640_3\SKK640.DATA3, value: (max_size) 8192000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK640_4\SKK640.DATA4, value: (max_size) 9216000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKKUSR_1\SKKUSR.DATA1, value: (max_size) 10219520 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA3\TEMP_1\TEMP.DATA1, value: (max_size) 9625600 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA2\UNDO_1\UNDO.DATA1, value: (max_size) 9216000 KB (> 7770948 KB)

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA1\SYSTEM_1\SYSTEM.DATA1, value: (max_size) 9676800 KB (> 7770948 KB)

[former_member204746 · Accepted solution]

here's what thie first message means:

BR0970W Database administration alert - level: WARNING, type: CRITICAL_FILE, object: D:\ORACLE\SKK\SAPDATA4\SKK_1\SKK.DATA1, value: (max_size) 8192000 KB (> 7770948 KB)

file is autoextendable. if it would grow to its maximum size, you would not have enough disk space to accomodate it. Maxsize if 8GB, but only 7.7GB remains on disk.

so, a few possibilities:

1. increase disk space

2. decrease maximum size of datafile

3. move datafile on other disk

4. a combination of previous 3 solutions.

[Former Member · Accepted solution]

Hi Eric,

Can you please tell me why it was giving warning?

Thanks