Mirror online redo log files

How can I mirror the online redo log files for the best backup/recovery practice?  can you show me some examples?
jung1975Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gattu007Commented:
try keeping the members in different disks... or may be on RAID...

Using OFA is recommended if the machine on which you plan to create the database has a different directory structure. Standard file paths can be used if the target machine has a similar directory structure.
0
gattu007Commented:
The number of disks for redo logs is mostly determined by the redo log size, which is generally small compared to current technology disk sizes. Typically, a configuration with two disks (possibly mirrored to four disks for fault tolerance) is adequate. In particular, by having the redo log files alternating on two disks, writing redo log information to one file does not interfere with reading a completed redo log for archiving.

Mirroring can cause I/O bottlenecks. Generally, the process of writing to each mirror is done in parallel and does not cause a bottleneck. However, if each mirror is striped differently, then the I/O does not complete until the slowest member of the mirror is complete. To avoid I/O problems, stripe the copies using the same number of disks as used for the primary database.

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96533/iodesign.htm#22610
0
jung1975Author Commented:
I have currently all the log files in E: which is RAID 5 .. log1A, log1B, log2A, Log2B, Log3A, Log3B, Log4A, Log4B, etc...

So is it a good idea to move all of Log B group to different disk ( F:) ? I am not quite sure how to do this...
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

mohammadzahidCommented:
You can do this by using mutilplexing redo logs.  

For example:

If redo log group have 1 members then you can put each members on seperate disk.

Please goto this url for steps:

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/onlineredo.htm

0
mohammadzahidCommented:
sorry, I meant to say 2 members for a redo log group ..

0
jung1975Author Commented:
thanks.. what is member?
Log1A  --> is this one member?
Log1B  -

0
jung1975Author Commented:
actually, if there are more than one online redo log  group( for example, log1A, Log1B, Log2A, Log2B, etc...), the online log files are already multiplexed..right?
0
mohammadzahidCommented:
not necessary. You can check the location of the logfiles by running select against V$LOGFILE and check locations of the members.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.