archive log files - "flaky" sizes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: archive log files - "flaky" sizes

Threaded View

  1. #1
    Join Date
    Oct 2002
    Posts
    807

    archive log files - "flaky" sizes

    My archive log files show period inconsistent sizes..Can someone explain whats going on here? (No - there were NO "alter system switch log files" issued during the below period. Nor were the log files altered in the below period. So that's definitely not it).

    See below : the logs are sized at 500M. But noticed the archive logs on "Nov 19 18:39" or "Nov 19 21:07" or "Nov 20 00:01"..the sudden deviation in sizes..
    Whats going on here? (Yes..the last one was "switched" after yesterdays backup)

    SQL> select * from v$log;

    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
    ---------- ---------- ---------- ---------- ---------- --- ----------------
    FIRST_CHANGE# FIRST_TIME
    ------------- --------------------
    1 1 6995 524288000 1 NO CURRENT
    410955998 11/20/02 11:04:53

    2 1 6994 524288000 1 YES INACTIVE
    410943739 11/20/02 09:12:06

    3 1 6993 524288000 1 YES INACTIVE
    410747781 11/20/02 05:01:38



    NUP-bull1racle[bs1]/u06/oradata/archive> ls -ltr | tail
    -rw-r----- 1 oracle dba 524289024 Nov 19 20:56 1_6985.dbf
    -rw-r----- 1 oracle dba 524286976 Nov 19 21:07 1_6986.dbf
    -rw-r----- 1 oracle dba 524285952 Nov 19 21:45 1_6987.dbf
    -rw-r----- 1 oracle dba 524289024 Nov 19 23:05 1_6988.dbf
    -rw-r----- 1 oracle dba 524289024 Nov 19 23:10 1_6989.dbf
    -rw-r----- 1 oracle dba 524281856 Nov 20 00:01 1_6990.dbf
    -rw-r----- 1 oracle dba 524289024 Nov 20 02:40 1_6991.dbf
    -rw-r----- 1 oracle dba 524289024 Nov 20 05:03 1_6992.dbf
    -rw-r----- 1 oracle dba 524289024 Nov 20 09:14 1_6993.dbf
    -rw-r----- 1 oracle dba 144038912 Nov 20 11:05 1_6994.dbf
    Last edited by Axr2; 11-20-2002 at 02:04 PM.

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