Skip to Content
avatar image
Former Member

Filesystem /oracle/<SID>/origlogA diskspce utilizatin exceeds 85% thrshold

Hello,

In a non production system it's found that the File system /oracle/<SID>/origlogA diskspace utilization exceeds 85% threshold.

How the disk space utilization can be reduced.

Would the command "alter system switch logfile" be helpfull ?

Is there any other way to reduce the file system utilization.

Thanks & regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 15, 2009 at 06:23 PM

    Hello Girish,

    no the command "alter system switch logfile" will not help in this case.

    In a normal SAP installation only the first copy of two online redolog files is located in /oracle/<SID>/origlogA. Sometimes there is also one control file in it, maybe the control file is growing (keyword "CONTROL_FILE_RECORD_KEEP_TIME").

    You can shrink the redolog files to reduce the needed space - check sapnote #309526 for the procedure. But think of the redo log switching time, i always suggest one logswitch every 10 to 15 min.

    If you don't really know what you are doing, the easiest way is to extend the filesystem, isn't it?

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15, 2009 at 06:24 PM

    Why are you so bother about Diskspace utilization of the logfile directory?

    Do you know how the logfiles are behave in the Oracle?

    Any DML operation (INSERT, UPDATE and DELETE) generates an log entry. This log entry first goes to the online logfiles (i.e. origlogA, origlogBB and origlogC). First entry goes to origlogA when it fills up the entry goes to origlogB and then C. This is called logswitch. When a logswitch occurs a checkpoint triggered and archive process comes up, then it archives origlogA to the Archiving destination so that it can be reused. Like this way three logfiles has been used in a cyclic way.

    If you trigger "alter system switch logfile" logwritting triggers from origlogA from origlogB and archive process will archive the logfile. But again this will fill up the log entry.

    You don't need to bother about the diskspace utilization of the logfile directory. It's a normal behavior that it gets filled up and becomes entry time to time.

    Let me know if you have any doubt.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15, 2009 at 06:27 PM

    Hello Girish,

    How many origlog files do you have in your system

    Rohit Goyal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2009 at 03:30 PM

    Hi,

    Hope you do not have offline redo logs in /oracle/<SID> folder?

    Manoj

    Add comment
    10|10000 characters needed characters exceeded