- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- What should be the Redo Log Members size?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 03:39 AM
тАО12-02-2005 03:39 AM
Best Regards,
Eric Antunes
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 03:42 AM
тАО12-02-2005 03:42 AM
Re: What should be the Redo Log Members size?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 04:01 AM
тАО12-02-2005 04:01 AM
Re: What should be the Redo Log Members size?
Not really, I suppose the associated question is how often you switch log file ?
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 04:06 AM
тАО12-02-2005 04:06 AM
Re: What should be the Redo Log Members size?
Depending on the number of datafiles in your database a checkpoint can become expensive. At minimum you must checkpoint when you perform a log switch. There is no correct size, but a good suggestion is to size the redo log such that it can hold about 30 min of activity during normal operations.
Check pointing more often reduces recovery time in the event of a failure, but the trade off is a performance hit during normal operations.
Check your alert log to determine how often you are performing a logswitch and use that to decide if the redolog files are too large or small.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 04:09 AM
тАО12-02-2005 04:09 AM
Re: What should be the Redo Log Members size?
How often you switch log file depends on the redo log members size and the init.ora related parameters, right?
I have read documents advising that checkpoint should trigger at half the redo log members size and others advising a log_checkpoint_interval set to twice the redo log members size (in Kb)...
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 04:15 AM
тАО12-02-2005 04:15 AM
Re: What should be the Redo Log Members size?
Here's the situation:
Thread 1 advanced to log sequence 23993
Current log# 3 seq# 23993 mem# 0: /disc1/.../log3a.dbf
Current log# 3 seq# 23993 mem# 1: /disc2/.../log3b.dbf
Fri Dec 2 13:58:59 2005
Thread 1 advanced to log sequence 23994
Current log# 1 seq# 23994 mem# 0: /disc1/.../log1a.dbf
Current log# 1 seq# 23994 mem# 1: /disc2/.../log1b.dbf
And that last checkpoint was forced by "alter system checkpoint" command. So I suppose I'm not having enough checkpoints...
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 04:16 AM
тАО12-02-2005 04:16 AM
SolutionI probably ignore tha fact that say the redo must be sized so redo log switch happens very 30mms (or is it every hour ?).
It depends on activity.
get the right checkpoint frequency so yuo have enough but not too many.
In my view the size of thr redo depends mostly on how long does it takes to archive one redo log file when IO activity is fairly high. If it takes between 30sec and 1mn, you may not allowed the redo log switch frequency too be below say 3mns.
Regards
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 04:44 AM
тАО12-02-2005 04:44 AM
Re: What should be the Redo Log Members size?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 07:19 AM
тАО12-02-2005 07:19 AM
Re: What should be the Redo Log Members size?
From your post I can't tell how often you switch logs as I only see one timestamp.
If you want to know how ofter you checkpoint you can add
log_checkpoints_to_alert = true
to your init.ora, then you will log checkpoints in additions to log switches to the alert log.
If you have enable archivelog mode (and I assume you would in a production db) then looking at the timestamps on the archive log files will also give an indication on how often you switch log files. The time needed to archive the online log file should be much shorter than the time to fill an online log file.
These init.ora parameters control the frequency of checkpoint so set them accordingly if you wich to checkpoint more frequently than at log switch.
log_checkpoint_interval
log_checkpoint_timeout
You need to know how much redo information you generate in a given period of time to determine the best size for your logs.
If you force a log switch after 30 min, then note the size of your archive log file, that will give you an idea of how much redo is generated in 30min. There are other was to calculate this info, but I think thats the easiest.
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2005 03:32 PM
тАО12-02-2005 03:32 PM
Re: What should be the Redo Log Members size?
You should work it out yourself.
This is how we started:
3 groups of 2 members of 25meg a piece
Then, working up from there, you may end in either adding more groups or making the members larger until you have enough online redo log to get you through at least 15-20 minutes of work without switching.
Note that there will be times when 15-20 minutes is too long and too short. You need to pick your time and go from there.
kind regards
yogeeraj