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)重新激活归档模式。