肖恩D++
Not Equal C && !=C && 不等于西
-
ORACLE databse can not start by missing tablespace file
Posted on February 13th, 2010 1 commentToday, as usual, trying to login to Oracle database do something, but when typing “sqlplus” and username/password, it showing:
12ERROR :ORA-01033: ORACLE initialization or shutdown in progressIt seems like Oracle database was not starting somehow. After connect the database as SYSDBA, type some command for trying to restart the datadase:
12345678910111213141516SQL> shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145750508 bytesDatabase Buffers 25165824 bytesRedo Buffers 262144 bytesDatabase mounted.ORA-01157: cannot identify/lock data file 6 - see DBWR trace fileORA-01110: data file 6: '/home/XXX/XXX.dbf'Now finally realized what happened and how this happened. There is a tablespace file “XXX.dbf” missing. To solve this issue, connect database as SYSDBA, then:
123SQL> alter database datafile 'XXX.dbf' offline drop;SQL> shutdown immediate;SQL> startup;
(No Ratings Yet)
Loading...Networks
Visitor Counter
- Total Visitors 262,847
- Visitors today 41
- Page views today 126
- Curently online 1
- Page views of current page 360
Statistics- Counterstart 2014-12-11
Recent Comments