ORA-00302: limit of string logs exceeded

文档解释

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