Oracle Space Issue

[Former Member]

Dear All,

i installed 3 instances in 1 server , and my Quality Server its shows

97% /oracle/IRQ/sapdata1

95% /oracle/IRQ/sapdata2

98% /oracle/IRQ/sapdata3

99% /oracle/IRQ/sapdata4

note : i am taking Online Backup once in week (frequency 7days)

how can i resolve this Space issue

pls give me suggestion

ROOT@SAPDEVQA:/#su - orairq

APDEVQA:orairq 1> df -gt

dev/sapqaclv 7.00 1.23 5.77 18% /usr/sap/IRQ

dev/qacexelv 6.00 5.75 0.25 96% /sapmnt/IRQ

dev/oraqacsidlv 4.00 3.11 0.89 78% /oracle/IRQ

dev/oraqachomelv 10.00 3.53 6.47 36% /oracle/IRQ/102_64

dev/sapqacreorglv 2.00 0.02 1.98 1% /oracle/IRQ/sapreorg

dev/qacdata1lv 39.00 37.66 1.34 97% /oracle/IRQ/sapdata1

dev/qacdata2lv 35.00 32.93 2.07 95% /oracle/IRQ/sapdata2

dev/qacdata3lv 42.00 41.08 0.92 98% /oracle/IRQ/sapdata3

dev/qacdata4lv 38.00 37.31 0.69 99% /oracle/IRQ/sapdata4

dev/oqaclogalv 0.50 0.11 0.39 22% /oracle/IRQ/origlogA

dev/mqaclogalv 0.50 0.10 0.40 20% /oracle/IRQ/mirrlogA

dev/mqaclogblv 0.50 0.10 0.40 20% /oracle/IRQ/mirrlogB

dev/oraarchqaclv 10.00 3.26 6.74 33% /oracle/IRQ/oraarch

regards

satheesh

Edited by: satheesh0812 on Dec 4, 2009 6:43 AM

[former_member204746]

you have 2 choices,

1-increase and existing sapdata partition

2-add a new partition (sapdata5)

[Former Member]

Hi Eric,

we have 1 server with 3 Instanence (DEV , Quality , BIW).

we have 320 GB Hard disk now ,

i plan to increase and existing sapdata partitions:

/dev/sapdevlv 7340032 1549552 5790480 22% /usr/sap/IRD

/dev/devexelv 3145728 927604 2218124 30% /sapmnt/IRD

/dev/oradevsidlv 1048576 334684 713892 32% /oracle/IRD

/dev/oradevhomelv 10485760 6855104 3630656 66% /oracle/IRD/102_64

/dev/sapdevreorglv 2097152 22416 2074736 2% /oracle/IRD/sapreorg

/dev/devdata1lv 36962304 29507424 7454880 80% /oracle/IRD/sapdata1

/dev/devdata2lv 36700160 28631488 8068672 79% /oracle/IRD/sapdata2

/dev/devdata3lv 41418752 35806444 5612308 87% /oracle/IRD/sapdata3

/dev/devdata4lv 36700160 26528128 10172032 73% /oracle/IRD/sapdata4

/dev/odevlogalv 524288 112448 411840 22% /oracle/IRD/origlogA

/dev/odevlogblv 524288 112452 411836 22% /oracle/IRD/origlogB

/dev/mdevlogalv 524288 102820 421468 20% /oracle/IRD/mirrlogA

/dev/mdevlogblv 524288 102816 421472 20% /oracle/IRD/mirrlogB

/dev/oraarchdevlv 20185088 3345728 16839360 17% /oracle/IRD/oraarch

/dev/sapqaclv 7340032 1368368 5971664 19% /usr/sap/IRQ

/dev/qacexelv 6291456 1576164 4715292 26% /sapmnt/IRQ

/dev/oraqacsidlv 4194304 3743628 450676 90% /oracle/IRQ

/dev/oraqachomelv 10485760 3703700 6782060 36% /oracle/IRQ/102_64

/dev/sapqacreorglv 2097152 19432 2077720 1% /oracle/IRQ/sapreorg

