ORA-01139: RESETLOGS option only valid after an incomplete database recovery ORACLE 报错 故障修复 远程处理
文档解释
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
Cause: The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.
Action: Retry the ALTER DATABASE OPEN without specifying RESETLOGS
官方解释
常见案例
正常处理方法及步骤
1. 首先确保已执行了不完整的数据库恢复。
2. 关闭所有数据库会话然后禁止连接。
3. 用RESETLOGS选项重新打开数据库:
ALTER DATABASE OPEN RESETLOGS;
4. 允许用户连接数据库:
ALTER SYSTEM ENABLE RESTRICTED SESSION;