十万火急：启动数据库时出错. . .

显示全部楼层 · 2003-3-30 13:27:00

请教各位高手：
昨天早上因意外事故，造成数据库异常down机.
sunos5.6重启后，启动ORACLE8.0.4时，出错
非archive模式，查看文件情况:
(1)$oracle8/app/oracle/admin/ora8/bdump/alert_ora8.log
. . . . . .
Sat Mar 29 09:39:00 2003
Thread 1 advanced to log sequence 30505
Current log# 3 seq# 30505 mem# 0: /home1/oracle8/ctl2/oradata/ora8/redoora803.
log
Sat Mar 29 10:14:41 2003
KCF: write/open error block=0x12c online=1
file=2 /vxdisk1/oradata/hfrbs01.dba
error=27063 txt: 'SVR4 Error: 6: No such device or address
Additional information: -1
Additional information: 2048
Additional information: -2133256192'
Instance terminating due to error 1242
Instance terminated by DBW0, pid = 1003
Sat Mar 29 11:38:04 2003
Starting ORACLE instance (normal)
. . . . . .
Sat Mar 29 11:38:07 2003
alter databasemount
Sat Mar 29 11:38:07 2003
Successful mount of redo thread 1.
Sat Mar 29 11:38:07 2003
Completed: alter databasemount
Sat Mar 29 11:38:07 2003
alter database open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 3 Seq 30505 Reading mem 0
Mem# 0 errs 0: /home1/oracle8/ctl2/oradata/ora8/redoora803.log
ORA-1172 signalled during: alter database open...
Shutting down instance (immediate)
License high water mark = 1
Sat Mar 29 11:44:51 2003
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Sat Mar 29 11:44:52 2003
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
(2)$oracle8/app/oracle/admin/ora8/bdump
-rw-r----- 1 oracle84 dba
798 3月 29 10:14 ora8_dbw0_1003.trc
1Dump file /home1/oracle8/app/oracle/admin/ora8/bdump/ora8_dbw0_1003.trc
2Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
3PL/SQL Release 8.0.4.0.0 - Production
4ORACLE_HOME = /home1/oracle8/app/oracle/product/8.0.4
5System name:SunOS
6Node name:zd4001
7Release:5.6
8Version:Generic_105181-16
9Machine:sun4u
10Instance name: ora8
11Redo thread mounted by this instance: 1
12Oracle process number: 3
13Unix process pid: 1003, image: ora_dbw0_ora8
14
15Sat Mar 29 10:14:41 2003
16*** SESSION ID

2.1) 2003.03.29.10.14.41.000
17KCF: write/open error block=0x12c online=1
18 file=2 /vxdisk1/oradata/hfrbs01.dba
19 error=27063 txt: 'SVR4 Error: 6: No such device or address
20Additional information: -1
21Additional information: 2048
22Additional information: -2133256192'
23error 1242 detected in background process
. . . . . .
手动方式启动出现的情况：
$ svrmgrl
Oracle Server Manager Release 3.0.4.0.0 - Production
(c) Copyright 1997, Oracle Corporation.All Rights Reserved.
Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
PL/SQL Release 8.0.4.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup mount
ORACLE instance started.
Total System Global Area17905856 bytes
Fixed Size
47296 bytes
Variable Size
11124736 bytes
Database Buffers
6553600 bytes
Redo Buffers
180224 bytes
Database mounted.
svrmgr>select * from v$log;
GROUP# THREAD#SEQUENCE#BYTESMEMBERSARC STATUS FIRS
T_CHAN FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ----
------ ---------
1
130503 512000
1 NOINACTIVE
151
908030 28-MAR-03
2
130504 512000
1 NOINACTIVE
151
908362 28-MAR-03
3
130505 512000
1 NOCURRENT 151
908728 29-MAR-03
3 rows selected.
SVRMGR> recover database using backup controlfile;
ORA-00308: cannot open archived log '/home1/oracle8/app/oracle/product/8.0.4/dbs
/arch1_30505.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
在物理磁盘中也无下面文件：
'/home1/oracle8/app/oracle/product/8.0.4/dbs/arch1_30505.dbf'
怎样恢复ORACLE数据库？在此先谢谢了，谢谢！
期待您的技术解决方法 . . .