ORA-01109: 数据库未打开

误删dbf文件造成ORA-01109: 数据库未打开.

1.cmd-sqlplus /nolog-conn system/pwd as sysdba

2.shutdown immediate;

3.startup mount;

4.alter database datafile 'd:\*.dbf' offline drop;

alter database open;

http://hi.baidu.com/tned/blog/item/07ab8525ff3e026734a80f08.html

转载于:https://www.cnblogs.com/wen12128/archive/2010/09/15/1827396.html