数据库版本10201 os linux Red Hat Enterprise Linux Server release 5.2 (Tikanga)
没有归档 没有备份
1 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
之后重建控制文件...
昆山-dba(530473146) 15:47:54
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
2 尝试使用隐含参数打开数据
SQL> show parameter _allow_resetlogs_corruption
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_allow_resetlogs_corruption boolean TRUE
无法打开数据库
3 查看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
ORA-27086
[oracle@websvr ~]$ oerr ora 27086
27086, 00000, "unable to lock file - already in use"
// *Cause: the file is locked by another process, indicating that it is
// currently in use by a database instance.
// *Action: determine which database instance legitimately owns this file.
提示为被另外进程占用
ps -ef|grep ora_
kill 掉所有的没有用的oracle后台进程
4
数据库异常处理
阅读(1599) | 评论(0) | 转发(0) |
