Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Posts
    70

    Lightbulb Unanswered: redo log file size and archive log file size

    Hi All,
    My database is in Archive log mode and i have given
    log_archive_dest = /home/dbArchive
    when I do an ls on that directory i found that the Archive Log file sizes are 10484224 bytes. However when I query v$log i found that the redo log file size is 10485760 bytes. If I am not wrong, only after a redo log file is full it switches to the next group and thereby create Archive Log. Then why is there a difference in Archive Log and Redo Log file size. Is there any factor apart from ALTER SYSTEM SWITCH LOG FILE which initiates logfile switch?

    Please help me in knowing this.

    Thanks in advance.
    qAnand

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Maybe your blocksize is bigger than the size left in the redologfile. So Oracle cannot write another block in the file and will switch.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Jul 2003
    Posts
    70
    Hi,
    Thanks for your reply.
    Which block size are you referring to? Is it the block size specified using db_block_size?
    Can you elaborate what would have happened?
    If you see the difference is just 1536 bytes.


    Regards,
    qanand

  4. #4
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    Oracle writes everything in blocks.
    The size is db_block_size (or can be different for each tablespace in newer versions)

    If it can't write the entire block in redo it won't write anything.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  5. #5
    Join Date
    Jul 2003
    Posts
    70
    Thank you very much. Your inputs were really valuable.

    Regards,
    Anand

Posting Permissions

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