Solution : https://service.sap.com/sap/support/notes/3809 (SAP Service marketplace login required)
Summary :
During normal productive operation, it's essential to perform at least one log switch per hour. Oversized redo log files pose security risks, while undersized ones can cause performance issues due to frequent checkpoints. This note is valid for Oracle 6. For Oracle 7 and 8, redo log file sizes should be adjusted based on various factors such as load profile and DBWR performance. This must be discussed individually with the customer. SAP requires four redo log files. To resize redo logs, perform a full database backup, drop the current logfiles, redefine them with the new sizes, and handle the ORA1515 error appropriately.
Key words :
sqlplus system/manager sql> alter database drop logfile '/oracle/<sid>/sapdata<#>/log_1/log, sqlplus system/manager sql> alter database add logfile '/oracle/<sid>/sapdata<#>/log_1/log, sqlplus system/manager sql> alter system switch logfile, prerequisites uniform sap installation solution caution, oversized redo log files pose, enlarged/reduced logfile, explicit log switch, redo log files, redo log file, current log file
Related Notes :
| 72808 | SAPDBA: recovery error: Choice of the Log.Seq.Nr. |