Oracle Error ORA-00302: limit of string logs exceeded

Oracle Error Message

ORA-00302: limit of string logs exceeded

Reason for the Error

The maximum number of redo log files has been exceeded.

Solution

Use the CREATE CONTROLFILE command with a larger value for MAXLOGFILES if the compatibility is lower than 10.2.0. Otherwise, allocate more storage space for the control file.