RE: Space Getting Filled up in Oracle RAC 10G

RE: Space Getting Filled up in Oracle RAC 10G

 

  

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
[mailto:oracledba-ezmlmshield-x65455715.[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