Unable to Extend Tablespace

[Former Member]

Dear Gurus,

I am trying to extend "tablespace PSAPSR3" through BR*tools. However I'm getting Warning, when I continue. Below are the log entries.

Please help me to extend "tablespace PSAPSR3"

BR0280I BRSPACE time stamp: 2011-08-09 11.27.56

BR0657I Input menu 303 - please check/enter input values

-

---

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/SID/sapdata4/sr3_24/sr3.data24]

2 * Last added file size in MB (lastsize) . [512]

3 - New file to be added (file) ........... [/oracle/SID/sapdata4/sr3_25/sr3.data25]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [512]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [4000]

8 - File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/SID/sapdata4/sr3_25/sr3.data25' size 512M autoextend off next 20M maxsize 4000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2011-08-09 11.28.01

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/SID/sapdata4/sr3_25 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 32537.573 MB

BR1049W Not enough free space in /oracle/SID/sapdata4/sr3_25 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 12521.573 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRSPACE time stamp: 2011-08-09 11.28.01

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

BR0280I BRSPACE time stamp: 2011-08-09 11.28.06

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

Thanks and Regards

Ahsan

[former_member188883]

Hi Ahsan,

Set the autoextend parameter value to NO and try this command. It should work and you can extend space in tablespace.

Your system does not have enough space to accomodate extends from all the datafiles listed in the error.

Regards,

Deepak Kori

[Former Member]

Hello,

The two messages are just warnings and as far as I can make out from the fragment of BRSPACE output that you included the tablespace did get extended. The reason for the warnings is that you use auto-extend and BRSPACE warns you that there is not enough space in the file system to let all the file grow to their Maximum File Size. A simple example: suppose you have only 2 GB free in the file system and you create a data file of 500 MB but with auto-extend and a maximum size of 3 GB. In that case you would get the warning from BRSPACE but the 500 MB data file would still be created. However, later on you might have a problem because the file cannot grow to 3 GB.

Hope this helps,

Mark

[Former Member]

Hi Ahsan,

Please add more space to /oracle/SID/sapdata4 or you can use another sapdata* filesystem if that much amount of free space is present in them.

You can check it by executing the UNIX command df -g | grep sapdata

Regards,

Hari Kishan

[Former Member]

Dear Sir,

Following is the output.

1. df -g | grep sapdata

/dev/fslv20 50.00 19.06 62% 30 1% /oracle/ANP/sapdata1

/dev/fslv21 50.00 19.80 61% 24 1% /oracle/ANP/sapdata2

/dev/fslv22 50.00 11.55 77% 24 1% /oracle/ANP/sapdata3

/dev/fslv23 50.00 16.26 68% 42 1% /oracle/ANP/sapdata4

I think there is enough space in File System. Now please suggest.

Regards

Ahsan

[Former Member]

Either increase the filesystem sapdata4 or create a new filesystem sapdata5. Then use the brtools to add more datafiles.

[Former Member]

Hi Ahsan,

>> BR1049W Not enough free space in /oracle/SID/sapdata4/sr3_25 for total maximum size of all database files of tablespace >> PSAPSR3 located on this disk volume, missing at least 32537.573 MB

>> BR1049W Not enough free space in /oracle/SID/sapdata4/sr3_25 for total maximum size of all database files of tablespace >> PSAPSR3700 located on this disk volume, missing at least 12521.573 MB

>> Maximum file size in MB (maxsize) ..... 4000

It is obvious that you have no enough storage. Add a new logical volume, for example "sapdata5" and create new datafiles on it. Or add more disk to sapdata4

Best regards,

Orkun Gedik

[Former Member]

In short, there's no enough storage for PSAPSR3 and PSAPSR3700 to extend, when these datafiles have reached to the max size.

You need 12521.573 MB + 32537.573 MB free space, on the sapdata4 in order to extend the datafiles belong to PSAPSR3 and PSAPSR3700.

Best regards,

Orkun Gedik