Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

clear log file on oracle10g with RAC

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
orinauts
Asked:
orinauts
  • 2
1 Solution
 
schwertnerCommented:
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
 
orinautsAuthor Commented:

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
 
schwertnerCommented:
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
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now