用TOAD打开数据库时报“ora-01033:oracle initializationg or shutdown in progress 错误”,刚开始不知道是什么原因导致的,所以关闭DB,但此时又报出:“
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
”错误,经查阅资料才知道,这是因为数据文件损坏才致于此的,故做以动作数据库便恢复正常,动作为:“
SQL>connect /as sysdba
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 71305460 bytes
Database Buffers 92274688 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> alter database clear unarchived logfile '/u02/oradata/kvgapdb/redo02.log';
到此在TOAD中数据库可正常开启了,数据库恢复正常了
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/25772857/viewspace-697532/ ,如需转载,请注明出处,否则将追究法律责任。