cancel
Showing results for 
Search instead for 
Did you mean: 

How to extend tabelspaces - Oracle 10.2, brtools, brspace

Former Member
0 Kudos

Hi.

I'm new to basis issues and I'm having problems installing support package 15 (with SPAM). The process is abending and I think the problem is space.

I see in db02 the tablespace PSAP<sid> is almost full, with 96%.

I've tried to extend with brtools but I don't know how to do this. Ansewering the questions I got to menu that shows (I think) the command to process (brspace), but I don't konw how to commit. I also don't know how to define the units of extension, in bytes, number of files, etc.

What is the pre-requisites to extend a table? The system must be up or must not?

Command samples for brspace will be very appreciated.

Thanks in advance,

Paulo

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

If your table space is full you have to add Datafile or resize existing Datafile.

To add datafile please do as specified below.

1.If yours is unix login as ora<SID> and type brtools at command prompt.

2.in the menu select 2,space management

3.in the next menu select 1.extend table space

3.In the next menu select 3,tablespace name and it prompts for the name and type PSAPUNDO.

4.CONTINUE

5.CONTINUE

6.you will get the following screen.

Options for extension of tablespace PSAPUNDO (1. file)

1 * Last added file name (lastfile) ....... [/oracle/CRD/sapdata2/undo_1/undo.d

ata1]

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

3 - New file to be added (file) ........... [/oracle/CRD/sapdata2/undo_2/undo.d

ata2]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add data

file '/oracle/CRD/sapdata2/undo_2/undo.data2' size 6800M autoextend off]

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

-


7.choose 5 if you want to specify size of Datafile.Also check whether enough space is available at OS level to add this datafile.(use df -k "path of directoy" to check space

8.click on continueand it will take few minutes to add the datafile and your tablespace is now extended!

You can execute this when SAP is Up and running,no need to stop SAP or DB

Former Member
0 Kudos

Hi Tanuj, thanks for your attention.

I have windows xp professional.

Why to extend PSAPUNDO if the tablespace with problems is PSAPsid? I've already done this procedure, but nothing happened. Do I need to log as a special OS user?

Regards,

Paulo

Former Member
0 Kudos

Hi Paulo,

Yes, you need to extend PSAPsid not PSAPUNDO.

I think Tanuj just wanted to give you an example where to look for tablespace extension menu.

Basically, you can either add new datafile to your tablespace (BRTOOLS=>Space management => Extend tablespace, click to continue and you will see a list of tablespaces you can extend) or there is an option for datafile extension (BRTOOLS=>Space management => Alter datafile). In this second option you would need to resize any of the existing datafiles for your tablespace. Be careful not to exceed the limit of the datafile size (depending on you db_block_size parameter)

Regards,

Mike

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks guys!

Paulo

Former Member
0 Kudos

Ok, thanks guys.

Mike, could you please explain what is the problem with db_block_size parameter?

Regards,

Paulo

Former Member
0 Kudos

Hi Paulo,

There are no any problems with db_block_size. I was just saying that if you decided to extend your tablespace by extending it datafiles, you would need to keep in mind the maximum size of the datafile. Maximum size of a datafile depends on the db_block_size parameter defined for your DB.

Here is the dependency table:

BLOCK SIZE MAXIMUM DATA FILE SIZE

32 K 128 GB

16 K 64 GB

8 K 32 GB

4 K 16 GB

2 K 8 GB

It means if you have db_block_size value equal to (let's say) 8K, you cannot create/extend a datafile more then 32 GB in size.

Regards,

Mike

pr_srinivas
Contributor
0 Kudos

brspace -f tsextend

command will take you to the TS EXTEND MENU

select option - 1

rest of them you vane manage !!

Rgds

PR

Former Member
0 Kudos

Hi paulo,

Adding a datafile using BRTOOLS

1) su – ora<sid>

2) start brtools

3) Select option 2 -- Space management

4) Select option 1 -- Extend tablespace

5) Select option 3 --Tablespace name (specify tablespace name) and say continue(c- cont)

6) Select option 3 – New data file to be added and return

7) Select option 5 -- Size of the new file in MB (specify the size of the file) and say continue

regards,

kanthi

Former Member
0 Kudos

Hi,

I just gave an example with SAPUNDO.

I did not understnad your question . Do you mean to say that although you have extended the required tablespace.

Once you complete all the steps ,You can see the following information " Eexecution of BRSPACE finished successfully".

you can check in DB02 for the tablespace whether the New Data file is added or not.

In DB24 , You can also see logs for all the DB level activities.

and in DB02.

Refresh --> DB Checks and Update Histories.

This will refresh the percentage ....

Thanks,

Tanuj