造成这种原因,是因为我一开始 restore 一个数据文件,当时忘了recover database;导致重启时报错。
处理方式:
C:\Documents and Settings\Administrator>net start oracleservicewms
OracleServiceWMS 服务正在启动 ...........................................
OracleServiceWMS 服务已经启动成功。
C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期五 2月 1 22:07:04 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> desc v$database;
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------
DBID NUMBER
NAME VARCHAR2(9)
CREATED DATE
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME DATE
PRIOR_RESETLOGS_CHANGE# NUMBER
PRIOR_RESETLOGS_TIME DATE
LOG_MODE VARCHAR2(12)
CHECKPOINT_CHANGE#