Hi John,
Thanks for the info. But we have deleted all the log, trc files under
audit_dump_dest, background_dump_desc, user_dump_dest, cor_dump_dest, ,
and we have found still the space is not shrinked..
And also ORACLE_HOME/network/log is not having any files.

Not sure wht is the issue. Your help is greatly appreciated.



Thanks
Anand

-----Original Message-----
From: Chamberlain John [mailto:John.[Email address protected]
Sent: Wednesday, May 10, 2006 5:55 PM
To: Anand Solomon
Subject: Spam:SPAM:RE: Space Getting Filled up in Oracle RAC 10G

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


My guesses...

1. You are getting trace/dump files written to $ORACLE_HOME/dbs. Check
for sub directories cdmp* or similar and clear if not required. You
should set audit_dump_dest, background_dump_desc, user_dump_dest,
cor_dump_dest to be outside your $ORACLE_HOME tree. Dependant on how you
have configured the DB, you may be getting archive redo going there too.
Check these and fix.

2. Check $ORACLE_HOME/network/log. Do you have a huge/growing
listener.log (or trace files) in there? These can be removed (bounce the
listener after deleting).

3. Check the admin directory ($ORACLE_BASE/admin/*) where trace files,
alert logs, etc may go by default. Clear down if there are lots and find
out why there are lots too!

HTH
John.


-----Original Message-----
From: Anand Solomon
[Email address protected]
Sent: 10 May 2006 12:56
To: LazyDBA Discussion
Subject: Space Getting Filled up in Oracle RAC 10G

Hi,
I have installed Oracle 10G RAC server on top of ASM and CRS. I have 2
nodes and one sunstoredge device. As we are working on the RAC machine,
the space is getting filled up very fastly. Not sure if it is a OS issue
or DB issue. But the space occupied more is under my Oracle Directory.

Can you please any one let me know about this?

Thanks
Anand



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html

-----------------------------------------
Information in this email including any attachments may be privileged,
confidential and is intended exclusively for the addressee. The views
expressed may not be official policy, but the personal views of the
originator. If you have received it in error, please notify the sender
by return e-mail and delete it from your system. You should not
reproduce, distribute, store, retransmit, use or disclose its contents
to anyone.

Please note we reserve the right to monitor all e-mail communication
through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting Group
plc and are used under licence. British Sky Broadcasting Limited
(Registration No. 2906991), Sky Interactive Limited (Registration No.
3554332), Sky-In-Home Service Limited (Registration No. 2067075) and Sky
Subscribers Services Limited (Registration No. 2340150) are direct or
indirect subsidiaries of British Sky Broadcasting Group plc
(Registration No. 2247735). All of the companies mentioned in this
paragraph are incorporated in England and Wales and share the same
registered office at Grant Way, Isleworth, Middlesex TW7 5QD.






Oracle LazyDBA home page