MULTIPLEXING and ARCHIVING Redo Logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: MULTIPLEXING and ARCHIVING Redo Logs

  1. #1
    Join Date
    Mar 2002
    Posts
    200
    I am really confused between MULTIPLEXING redo log files and ARCHIVING redo log files. I know the process is different, but isn't the application same.

    I mean when we can have multiple copies by MULTIPLEXING, why do we then need to ARCHIVE also? Kindly clarify my confusion.


    Share on Google+

  2. #2
    Join Date
    Aug 2002
    Posts
    3

    Lightbulb

    Multiplexing redo log files means several copy of
    the same log files are kept in different locations
    which will be simultaneously updated at any point
    of time. But archiving is something different ....
    Archiving redo log files is u are keeping track of the permanent changes done in the database into some
    files. The redo log files will be overwritten when
    check point arrives. But archived files are not
    overwritten and they can be used for database
    recovery if the database crashes.
    Parik**** Basu

    There are none so blind as those, who will not see
    Share on Google+

  3. #3
    Join Date
    Mar 2002
    Posts
    200
    Originally posted by Parik****
    Multiplexing redo log files means several copy of
    the same log files are kept in different locations
    which will be simultaneously updated at any point
    of time. But archiving is something different ....
    Archiving redo log files is u are keeping track of the permanent changes done in the database into some
    files. The redo log files will be overwritten when
    check point arrives. But archived files are not
    overwritten and they can be used for database
    recovery if the database crashes.
    So does it mean that multiplexed files cannot be helpful for recovery?
    Share on Google+

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    By multiplexing you make sure that a disk failure will not prevent your db to go down, you'll have the same redo logs on other disk.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width