Home » RDBMS Server » Server Administration » log file generation in oracle (Oracle 10.2.0.1)
log file generation in oracle [message #415063] Fri, 24 July 2009 10:21 Go to next message
sdey
Messages: 20
Registered: May 2009
Junior Member
Hi,

Recently I have installed oracle 10.2.0.1.0 on RHEL 5.3 .It is installed on /opt. At the time of installation free space in /opt was 3 gb. Due to some log file generation the used space is becoming 100%. I want to know how to remove the log file or how to stop generating the log file. I want to implement in test server. Please guide.

Regards,
sdey.
Re: log file generation in oracle [message #415064 is a reply to message #415063] Fri, 24 July 2009 10:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are you sure it is oracle that is causing this?
Did you enable archive logging?
Re: log file generation in oracle [message #415065 is a reply to message #415063] Fri, 24 July 2009 10:26 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
use softlink to volume with more free space
Re: log file generation in oracle [message #415068 is a reply to message #415064] Fri, 24 July 2009 10:41 Go to previous messageGo to next message
sdey
Messages: 20
Registered: May 2009
Junior Member
Hi,

Please find the ARCHIVE LOG details and guide-

SQL> ARCHIVE LOG LIST;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 510
Current log sequence 512

regards,
sdey.
Re: log file generation in oracle [message #415071 is a reply to message #415068] Fri, 24 July 2009 10:53 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You first have to find out WHAT is using that space.

It could be Oracle log files
It could be Oracle table spaces
It could be Some other log files

It can't be archive logs, since they seem to be disabled.

Do you know which files are growing? If not, go into the /opt directory. Do an

du -sm *


Then see which directories are big, then go into them and repeat until you find the files that fill up the place.

How big is /opt by the way?
Re: log file generation in oracle [message #415075 is a reply to message #415071] Fri, 24 July 2009 11:04 Go to previous messageGo to next message
sdey
Messages: 20
Registered: May 2009
Junior Member
Hi,

Please find the details -

[oracle@nandi opt]$ du -sm *
30118 app
1 gconfd-oracle
1 lost+found
0 mapping-oracle
1 orbit-oracle
1 ORCLfmap
1 savedkft5Iy
1 savedozeERr
---------------
[oracle@nandi app]$ du -sm *
664 database
29457 oracle
----------------
[oracle@nandi oracle]$ du -sm *
21496 oradata
7963 product
----------------
[oracle@nandi oradata]$ du -sm *
21496 orcltab

My table space is present in orcltab.
Re: log file generation in oracle [message #415076 is a reply to message #415075] Fri, 24 July 2009 11:21 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Then our tablespaces take up ~20G of the ~30G /opt file system, it seems. How big did you expect the database to grow? Did you calculate that 30Gig would be enough for the data and indexes?

The 8Gig for "product" seems pretty OK. I have a little less than 5 with a pretty minimal slimmed-down install.

You can check which table spaces use the space with the SQLs on this page:
http://www.orafaq.com/wiki/Tablespace
Previous Topic: 11g database of 20 TB (merged 2)
Next Topic: Migrating from 9.2.0.4(32-bit) to 10.2.0.4(64-bit)
Goto Forum:
  


Current Time: Mon Dec 05 08:56:03 CST 2016

Total time taken to generate the page: 0.13302 seconds