当前位置:首页 > 开发 > 数据库 > 正文

ora 01017问题解决办法

发表于: 2014-01-19   作者:AILIKES   来源:转载   浏览:
摘要: SQL> startup ORACLE instance started. Total System Global Area  914358272 bytes Fixed Size              &nb

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>

ora 01017问题解决办法

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号