文档解释
ORA-00226: operation disallowed while alternate control file open
Cause: The attempted operation could not be executed at this time because this process had an alternate control file open for fixed table access.
Action: Retry the operation after calling cfileUseCurrent.
ORA-00226是Oracle数据库开发人员在处理控制文件(Control File)时报出来的一个错误。
官方解释
常见案例
正常处理方法及步骤
1、确保备份控制文件句柄关闭,使用 “ALTER DATABASE BACKUP CONTROL FILE TO TRACE/CANCEL”来关闭备份控制文件句柄;
2、接着使用 “ALTER DATABASE OPEN RESETLOGS”来重新开启数据库;
3、确保数据库实例工作正常。