Facing errors in increasing tablespace size

[Former Member]

Hello Everyone,

I was trying to increase the size of one of my tablespaces PSAPSR3 ,while increasing iam facing error as :

<b>BR0651I BRTOOLS 7.00 (24)

BR0280I BRTOOLS time stamp: 2007-08-16 17.51.58

BR0656I Choice menu 1 - please make a selection

-

---

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

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

-

---

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2007-08-16 17.52.00

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2007-08-16 17.52.00

BR0656I Choice menu 5 - please make a selection

-

---

Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset program status

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

-

---

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2007-08-16 17.52.02

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2007-08-16 17.52.02

BR0657I Input menu 81 - please check/enter input values

-

---

BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initSMD.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... []

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initSMD.sap -s 20 -l E -f tsextend]

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

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2007-08-16 17.53.28

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initSMD.sap -s 20 -l E -f tsext

end'

BR0280I BRTOOLS time stamp: 2007-08-16 17.53.28

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

c

BR0280I BRTOOLS time stamp: 2007-08-16 17.53.32

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.00 (24)

BR1002I Start of BRSPACE processing: sdvycmdw.tse 2007-08-16 17.53.32

BR0484I BRSPACE log file: I:\oracle\SMD\sapreorg\sdvycmdw.tse

BR0280I BRSPACE time stamp: 2007-08-16 17.53.36

BR1009I Name of database instance: SMD

BR1010I BRSPACE action ID: sdvycmdw

BR1011I BRSPACE function ID: tse

BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2007-08-16 17.53.36

BR0656I Choice menu 301 - please make a selection

-

---

Tablespace extension main menu

1 = Extend tablespace

2 - Show tablespaces

3 - Show data files

4 - Show disk volumes

5 * Exit program

6 - Reset program status

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

-

---

BR0662I Enter your choice:

1

BR0280I BRSPACE time stamp: 2007-08-16 17.53.57

BR0663I Your choice: '1'

BR0280I BRSPACE time stamp: 2007-08-16 17.53.59

BR0658I List menu 302 - please select one entry

-

---

List of tablespaces for extension

Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB]

1 - PSAPSR3 11/11 19292160 94.17 1124480 112640000

2 - PSAPSR3700 8/8 22476800 51.43 10916480 81920000

3 - PSAPSR3DB 3/3 5120000 45.88 2770752 30720000

4 - PSAPSR3USR 1/1 20480 6.56 19136 10240000

5 - PSAPTEMP 1/1 870400 0.35 867328 10240000

6 - PSAPUNDO 1/1 3973120 0.00 3973056 10240000

7 - SYSAUX 1/1 204800 81.19 38528 10240000

8 - SYSTEM 1/1 460800 99.72 1280 10240000

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

-

---

BR0662I Enter your selection:

1

BR0280I BRSPACE time stamp: 2007-08-16 17.56.25

BR0663I Your selection: '1'

BR0280I BRSPACE time stamp: 2007-08-16 17.56.25

BR0657I Input menu 303 - please check/enter input values

-

---

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [I:\ORACLE\SMD\SAPDATA2\SR3_11\SR3.

DATA11]

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

3 - New file to be added (file) ........... [I:\oracle\SMD\sapdata2\sr3_12\sr3.

data12]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPSR3 add dataf

ile 'I:\oracle\SMD\sapdata2\sr3_12\sr3.data12' size 420M autoextend on next 20M

maxsize 10000M]

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

-

---

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2007-08-16 18.03.04

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in I:\oracle\SMD\sapdata2\sr3_12 for total maximum

size of all database files of tablespace PSAPSR3 located on this disk volume, m

issing at least 77587.810 MB

BR1049W Not enough free space in I:\oracle\SMD\sapdata2\sr3_12 for total maximum

size of all database files of tablespace PSAPSR3700 located on this disk volume

, missing at least 44477.810 MB

BR1049W Not enough free space in I:\oracle\SMD\sapdata2\sr3_12 for total maximum

size of all database files of tablespace PSAPSR3DB located on this disk volume,

missing at least 11427.810 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

BR0280I BRSPACE time stamp: 2007-08-16 18.03.04

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

The total size of I drive where all my data files is there is 64 GB and free space in it is 13.6 GB . Plz revert why this error is occuring? when here iam adding a data file its new size is 420 MB and autoextend size is 20 MB only na .................and free sapce in I drive is 13.6 gb then why is it giving error?Plz revert

