oracle DB is full.

[Former Member]

Hi all

In solman server. oracle DB is full.

when server was installed there was no proper planning for DB growth

so after some time they have extended the table space.

now my question is how to create new table space. and is there any changes which i need to do to

the control file FYI

Filesystem Size Used Avail Use% Mounted on

/dev/sda3 14G 6.9G 6.0G 54% /

/dev/sdb2 5.9G 1.7G 3.9G 30% /sapmnt

/dev/sdc2 19G 11G 7.4G 58% /usr/sap

/dev/sdd2 61G 57G 620M 99% /oracle

/dev/sda1 99M 12M 83M 13% /boot

tmpfs 1.9G 1.8G 109M 95% /dev/shm

/dev/sde1 12G 8.6G 2.7G 77% /oracle/SMD/oraarch

/dev/sdf1 17G 12G 4.0G 76% /oracle/SMD/sapdata5

/dev/sdg1 22G 2.2G 19G 11% /oracle/SMD/sapdata6

this is how the file system looks like

Please do help me to reslove this issue...

Thanks and regards

Jude

[fidel_vales]

Hi,

I think it is a little "mess" the one you have there.

As Markus indicated, your oracle filesystem is almost full. and we are talking about 61 GB

I assume you have sapdata1, sapdata2, sapdata3 there.

sapdata5 does not have much free space and sapdata6 has 19G.

So you have some free space where your database can grow. (how much is growing per month?)

/oracle/SMD/oraarch has 8.6 Gb used.

In this directory should be located the archived redo logs.

Are you backing up them?

Are you "deleting" them AFTER the second copy?

Nevertheless, nothing else should be here.

What oracle version are you using?

If 10g, have you installed all relevant patches?

If so, have you "cleaned" the installation afterwards. Installing the patches leave behind some "unneeded" backup files. This can add up to some Gb

> now my question is how to create new table space. and is there any changes which i need to do to the control file FYI

Why do you want to create a new tablespace?

You can use BRTOOLS to do so, you can find the documentation on -> Oracle DBA Overview -> SAP Database Guide: Oracle

You do not need to do anything with the control file (except backing it up, but that is automatically done by BRTOOLS)

[Former Member]

Thanks for your reply.

Filesystem Size Used Avail Use% Mounted on

/dev/sda3 14G 6.8G 6.1G 53% /

/dev/sdb2 5.9G 1.7G 3.9G 31% /sapmnt

/dev/sdc2 19G 11G 7.4G 58% /usr/sap

/dev/sdd2 61G 57G 620M 99% /oracle

/dev/sda1 99M 12M 83M 13% /boot

tmpfs 1.9G 1.8G 108M 95% /dev/shm

/dev/sde1 12G 11G 699M 94% /oracle/SMD/oraarch

/dev/sdf1 17G 12G 4.0G 76% /oracle/SMD/sapdata5

/dev/sdg1 22G 2.2G 19G 11% /oracle/SMD/sapdata6

Please look in to the file system, mount points are different.

Now my question is if i increse the table space or if i move few data's from sap data 1,2 to-wards, sapdata6.

do i need to make the path changes in control file, if yes do please mention thoughes details.

regards

Melvin

[fidel_vales]

> Please look in to the file system, mount points are different.

Can you clarify what are you talking about?

I do not understand the statement at all.

> Now my question is if i increse the table space ... do i need to make the path changes in control file

How do you plan to "increse" the tablespace?

If you use

• BRTOOLS (as I mentioned)

• SQLPLUS (as mentioned on the oracle documentation)

you have to do nothing with the control file, as I already told you

(have you read/understood my reply?)

> Now my question is ... if i move few data's from sap data 1,2 to-wards, sapdata6.

> do i need to make the path changes in control file, if yes do please mention thoughes details.

If you move the datafiles with OS specific commands, then you have to update the "control file", you have to issue some oracle specific commands to do so.

You only have to follow the SAP Note 868750 "How to relocate/rename a datafile"

And, before you ask any other question, you must

1) Read the Oracle concept guide and the administration guide. it seems you do not know anything about oracle and you are administering an oracle database

2) Read the document I mention in my previous mail (also the other documents on the same pages)

3) get some oracle-sap training (ADM505, ADM506)

before you do something that cannot be "repaired" in your DB

[Former Member]

Thank you very much to tell me abt the oracle admi, and basic.

i read and was able to move the datafiles sucessfully.

using BRTOOLS.

once again thank you very much

[markus_doehr2]

You /oracle is almost full. The data itself is under /sapdata*.

Did you save your archive logs?

Markus