Oraarch log files become 100% in disk R:\oracle\SID\oraarch

[former_member182675]

Dear Friends
we are using Solution Manager 7.1 SP06
oracle 11.2.0.2
we have a problem in oraarch file
Every day Oraarch log files become 100% in disk "R:\oracle\SID\oraarch" disk R is 100 GB
Every three minutes created a logs file with 200 M
we are backing up the logs twice a day (Copy Delete)
Please help me understand why every few minutes created a new log file

Best Regards

Naor Shalom

[stefan_koehler]

Hi Naor,

well 1.1 MB redo per second is really too much for a SAP Solution Manger system.

You can analyze the online redo log files or archive log files by using Log Miner. After you have started a Log Miner session you can query a v$ view and aggregate the corresponding log file entries.

Here is just a simple example of using the log miner:

shell> su - ora<SID>
shell> sqlplus / as sysdba
SQL> exec DBMS_LOGMNR.ADD_LOGFILE ('<PATH TO LOG FILE>', DBMS_LOGMNR.NEW);
SQL> exec DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
SQL> select OPERATION, SEG_NAME, count(*) as CNT from V$LOGMNR_CONTENTS group by OPERATION, SEG_NAME order by CNT;
*** After checking the operations and segments with the highest CNT - query the transaction details *** 
SQL> select SQL_REDO from V$LOGMNR_CONTENTS where SEG_NAME = '<SEG_NAME>' and OPERATION = '<OPERATION>';

Regards

Stefan