| 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.
|
|
|
|
|
|
|
|
| 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.
|
|
|
|
| Re: log file generation in oracle [message #415071 is a reply to message #415068] |
Fri, 24 July 2009 10:53 |
ThomasG
Messages: 3211
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
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 |
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 |
ThomasG
Messages: 3211
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
