Re: Space Getting Filled up in Oracle RAC 10G

Re: Space Getting Filled up in Oracle RAC 10G

 

  

Anand,

If you think you have a file growing out of control, try the find command:

# cd /oracle
# find . -size +10000000n -print

will search recursively thru the current directory and below (in this
case /oracle) and list all files 10 MB or larger.

If you think you have a process creating tons of small files, then I use
du -k to try to isolate which directory is uncharacteristically large.
It recurses the current directory as well.

Jack

Anand Solomon wrote:

>
>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.
>
>
>
>
>
>
>
>--------
>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
>
>
>
>


Oracle LazyDBA home page