Increase file system for Oracle Database

[Former Member]

Hi, Gurus

My systems is ECC6.0 Database Oracle 10g, OS: Solaris

Recently, file system SAPDATA1,2,3,4 on OS level is nearly full (4x100GB, used 80-95 %)

I increase file system SAPDATA1,2,3,4 to 4x150GB

but I saw on ST04>Oracle Database Administrator> Space--> Space Overview --> Total Size is 400GB like

not extend to 600GB

Pls help me how to solve

Thank.

[Former Member · Accepted solution]

I think you are using auto extend method for all your table spaces...

I strongly suggest you to change all of them to manual...

And create new FS as sapdata5, sapdata6 etc....and add the new datafiles under newly created FS(sapdata5, data6 etc)

then above situation will not happen...

Search SDN/google datafiles in sap

Regards,

Nick Loy

[Former Member · Accepted solution]

Thank Every body fo advise

I sorry, my quation din't clear

After I increse disk for Oracle database, "Max. autoextensible/kb" on ST02OLD should be over 600,000,000 (600G)

Now, ST02OLD show "Max. autoextensible/kb = 405,123,840" (400G)

<br>

Now ST04 show

W 09.02.2010 07:30:15 4 DBA TABLESPACE_FULL 1 Tablespace: PSAPSR3, value: 95.61% (> 95%) # Tablespace full

<br>

I think this alert show because Oracle remember old disk space (400G) Oracle cannot extend tablespace, thsi I already increase disk to 600G

How can i do, Max. autoextensible/kb must show new disk space.

[Former Member · Accepted solution]

Hi,

There is nothing wrong in adding datafiles to extend tablespace manually using BRTools.

You can add some datafiles manually, I am not sure but next time, you can see the 600GB instead of 400GB.

Just try this...

Regards.

Rajesh Narkhede

[Former Member · Accepted solution]

Hi, Rajesh

I already manual add datafile by brtools, size is change

Thank you

[mohammadwahidullah]

Hi Witoon,

1. Just Logon to OS user ORA<SID>

2. Start "brtools"

3. Choose "Space management"

4. Then Choose "Extend Tablespace"

and then as you want to do ......

Regards

Wahid

[Former Member]

Hi,

If you have enough free diskspace you can extend the logical volume on OS level.

Then you can extend the tablespace by adding more datafile in to required Tablespace. For this you can use BRTools.

Hope, you know the procedure for this.

Regards.

Rajesh Narkhede

[Former Member]

Hi, Rajesh

I saw tablespace setting is auto extend,

I will change by manual ?

Best Regards,

Edited by: Witoon Dachapitak on Feb 1, 2010 5:05 AM

[Former Member]

Hi,

If your logical volumes are about 85% full, you need to extend the "LOGICAL VOLUMES" on OS level using "lvextend" command

(see "man lvextend" for more details)

and

If your tablespace is full, you need to add datafiles if required using BRTOOLS,...

If you tablespace is set to "autoextend", then no probs. but it is must to extend logical volumes manually...

Hope, it will clear your doubts.

Regards.

Rajesh Narkhede