OraFAQ Forum: Server Administration » log file generation in oracle

Home » RDBMS Server » Server Administration » log file generation in oracle (Oracle 10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

log file generation in oracle [message #415063]

Fri, 24 July 2009 10:21

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.

Report message to a moderator

Re: log file generation in oracle [message #415064 is a reply to message #415063]

Fri, 24 July 2009 10:26

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you sure it is oracle that is causing this?
Did you enable archive logging?

Report message to a moderator

Re: log file generation in oracle [message #415065 is a reply to message #415063]

Fri, 24 July 2009 10:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

use softlink to volume with more free space

Report message to a moderator

Re: log file generation in oracle [message #415068 is a reply to message #415064]

Fri, 24 July 2009 10:41

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.

Report message to a moderator

Re: log file generation in oracle [message #415071 is a reply to message #415068]

Fri, 24 July 2009 10:53

ThomasG
Messages: 3212
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?

Report message to a moderator

Re: log file generation in oracle [message #415075 is a reply to message #415071]

Fri, 24 July 2009 11:04

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.

Report message to a moderator

Re: log file generation in oracle [message #415076 is a reply to message #415075]

Fri, 24 July 2009 11:21

ThomasG
Messages: 3212
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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:43:54 CST 2024