看看哪个高手能解决??磁盘坏,数据库服务无法启动,如何解决?急!急!急!!!!请教各位大侠,数据库服务无法启动,如何解决?急!急!急!!!!unix ,oracle 7.3 数据库安装在RAID5磁盘柜上(6块盘),其中一块坏了导致数据库无法启动使用SVRMGR,显示如下错误,ORACLE instance started.
Total System Global Area 17579776 bytes
Fixed Size 50832 bytes
Variable Size 10811504 bytes
Database Buffers 6553600 bytes
Redo Buffers 163840 bytes
Database mounted.
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: '/dbf/oradata/ora73/temp01.dbf'
ORA-01210: data file header is media corrupt我在操作系统状态下查看,temp01.dbf这个文件还有啊
将数据文件'/dbf/oradata/ora73/temp01.dbf'
脱机后,进入svrmgrl查询数据库有关表,信息如下:
SVRMGR> select * from v$controlfile;
STATUS NAME
------- --------------------------------------------------------------------------------
/dbf/oradata/ora73/control02.ctl
/dbf/oradata/ora73/control03.ctl
2 rows selected.
SVRMGR> select * from V$datafile;
FILE# STATUS ENABLED CHECKPOINT BYTES CREATE_BYT NAME
---------- ------- ---------- ---------- ---------- ---------- ---------------------------------------------------------------------
1 SYSTEM READ WRITE 17352152 57671680 57671680 /dbf/oradata/ora73/system01.dbf
2 ONLINE READ WRITE 17352152 104857600 104857600 /dbf/oradata/ora73/rbs01.dbf
3 RECOVER READ WRITE 17352152 2097152 2097152 /dbf/oradata/ora73/temp01.dbf
4 ONLINE READ WRITE 17352152 15728640 15728640 /dbf/oradata/ora73/tools01.dbf
5 ONLINE READ WRITE 17352152 1048576 1048576 /dbf/oradata/ora73/users01.dbf
6 ONLINE READ WRITE 17352152 524288000 524288000 /dbf/rb_wzgl.dbf
7 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl1.dbf
8 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl2.dbf
9 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl3.dbf
10 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl4.dbf
11 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl5.dbf
12 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl6.dbf
13 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl7.dbf
14 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl8.dbf
15 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl9.dbf
16 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl10.dbf
17 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/temp_wzgl1.dbf
17 rows selected.
SVRMGR> select * from v$logfile;
GROUP# STATUS MEMBER
---------- ------- --------------------------------------------------------------------------------
1 STALE /dbf/oradata/ora73/redoora7301.log
2 STALE /dbf/oradata/ora73/redoora7302.log
3 /dbf/oradata/ora73/redoora7303.log
3 rows selected.SVRMGR> select * from v$recover_file;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- --------------------
3 OFFLINE CORRUPT HEADER 17352057 08/30/05 11:21:40
4 ONLINE CORRUPT HEADER 17352057 08/30/05 11:21:40
5 ONLINE CORRUPT HEADER 17352057 08/30/05 11:21:40
3 rows selected请问是否,数据文件
3 temp01.dbf
4 tools01.dbf
5 users01.dbf 这三个文件都坏了,如何修复?请大侠指出下手的方向?
谢谢啊!!!!
Total System Global Area 17579776 bytes
Fixed Size 50832 bytes
Variable Size 10811504 bytes
Database Buffers 6553600 bytes
Redo Buffers 163840 bytes
Database mounted.
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: '/dbf/oradata/ora73/temp01.dbf'
ORA-01210: data file header is media corrupt我在操作系统状态下查看,temp01.dbf这个文件还有啊
将数据文件'/dbf/oradata/ora73/temp01.dbf'
脱机后,进入svrmgrl查询数据库有关表,信息如下:
SVRMGR> select * from v$controlfile;
STATUS NAME
------- --------------------------------------------------------------------------------
/dbf/oradata/ora73/control02.ctl
/dbf/oradata/ora73/control03.ctl
2 rows selected.
SVRMGR> select * from V$datafile;
FILE# STATUS ENABLED CHECKPOINT BYTES CREATE_BYT NAME
---------- ------- ---------- ---------- ---------- ---------- ---------------------------------------------------------------------
1 SYSTEM READ WRITE 17352152 57671680 57671680 /dbf/oradata/ora73/system01.dbf
2 ONLINE READ WRITE 17352152 104857600 104857600 /dbf/oradata/ora73/rbs01.dbf
3 RECOVER READ WRITE 17352152 2097152 2097152 /dbf/oradata/ora73/temp01.dbf
4 ONLINE READ WRITE 17352152 15728640 15728640 /dbf/oradata/ora73/tools01.dbf
5 ONLINE READ WRITE 17352152 1048576 1048576 /dbf/oradata/ora73/users01.dbf
6 ONLINE READ WRITE 17352152 524288000 524288000 /dbf/rb_wzgl.dbf
7 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl1.dbf
8 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl2.dbf
9 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl3.dbf
10 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl4.dbf
11 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl5.dbf
12 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl6.dbf
13 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl7.dbf
14 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl8.dbf
15 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl9.dbf
16 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/wzgl10.dbf
17 ONLINE READ WRITE 17352152 1048576000 1048576000 /dbf/temp_wzgl1.dbf
17 rows selected.
SVRMGR> select * from v$logfile;
GROUP# STATUS MEMBER
---------- ------- --------------------------------------------------------------------------------
1 STALE /dbf/oradata/ora73/redoora7301.log
2 STALE /dbf/oradata/ora73/redoora7302.log
3 /dbf/oradata/ora73/redoora7303.log
3 rows selected.SVRMGR> select * from v$recover_file;
FILE# ONLINE ERROR CHANGE# TIME
---------- ------- ------------------ ---------- --------------------
3 OFFLINE CORRUPT HEADER 17352057 08/30/05 11:21:40
4 ONLINE CORRUPT HEADER 17352057 08/30/05 11:21:40
5 ONLINE CORRUPT HEADER 17352057 08/30/05 11:21:40
3 rows selected请问是否,数据文件
3 temp01.dbf
4 tools01.dbf
5 users01.dbf 这三个文件都坏了,如何修复?请大侠指出下手的方向?
谢谢啊!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货