昨天笔记本意外进水,强制关机,早上就一直出这问题,数据库打不开,报错,
用 sysdba 登陆后
Code
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
SQL> select open_mode from v$database;
OPEN_MODE
----------
MOUNTED
Code
SQL> alter database open;
SQL> alter database open;
提示错误
Code
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1;
Code
select * from v$log;
alter database open;
select * from v$log;
alter database open;
在查询
Code
SELECT OPEN_MODE FROM v$database
SELECT OPEN_MODE FROM v$database
提示处于 read,write
数据库ok 了