ORA-00261: log string of thread string is being archived or modified

文档解释

ORA-00261: log string of thread string is being archived or modified

Cause: The log is either being archived by another process or an administrative command is modifying the log. Operations that modify the log include clearing, adding a member, dropping a member, renaming a member, and dropping the log.

Action: Wait for the current operation to complete and try again.

ORA-00261: log string of thread string is being archived or modified错误的官方解释是:

当您尝试用alter database archivelog|noarchivelog激活或取消归档模式时,出现此错误。

所造成这个错误的最常见原因有:

1)数据库处于传输模式,导致无法激活或取消归档模式;

2)数据库日志文件正被备份,恢复或更改,所以不能在此时激活或取消归档模式;

3)如果出现错误,请检查数据库日志是否正在被备份或恢复,并做出相应的管理操作。

正常处理方法及步骤

(1)检查数据库的归档模式是否已经启动,不是的话就启动;

(2)检查是否正在备份,恢复或更改日志文件,如果是的话,请稍后解决;

(3)使用ALTER DATABASE SWITCH LOGFILE So SESSION帮助解决出现此错误的会话;

(4)使用show parameter log_archive 确认log_archive_start是否设置为TRUE;

(5)将数据库关闭和重新启动以进行清理;

(6)重新激活归档模式。

你可能感兴趣的