cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

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

Manoj

Former Member
0 Kudos

Hello Girish,

How many origlog files do you have in your system

Rohit Goyal

Former Member
0 Kudos

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.