业务背景:
因公司异常停电,造成oracle数据库文件损坏且Oracle数据库没有做备份,导致登录Oracle报ORA-01033: ORACLE initialization or shutdown in progressProcess ID: 0Session ID: 0 Serial number: 0
解决方案:
1.运行cmd:
C:\administrator>set oracle_sid=orcl(此为数据库的实例名称)
C:\administrator>sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 2 08:52:09 2015
Copyright © 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
2.关闭数据库,重新启动:
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut