Transaction logs, redo logs and archive logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Transaction logs, redo logs and archive logs

Hybrid View

  1. #1
    Join Date
    Oct 2013
    Posts
    2

    Transaction logs, redo logs and archive logs

    Okay, this is a fairly basic question. Maybe it's too basic for this forum, but I need help with understanding this. I understand the distinction between redo logs and archive logs, but I do not get the distinction between them and transaction logs. My intuition suggests that both redo logs and archive logs are forms of transaction log, but that doesn't seem to be consistent with a lot of things I've found on the internet. People often seem to refer to the transaction logs as if it were a subset of redo logs.

    I know for certain that you can have a DBMS consisting of 12 HDs divided into RAID10 for 1) the system areas 2) the data files and 3) the transaction logs. It's this that makes me think transaction logs is the umbrella term, but I cannot find anything to explicitly confirm or deny that.

    If someone could please clarify the distinction, or point me to a source that will make it clear, I would be extremely grateful.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool

    In Oracle: Archive logs = Redo logs written to disk and re-cycled.

    Transaction logs:

    1. In Oracle = Logs generated by a user and/or an application
    2. In SQL Server = quasi-equivalent to oracle archive logs.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2013
    Posts
    2
    Yay! Straight, to the point and easy to understand. I couldn't have asked for a better answer. Thanks!

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