asked on

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?

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.

SOLUTION

gattu007

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jung1975

ASKER

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...

mohammadzahid

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

mohammadzahid

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

jung1975

ASKER

thanks.. what is member?
Log1A --> is this one member?
Log1B -

jung1975

ASKER

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?

ASKER CERTIFIED SOLUTION

mohammadzahid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial