ORA-01380: Instance string (thread string) has less than two string block size log files ORACLE 报错 故

文档解释

ORA-01380: Instance string (thread string) has less than two string block size log files

Cause: One of the following occurred: (1) An attempt was made to switch to specified block size logs for all threads. (2) An attemp was made to open a thread.

Action: Add log files to the thread that signals error, and try again.

来回答

ORA-01380：该错误指示实例（线程）中至少需要两个具有相同块尺寸大小的日志文件才能正常工作。

官方解释

常见案例

常见的情况是，数据库中存在两个日志文件，但其中一个日志文件的块大小与另一个不一致。

正常处理方法及步骤

1）关闭数据库：shutdown immediate

2）更改另一个文件的块尺寸大小：alter database XXXX resetlogs;

3）重新创建数据库：startup open;

4）检查日志文件：select blocksize from v$logfile;

5）如果需要，可以更改block size：alter database LOGFILE XXXX blocksize xxxx;