数据库报ORA-01610起不来
958902Oct 19 2012 — edited Oct 21 2012数据库版本10201 os linux Red Hat Enterprise Linux Server release 5.2 (Tikanga)
没有归档 没有备份
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2022144 bytes
Variable Size 486540544 bytes
Database Buffers 1644167168 bytes
Redo Buffers 14753792 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
之后我删掉进程 和$ORACLE_BASE的dbs目下下面的lkcenterdb
之后再次启动时报 SQL> startup
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 180358956 bytes
Database Buffers 419430400 bytes
Redo Buffers 7163904 bytes
ORA-00205: error in identifying control file, check alert log for more info
之后重建控制文件...
CREATE CONTROLFILE REUSE DATABASE "CENTERDB" NORESETLOGS
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 3164
LOGFILE
GROUP 1 '/u/oracle/ordata/centerdb/redo01.log' SIZE 50M,
GROUP 2 '/u/oracle/ordata/centerdb/redo02.log' SIZE 50M,
GROUP 3 '/u/oracle/ordata/centerdb/redo03.log' SIZE 50M
DATAFILE
'/u/oracle/ordata/centerdb/system01.dbf',
'/u/oracle/ordata/centerdb/undotbs01.dbf',
'/u/oracle/ordata/centerdb/INFODBCCONF01.dbf',
'/u/oracle/ordata/centerdb/CENTERDB06.dbf',
'/u/oracle/ordata/centerdb/CENTERDB04.dbf',
'/u/oracle/ordata/centerdb/CENTERDB03.dbf',
'/u/oracle/ordata/centerdb/CENTERDB02.dbf',
'/u/oracle/ordata/centerdb/CENTERDB01.dbf',
'/u/oracle/ordata/centerdb/centerdb06.dbf',
'/u/oracle/ordata/centerdb/CENTERDB05.dbf',
'/u/oracle/ordata/centerdb/users01.dbf',
'/u/oracle/ordata/centerdb/sysaux01.dbf'
CHARACTER SET ZHS16GBK
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: '/u/oracle/ordata/centerdb/system01.dbf'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/u/oracle/ordata/centerdb/system01.dbf
隐含参数
SQL> show parameter allowresetlogs_corruption
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allowresetlogs_corruption boolean TRUE
试过了 还是不能打开
现在数据库起不来
昆山-dba(530473146) 15:49:36
trace文件报错内容
Additional information: 2549
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [11]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [11] [u/oracle/ordata/centerdb/centerdb06.dbf]
ORA-27086: Message 27086 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 2549
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [12]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [12] [u/oracle/ordata/centerdb/CENTERDB06.dbf]
ORA-27086: Message 27086 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 2549
ORA-01157: Message 1157 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-01110: Message 1110 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [u/oracle/ordata/centerdb/system01.dbf]
ORA-27086: Message 27086 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 2549