| How can I to resolve the redo log question? [message #49965] |
Wed, 20 February 2002 23:40  |
mhy
Messages: 15
Registered: March 2001
|
Junior Member |
|
|
dear sir
How can I to resolve the following questions be found in my db alert log file?
the size of every log file is 5M and there are 3 redo log groups in my database.
the checkpoint parameters are:
db_block_size 8192
log_checkpoint_interval integer 10000
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
part warning of alert log is :
Thread 1 advanced to log sequence 7876
Current log# 4 seq# 7876 mem# 0: /oracle/OraHome1/oradb/oradata/oracle8i/redo0
401.log
Current log# 4 seq# 7876 mem# 1: /oracle/OraHome1/oradb/oradata/oracle8i/redo0
402.log
Thread 1 advanced to log sequence 7877
Current log# 5 seq# 7877 mem# 0: /oracle/OraHome1/oradb/oradata/oracle8i/redo0
501.log
Current log# 5 seq# 7877 mem# 1: /oracle/OraHome1/oradb/oradata/oracle8i/redo0
502.log
Thu Feb 21 16:59:29 2002
Thread 1 advanced to log sequence 7878
Current log# 6 seq# 7878 mem# 0: /oracle/OraHome1/oradb/oradata/oracle8i/redo0
601.log
Current log# 6 seq# 7878 mem# 1: /oracle/OraHome1/oradb/oradata/oracle8i/redo0
602.log
|
|
|
|
| Re: How can I to resolve the redo log question? [message #49975 is a reply to message #49965] |
Thu, 21 February 2002 06:18  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
The ALERT.LOG looks perfectly fine. There are no errors or warnings there.
What were you worried about?
BOTTOM LINE:
Every time there is a log switch, there is an entry in the alert.log.
HINTS:
You have 3 redo logs of 5M each. May wanna add at least 1 more redo log (of 5M), even better add 2. At least 4 redo logs of 5M looks sufficient for what you are doing.
Have you seen any 'checkpoint not complete' in the alert log?
|
|
|
|
| Re: How can I to resolve the redo log question? [message #49988 is a reply to message #49965] |
Thu, 21 February 2002 18:44 |
mhy
Messages: 15
Registered: March 2001
|
Junior Member |
|
|
thanks a lot!
'checkpoint not complete' happened in the alert file before I increase the size of log file.the size of old log file is 512K,it was too small,so I changed it to 5M.
for your advice,will I add the number of log file groups or the members of each log file group? I can't decide how to do next.
|
|
|
|
| Re: How can I to resolve the redo log question? [message #49994 is a reply to message #49988] |
Fri, 22 February 2002 03:09 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
The number of log file group. Make it either 4 or 5 log groups.
Adding member in the group does not really matter at this moment. Remember, in a group, member B is a REPLICA of member A. You have 2 members as a redundant system. Group 1 has member A and B of 5 MB each does not mean that you have 10 MB of redo log. You have ONLY 5 MB.
Hope you got the picture.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
