- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-17 15:18:09
|
查看: 2150 |
回复: 0
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Aug 26 10:40:57 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.
SQL> shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 537990604 bytes
Fixed Size 452044 bytes
Variable Size 218103808 bytes
Database Buffers 318767104 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-03114: not connected to ORACLE
SQL>
more huayang_ora_7879.trc
/opt/oracle/admin/huayang/udump/huayang_ora_7879.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/product/9.2
System name: Linux
Node name: oracle
Release: 2.4.21-27.ELsmp
Version: #1 SMP Wed Dec 1 21:59:02 EST 2004
Machine: i686
Instance name: huayang
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 7879, image: oracle@oracle (TNS V1-V3)
*** SESSION ID11.3) 2005-08-26 10:41:33.131
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 0Kb in 0.03s => 0.00 Mb/sec
Longest record: 0Kb, moves: 0/1 (0%)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2005-08-26 10:41:33.134
KCRA: start recovery claims for 0 data blocks
*** 2005-08-26 10:41:33.134
KCRA: buffers claimed = 0/0, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: bootstrap process failure
ORA-00702: bootstrap verison '16.0.0.0.0' inconsistent with version '8.0.0.0.0'
大哥,您的意思是說bootstrap$這個表裡面的數據有損壞,我把這個表所在的datafile恢復就
可以了是嗎?
但是我如何知道這個表在哪一個datafile裡呢,謝謝!請多多支援.
帮我把这数据库搞定,价钱都好商量.我们公司不会亏待你的.
[root@oracle3 bdump]# tail alert_huayang.log
SMON: enabling cache recovery
Fri Aug 26 13:52:13 2005
Errors in file /opt/oracle/admin/huayang/udump/huayang_ora_8181.trc:
ORA-00704: bootstrap process failure
ORA-00702: bootstrap verison '16.0.0.0.0' inconsistent with version '8.0.0.0.0'
Fri Aug 26 13:52:13 2005
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 8181
ORA-1092 signalled during: alter database open resetlogs...
只是第一种没有那么容易?!老大,我相信你一定有办法啊,快来救命啊!
老大,system01.dbf,800多M啊,看来不知等多少时候才能打开.
还有没有好办法可以改啊?
各位,不要这样呀,我现在吃饭回来了,本来吃得很饱,还想休息一下,看看大家讨论这么激烈,出来说说。首先感谢chensq把bootstrp$的问题解决掉了。但是后面又因为有坏道,数据库
仍旧不能启动。
看来我要把这个数据库坏的背景说一说。
5月25日数据库运行一切正常,快下班时掉电。
5月26日过来上班发现数据库连接其慢无比,杀千刀的主管立刻将服务器重启,不得了,就报
我第一次发言时的错误。当时束手无策,一天过去。
就在今天,由于公司鬼老出马,主管在强大压力下,将数据库恢复若干遍无果。现在由先前离职的一位员工,由于他原先负责,正在拯救。
多谢各位大老,我会继续报告最新消息。
|
|