Getting error/warning while extending Table space

[Former Member]

Hello All ,

While extending Table space getting below error , please advise can we extend the same .

BR0280I BRSPACE time stamp: 2013-04-14 16.13.02

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/BRP/sapdata7 for total maximum size of all database files of tablespace PSAPXER located on this disk volume, missing at least 24537.160 MB

BR0280I BRSPACE time stamp: 2013-04-14 16.13.02

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

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

Note : File system have more space at OS level (26 GB)

/dev/lvBRPsapdata7 204800.00 179232.16  25567.84   88% /oracle/BRP/sapdata7

even i have tried below file system (each file system have nearly 40GB free) , i got the same error/warning .

/dev/lvBRPsapdata10 179200.00 158269.57  20930.43   89% /oracle/BRP/sapdata10

/dev/lvBRPsapdata11 179200.00 142269.61  36930.39   80% /oracle/BRP/sapdata11

/dev/lvBRPsapdata12 179200.00 138269.73  40930.27   78% /oracle/BRP/sapdata12

/dev/lvBRPsapdata13 179200.00 138269.55  40930.45   78% /oracle/BRP/sapdata13

/dev/lvBRPsapdata14 179200.00 138267.83  40932.17   78% /oracle/BRP/sapdata14

/dev/lvBRPsapdata15 179200.00 138268.67  40931.33   78% /oracle/BRP/sapdata15

/dev/lvBRPsapdata16 179200.00 138267.83  40932.17   78% /oracle/BRP/sapdata16

/dev/lvBRPsapdata17 179200.00 138267.80  40932.20   78% /oracle/BRP/sapdata17

Please advise.

Thanks

[karthikeyan_natarajan4]

Hi John,

what happened? Are you able to find a solution for this? Please keep us posted.

regards

karthik

[former_member185239]

Hi John,

Can you please tell me the size of any one datafile present in /sapdata7. I think you are creating the datafile of size 24 GB round.

How far i can annalyze , it is calculating the next datafile size to be created.

you can create a 8 GB datafile , and can check it.

With Regards

Ashutosh chaturvedi

[Former Member]

Hi ,

We trying to extend 4GB datafile . please check below details .

1 * Last added file name (lastfile) ....... [/oracle/BRP/sapdata7/xer_286/xer.data286]

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

3 - New file to be added (file) ........... [/oracle/BRP/sapdata7/xer_287/xer.data287]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPXER add datafile '/oracle/BRP/sapdata7/xer_287/xer.data287' size 4000M autoextend off]

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

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2013-04-14 17.57.03

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in /oracle/BRP/sapdata7 for total maximum size of all database files of tablespace PSAPXER located on this disk volume, missing at least 28533.312 MB

BR0280I BRSPACE time stamp: 2013-04-14 17.57.03

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

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

Note :

file system /oracle/BRP/sapdata7 have 21 GB free space .

/dev/lvBRPsapdata7 204800.00 183232.24  21567.76   90% /oracle/BRP/sapdata7

Please advise .

[former_member185239]

Hi John,

Just continue with it and check whether it is able to create the new control file or not.

If you get error , regarding the permission to create a new control file ,

Then you need to check the permission of brtools tool as per the sapnote :

SAP Note : 546006 and 651351

or you can run the saproot.sh <DBSID> command with the root user :

Now steps to do :

1.

BR0280I BRSPACE time stamp: 2013-04-14 17.57.03

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

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

Just continue after this , check whether you are getting the permission error or not.

Then just follow the above sapnote or run the saproot.sh located in kernel directory.

With Regards

Ashutosh Chaturvedi

[former_member185239]

Hi John,

You can follow the below link as well

http://scn.sap.com/thread/524780

With Regards

Ashutosh Chaturvedi

[former_member188883]

Hi John,

BR1049W Not enough free space in /oracle/BRP/sapdata7 for total maximum size of all database files of tablespace PSAPXER located on this disk volume, missing at least 28533.312 MB
BR0280I BRSPACE time stamp: 2013-04-14 17.57.03
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

If you have enough space on the disk, you may ignore this warning and continue ahead.

Such warning appears due to some datafiles having auto extend ON feature. Based on the extents define brtools check whether there shall be enough space to manage those extents.

Hope this helps.

Regards,

Deepak Kori

[karthikeyan_natarajan4]

Hi John,

I got the same error when i try to upgrade my BW with BPC system in extending tablespace PSAPTEMP, steps i followed was

1. Create a new control file by copying the existing control file

2. use brtools to extend the tablespace and change the autoextend to OFF.

regards

karthik