/dev/qacdata1lv 40894464 39492152 1402312 97% /oracle/IRQ/sapdata1

/dev/qacdata2lv 36700160 34550020 2150140 95% /oracle/IRQ/sapdata2

/dev/qacdata3lv 44040192 43200176 840016 99% /oracle/IRQ/sapdata3

/dev/qacdata4lv 39845888 39124052 721836 99% /oracle/IRQ/sapdata4

/dev/oqaclogalv 524288 114408 409880 22% /oracle/IRQ/origlogA

/dev/oqaclogblv 524288 114404 409884 22% /oracle/IRQ/origlogB

/dev/mqaclogalv 524288 102820 421468 20% /oracle/IRQ/mirrlogA

/dev/mqaclogblv 524288 102824 421464 20% /oracle/IRQ/mirrlogB

/dev/oraarchqaclv 10485760 9273880 1211880 89% /oracle/IRQ/oraarch

/dev/sapbwdevlv 8388608 8330816 57792 100% /usr/sap/IBD

/dev/bwdevexelv 5242880 2362552 2880328 46% /sapmnt/IBD

/dev/orabwdevsidlv 2097152 1864044 233108 89% /oracle/IBD

/dev/orabwdevhomelv 7340032 3684792 3655240 51% /oracle/IBD/102_64

/dev/sapbwdevreorglv 2097152 20648 2076504 1% /oracle/IBD/sapreorg

/dev/bwdevdata1lv 22544384 21261104 1283280 95% /oracle/IBD/sapdata1

/dev/bwdevdata2lv 27262976 25994144 1268832 96% /oracle/IBD/sapdata2

/dev/bwdevdata3lv 20971520 12476120 8495400 60% /oracle/IBD/sapdata3

/dev/bwdevdata4lv 20971520 10387188 10584332 50% /oracle/IBD/sapdata4

/dev/obwdevlogalv 524288 112808 411480 22% /oracle/IBD/origlogA

/dev/obwdevlogblv 524288 112804 411484 22% /oracle/IBD/origlogB

/dev/mbwdevlogalv 524288 102824 421464 20% /oracle/IBD/mirrlogA

/dev/mbwdevlogblv 524288 102820 421468 20% /oracle/IBD/mirrlogB

/dev/oraarchbwdevlv 10485760 7701168 2784592 74% /oracle/IBD/oraarch

how can i partition that 320 GB to three Instanence (DEV, QTY, BW) or i can partition 320 GB to (DEV,QTY,BW)Datafiles only

regards

[Former Member]

If you have space on your server you may extend the data file or add new data file.

[Former Member]

Hi,

Apart from add more space to you filesystems do sime analysis on your QA system

1) How namy clients ? do you need all the clients

2) Archive data reorg tables..This will still show 97% on filesystems but will give your more internal freespace to the tablespaces.

3) If you know you have a lot of freespace in the database. Say after client deletes etc...

Export it as it will reorganise it on the way out (R3load ) method and chuck it back in. (Homogenous system copy)

4) have you had a look for any spurious files that should not be on the sapdata's ?

Mark

[Former Member]

hi,

you should check the file system that enough space..

thanks

ferhan tekin

[Former Member]

Simple....by adding more space.....

Contact your OS admimistrator

Follow the standard installation process

Regards

Nick Loy

[Former Member]

Hi Nick,

currently i bought 300GB HD

now i can partiton that 320 GB to DEV , QTY,PROD

let me give any suggestion

regards

[Former Member]

Hi Nick,

currently i bought 300GB HD

now how i can partiton that 320 GB to DEV , QTY,PROD

let me give any suggestion

regards

[Former Member]

sorry for above mail

Hi Nick,

currently i bought 300GB HD

now i can partiton that 320 GB to DEV , QTY, BI(DEV)

let me give any suggestion

regards

[former_member204746]

ask your Unix admin to do the work for you.

it's up to you to decide how to split these, you are the only one who can evaluate database growth and act accordingly.