on 05-30-2007 2:04 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Thanks guys!
Paulo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, thanks guys.
Mike, could you please explain what is the problem with db_block_size parameter?
Regards,
Paulo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
brspace -f tsextend
command will take you to the TS EXTEND MENU
select option - 1
rest of them you vane manage !!
Rgds
PR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.