解决ORA-01157问题

SQL> startup
ORACLE instance started.

Total System Global Area  914358272 bytes
Fixed Size                  2088184 bytes
Variable Size             528483080 bytes
Database Buffers          377487360 bytes
Redo Buffers                6299648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
ORA-01110: data file 8: '/var/opt/gssyneeadb/gssy_neeadb.dbf'


SQL> ALTER SYSTEM SET "_allow_resetlogs_corruption"=TRUE SCOPE=SPFILE;

System altered.

SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  914358272 bytes
Fixed Size                  2088184 bytes
Variable Size             528483080 bytes
Database Buffers          377487360 bytes
Redo Buffers                6299648 bytes
Database mounted.
SQL> alter database datafile '/var/opt/gssyneeadb/gssy_neeadb.dbf' offline drop;

Database altered.

SQL> shutdown
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  914358272 bytes
Fixed Size                  2088184 bytes
Variable Size             528483080 bytes
Database Buffers          377487360 bytes
Redo Buffers                6299648 bytes
Database mounted.
Database opened.
SQL>


好使了。。。汗了

评论

1 楼 wskmydlove 2012-10-22  

很牛呀，相见恨晚（文章）我都搞三天了没搞定，今天一上来就看到你文章，一下搞定。对症下药呀！谢谢了！