Oracle archive logs are typically generated by DML statements, so increasing too quickly should be DML too frequently
Start by querying the following daily archives:
Select TRUNC (first_time) "Time",
SUM (Block_size * BLOCKS)/1024/1024/1024 "SIZE (GB)"
From V$archived_log
GROUP by TRUNC (First_time);
So you can judge the time period to start filing a comparison exception.
Analyze archived logs in the following two ways
Method One: Use Logminer
1. Create a related package using a script
@ $ORACLE _home/rdbms/admin/dbmslm.sql
@ $ORACLE _home/rdbms/admin/dbmslmd.sql;
The first script is used to create a DBMS_LOGMNR package to parse the log file.
The second script is used to create a dbms_logmnr_d package that is used to create a data dictionary file.
2. Specify the log files to parse
exec sys.dbms_logmnr.add_logfile (logfilename = '/archivelog/node/1_771348_78836667000.arc ', options = Dbms_ Logmnr.new);
3. Analyze archive logs using a local online data dictionary
EXEC sys.dbms_logmnr.start_logmnr (options = Sys.dbms_logmnr.dict_from_online_catalog);
4, query the archived log content of the analysis, for example, the schema of the maximum amount of modification
Select Seg_owner,count (*) from v$logmnr_contents GROUP by Seg_owner;
Select COUNT (1), substr (sql_redo,1,30) from V$logmnr_contents Group by substr (sql_redo,1,30) Order by count (1) desc;
5. Add other log files
EXEC sys.dbms_logmnr.add_logfile (logfilename=> '/archivelog/node/1_773333_78836667000.arc ');
EXEC sys.dbms_logmnr.add_logfile (logfilename=> '/archivelog/node1/1_773334_78836667000.arc ');
6. End the Analysis archive log
exec SYS.DBMS_LOGMNR.END_LOGMNR;
Method Two: Use the Toad tool to view log information
Find Logminer in database and then put the log to be analyzed in, there is a detailed database execution records, very intuitive to see the resulting archive of the statement
After the statement is found, and then to develop a piece of discussion can also reduce the execution frequency of some DML statements
Oracle Archive log growth too fast processing method