ORA-00226: operation disallowed while alternate control file open ORACLE 报错 故障修复 远程处理

文档解释

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、确保数据库实例工作正常。