Secondly i also want to know what exactly does happen when iam increasing the tablespace size ,how the data files are added and suppose if a tablespace contains data files in two separate drives in two folders then when we increase the tablespace size,where wll the data file corresponding to tat tablespace formed?

Also can we define the size of new data file formed and autoextend size also .

Plz detail the entire procedure corresponding to tablespace increase with wt exactly happens when it is done,bcoz iam a bit confused.

A helpful detailes solution sahll be appreciated. If a document could be snd supporting it ,it shall be helpful. my Email Id is reachme.saumya@gmail.com .

Points guaranteed

Regards,

Somya

[Former Member]

Somya ,

Please check the path of the datafile to be added .I:\oracle\SMD\sapdata2\sr3_12\sr3.data12 ..i believe it should be <b>sapdata12</b> instead sapdat2 i.e I:\oracle\SMD\<b>sapdata12</b>\sr3_12\sr3.data12 ...Please let me know the update..Hope this will solve the issue.

Regards,

Gokul

[Former Member]

Nopes its sapdata2 only .Plz revert .

Also rever over other issues and concerns tat i raised in the message.

Regards

[Former Member]

Hello Experts,

Requested to revert over this. someone plz help.

Thanks

[markus_doehr2]

Your tablespaces are created using autoextend. The error message you see is, that there´s not enough space to autoextend them to the maximum (10000 MB) because there´s not enough filesystem space.

--

Markus

[Former Member]

But free space in i drive is 13.6 gb .

Revert soon,

Reagrds

[markus_doehr2]

yes - but there's not enough space for ALL files reaching 10 GB... that's what brspace is talking about.

If you have 8 files there and all 8 have a maxsize of 10 GB you need to have 80 GB space.

--

Markus

[Former Member]

didnt get it,when iam increasing a tablespace iam adding just 420 mb size datfile na. then y it need 10 Gb for each datfile. In tat case in i drive my total siz is 64 gb ,till now there are 11 data files formed 10 files of size 1.95 gb and last 11th one of 420 MB ,i got error while creating 12th file.

Then for 11 files ,it should require 1100 GB size which is not there?

Also when iam adding a single data file ,wld it check space for all other data files ? if not wll it give error............................................completely confused...................................if u could explaiin in detail,it shall be helpful.

Regards,

Somya

[markus_doehr2]

Yes - that's your problem.

See what you gave:

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

that means, that the file can increase up to 10 GB (using extents). By default, all files are configured like this (this is Oracle), and now brspace is telling you, that there's not enough space to add another datafile because the maximum size of all files is bigger than your harddisk.

--

Markus

[former_member204746]

Somya, check your parameters:

1 * Last added file name (lastfile) ....... [I:\ORACLE\SMD\SAPDATA2\SR3_11\SR3.

DATA11]

2 * Last added file size in MB (lastsize) . [<b>420</b>]

3 - New file to be added (file) ........... [I:\oracle\SMD\sapdata2\sr3_12\sr3.

data12]

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

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

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

7 - Maximum file size in MB (maxsize) ..... [<b>10000]</b>

8 - File increment size in MB (incrsize) .. [<b>20</b>]

option 2: your datafile will use 420MB to begin with.

option 7: it can grow up to 10000MB

option 8: it will grow with increments of 20MB

so, you need at least 10GB in your filesystem.

your warnings are saying that datafiles of 3 tablespaces, if they grow to their maximum file size, will overflow your filesystem (PSAPSR3,PSAPSR3700,PSAPSR3DB).

solutions:

1. increase filesystem size

2. decrease value of maximum size of datafiles, I would especially check the maximum size of ALL datafiles of PSAPSR3.

3. move some datafiles on another filesystem.

good luck.

[Former Member]

Hi Eric,

U said i need 10 gb space in my file ssyetm ,i have 13.6 gb in i drive????????????????????????

Plz also revert over other issues raised in first message.............................??????????????????????????

Regards,

Somya

[markus_doehr2]

ALL (read: <b>ALL</b>) files were created using a max size of 10 GB so ALL files together must fit with the maximum size on your harddisk, which is not the case.

It's NOT about the single file you are adding but ALL files.

--

Markus

[Former Member]

Thnx Markus assigned u points ............................plz reveert over other opened threads of mine also ....................

Regards,

Somya

[Former Member]

As of my knowledge, when you increase the size of the table space, the data file gets used.Now which data file is used is shown while adding the space itself.Inyour case I think its sapdata12.While the other questions remains for which I would also like to know the solution and also the solution for your error.

Hope it could clear some fog from your mind.

Regards,

Amit