ORA-01155: the database is being opened, closed, mounted or dismounted

刘泽宇

启动数据库出现这样报错：
ORA-01155: the database is being opened, closed, mounted or dismounted
在等待了差不多15分钟之后，查看告警日志发现数据库自动open了


查找了一下ORA-01155的报错信息：

ORA-01155: the database is being opened, closed, mounted or dismounted

Answer:    Here is what the oerr utility has to say about the ORA-01155 error:

ORA-01155: the database is being opened, closed, mounted or dismounted

Cause: The requested operation needs the instance to be in a particular state but the state is being changed.

Action: Wait for the open, close, mount, or dismount to complete then retry the operation. If necessary, a SHUTDOWN ABORT will always work.

To diagnose the ORA-01155 error, you can run this query:

select switchover_status from v$database;

select
   SID,
   PROCESS,
   PROGRAM
from
   v$session
where
   type = 'USER'
and
   SID (select DISTINCT SID from v$mystat);

If the second query returns data, then re-run the switchover command:

SQL>ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;