文档解释
ORA-00302: limit of string logs exceeded
Cause: The maximum number of redo log files has been exceeded.
Action: 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.
ORA-00302:limit of string logs exceeded 是Oracle 数据库异常消息，由于日志文件的数量超出threshold 值，而引发。
官方解释
ORA-00302: limit of string logs exceeded
Cause: The limit for the number of files that can be opened for a single log stream has been reached.
Action: Increase string.
常见案例
— 1. When trying to back up the Archive log file
当我们试图备份归档日志文件时，也可能收到这个错误消息。例如，当我们试图执行如下命令时，就可能出现此错误
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT; ORA-00302: limit of string logs exceeded
— 2. When trying to start the database
我们可能在尝试启动数据库时出现此错误。 该错误可能出现在以下情况下
SQL> STARTUP MOUNT; ORA-00302: limit of string logs exceeded.
正常处理方法及步骤
1. 首先，请检查日志文件是否超出了 thresold 值。请执行以下查询
SQL> select name from v$controlfile;
2. 如果日志文件的数量已超出threshold值，则需要调整这个值。
SQL> ALTER SYSTEM SET LOG_CHECKPOINT_INTERVAL=string SCOPE=SPFILE;
3. 启动集群以重新启动Database
SQL> STARTUP CLUSTER
4. 同步更新卷组
SQL> ALTER DISKGROUP ALL MOUNT /sql_mount_force;
5. 启动Database
SQL> STARTUP MOUNT
