Unsolved
This post is more than 5 years old
225 Posts
0
633
Why is the archive redo log size quite small?
As my understanding, size of archive redo log should equals or be slightly less than size of redo log.
I got a scenario,
2 nodes RAC on Redhat
Redo log size, 200M
There are many 1xMB archive redo log on it, any idea?
Eddy
dba_hba
63 Posts
0
April 26th, 2012 04:00
Small archive logs indicate that a redo log switch is being forced before it fills up.
This happens at normal shutdown of an instance in archivelogmode or by the following SQL commands
ALTER SYSTEM ARCHIVE LOG CURRENT; -- all instances
ALTER SYSTEM SWITCH LOGFILE; -- instance level
Are there scripts being run regularly which are doing this?
Is there a standby database are the shipping archive logs?
reseach
225 Posts
0
April 26th, 2012 18:00
Upon information I received, here is response to your inquiries.
Are there scripts being run regularly which are doing this?
No sure, the Frond End is commercial barcode scan application.
Is there a standby database are the shipping archive logs?
No.
The following conversation with DBA, there is something interesting.
In their former configuration, single instance (no RAC), setting of size is 50, average size of arch redo log is about 45MB
Then, configured their system with RAC, setting of size is 50, average size of arch redo log is about 3MB
During the process, no SQL change on application.
Any idea?
Eddy