Solved

clear log file on oracle10g with RAC

Posted on 2007-11-28
5
413 Views
Last Modified: 2013-12-26
HI EXperts ,

I have a database in a manufacturing environment. This database is running on RAC. When i run a database heatlth check on this database i found out that the Redo log size is 264. It states that redo log file should be close to 0 for the value. So i am thinking of clearing the redo log, BUT since they have RAC implemented, is there anything i should be aware of or lookout for.

thanks.
0
Comment
Question by:orinauts
  • 2
5 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 250 total points
ID: 20374248
Never clear Redo Logs.
This is done by Oracle according complex rules.
Cleaning the Redo Log you can damage the
instance, especially if it crashes.
0
 

Author Comment

by:orinauts
ID: 20379191

But i run a database health check script, i found out that the redo log file size is 1227. does this have any impact on the performance of the database ? as accoring to the health check , it should be close to 0 as possible.


0
 
LVL 47

Expert Comment

by:schwertner
ID: 20380416
I think you misunderstood some notion.
Possibly this what you are speaking about is a wait event
linked with the Redo Log files.
If your DB is running in archivelog mode you have to increase the number of Archiver background processes.

Go beck to the Healt Check and investigate the case ...
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20632807
Forced accept.

Computer101
EE Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now