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

文档解释

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;

你可能感兴趣的