重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-01155: the database is being opened, closed, mounted or dismounted [打印本页]

作者: 刘泽宇 时间: 2022-5-22 11:53
标题: 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;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)