Skip to Content
avatar image
Former Member

Size archive log different with online redo log

Dear Experts,

I had a problem with archive redo log size. I saw the size between archive redo log and online redo log is different.

The online redo log on path /oracle/SID/origlogA/log_g17m1.dbf , the size is 280MB, but on archive log the size just 130MB.

Why the size different? How to change the archive redo log?

We are running with Oracle 11.2.0.4.

Please aid me to solve this issue.

Thanks

Edy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 18, 2014 at 04:03 AM

    It is not an issue, archive log's size can be equal to you redolog size as archiving process happens from online redologs.

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • But in our system, the size online redo log and archive is not equal.

      This is not an issue.

      The log switch can happen as designed and not necessarily when it reaches the size of the online redolog.

      Regards

      RB

  • avatar image
    Former Member
    Jun 18, 2014 at 06:21 AM

    please read :

    Note 998675 - Archive log of smaller size than the original redo log

    best regards

    ashish

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 20, 2014 at 05:56 AM

    Dear Edy,

    It is really not an issue. Preemtive redolog switch is the name of this feature, which is described throughtly in the below note:

    1627481 - Preemptive redolog switches in Oracle 11.2

    Just for your reference I attach the archived redolog sizes one of my testsystems:

    Also I must draw your attention to some facts here:

    - each of my online redologs have the size in bytes, 52428800

    - the ones with some kbyte sizes were created while is executed 'alter system switch logfile' and there was almost nothing going on or executed on the database

    Regards,

    János

    Add comment
    10|10000 characters needed characters exceeded