由于主机异常断电,重新启动机器后.出现如下错误:
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01102: cannot mount database in EXCLUSIVE mode ;
在$ ORACLE_HOME/dbs目录下没有sgadef.dbf文件,存在lk文件.并且奇怪的是,本来只有一个instance,但是查询v$instance是却把这一行数据显示成多行,如下(instance名是TEST,主机名是oracleserver):
SQL> startup nomount
ORACLE instance started.
Total System Global Area 594367380 bytes
Fixed Size 455572 bytes
Variable Size 419430400 bytes
Database Buffers 163840000 bytes
Redo Buffers 10641408 bytes
SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
1 TEST
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
oracleserver
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
9.2.0.3.0 30-APR-04 STARTED
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
0 STOPPED ALLOWED NO
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
ACTIVE UNKNOWN
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
NORMAL
INSTANCE_NUMBER INSTANCE_NAME
--------------- --------------------------------
HOST_NAME
--------------------------------------------------------------------------------
VERSION STARTUP_T STATUS PARALL
---------------------------------- --------- ------------------------ ------
THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDO
---------- -------------- ---------------------- -------------------- ------
DATABASE_STATUS INSTANCE_ROLE
---------------------------------- ------------------------------------
ACTIVE_STATE
------------------
SQL>