Redo logs Vs Archive Logs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Redo logs Vs Archive Logs

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    Could some body explaint to me what is the difference between Redo log files and archive logs, functionally are they not the same.

    2) Before taking the hot back , when the tablespace is offline mode , any changes that happen in the database-- would it write to redo logs or archive logs.

    Please explain

    Badrinath

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    1. Logs which are (currently) unarchived are referred to as redo log files. When these files get filled up, they are copied to a archive destination and are thus called archived (redo) log files.
    2. Correction: a ts is not offline during a hot backup, it's in backup mode. Changes are logged in the redo log files.

  3. #3
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Archived Logs are copies of the Redo logs.
    When running in ArchiveLog mode the Archiver process archives the redo logs as they are filled and the new log grouup becomes active.

    You will need these archives if the database crashes and you need to restore from the old backup. In that case you will need all the logs archived after the last backup was taken.

    When the tablespace is in backup mode the changes are logged in the redo logs. It may be a good practice to Archive your active logs after the tablespaces are brought out of the backup mode. This way you make sure that the all the redo generated during the backup process is archived as well.

    - Rajeev

    Rajeev Suri

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