Oracle adjusted the online redo log size (changeredologsize)

Oracle online logs and Oracle archive logs record the complete change information of the entire database. Is an important part of Oracle architecture. Therefore, the online log plan is similar.

Oracle online logs and Oracle archive logs record the complete change information of the entire database. Is an important part of Oracle architecture. Therefore, the online log plan is similar.

Oracle online logs and Oracle archive logs record the complete change information of the entire database. Is an important part of Oracle architecture. Therefore, online log planning is also very important. However, as the business grows or the current size of online log files becomes a bottleneck in the database, you have to adjust the size of online logs. This article demonstrates how to resize online logs.

For more information about online log and archiving log planning and settings, see:

Oracle ONLINE redo LOG FILE)

Oracle archiving logs

1. Demo Environment

Sys @ CNBO1> select * from v $ version where rownum <2;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.3.0-64bit Production

Sys @ CNBO1> archive log list;
Database log mode Archive Mode --> Archive mode
Automatic archival Enabled
Archive destination/u02/database/CNBO1/archive/
Oldest online log sequence 4881
Next log sequence to archive 4884
Current log sequence 4884

2. log usage

Sys @ CNBO1> @ log_stat

GROUP # member sequence # SIZE_MB STATUS
----------------------------------------------------------------------------------
1/u02/database/CNBO1/redolog/log1aCNBO1. log 4881 20 ACTIVE
1/u02/database/CNBO1/redolog/log1bCNBO1. log 4881 20 ACTIVE
2/u02/database/CNBO1/redolog/log2aCNBO1. log 4882 20 ACTIVE
2/u02/database/CNBO1/redolog/log2bCNBO1. log 4882 20 ACTIVE
3/u02/database/CNBO1/redolog/log3aCNBO1. log 4883 20 ACTIVE
3/u02/database/CNBO1/redolog/log3bCNBO1. log 4883 20 ACTIVE
4/u02/database/CNBO1/redolog/log4aCNBO1. log 4884 20 ACTIVE
4/u02/database/CNBO1/redolog/log4bCNBO1. log 4884 20 CURRENT

8 rows selected.

Sys @ CNBO1> select group #, archived, status from v $ log;

GROUP # ARC STATUS
-----------------------------
1 YES ACTIVE
2 YES ACTIVE
3 YES ACTIVE
4 NO CURRENT

,