| Archivelog Every 30 Seconds [message #545687] |
Thu, 01 March 2012 12:34  |
|
|
Our database was generating archivelog(50MB) every 30seconds! I think this is not normal because what I did is open our database, I was the only one who is connected, I'm not running anything, but our database is still generating archivelogs!
Our redo logs: 6groups 3members.
This are the things I saw on our alert logs:
- advanced to log sequence
- cannot allocate new log, sequence
- checkpoint not complete
- private strand flush not complete
What I did is change the log mode of our database to noarchivelog then open the database, then returned it to archivelog mode then that fixed the problem. But the thing is after 6hours its abnormal behavior goes back again.
|
|
|
|
|
|
| Re: Archivelog Every 30 Seconds [message #545869 is a reply to message #545687] |
Fri, 02 March 2012 19:27  |
|
|
@John Watson: Thanks!
I've checked the crontab of the server and it only runs Export and RMAN Backup. Then I checked the DBA_JOBS and saw that there were two jobs. SYS runs the DBMS_STATS.gather_schema_stats and SYSMAN runs EXECUTE_EM_DBMS_JOB_PROCS. A senior DBA told me to run the 10.2.0.5 patch set and stop/disable the EXECUTE_EM_DBMS_JOB_PROCS because this is the one causing the problem.
I'll share if this is the solution to our problem.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
