- 最后登录
- 2013-9-30
- 在线时间
- 70 小时
- 威望
- 35
- 金钱
- 175
- 注册时间
- 2012-4-25
- 阅读权限
- 10
- 帖子
- 47
- 精华
- 0
- 积分
- 35
- UID
- 393
|
1#
发表于 2012-5-5 23:53:55
|
查看: 15111 |
回复: 6
ML:
数据库异常断点,所有数据文件和控制文件出现文件头损坏。
Thu May 03 10:07:37 2012
ALTER DATABASE MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/app/oradata/dbtest/control03.ctl'
ORA-27048: skgfifi: file header information is invalid
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/app/oradata/dbtest/control02.ctl'
ORA-27048: skgfifi: file header information is invalid
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle/app/oradata/dbtest/control01.ctl'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
Thu May 03 10:07:40 2012
Checker run found 3 new persistent data failures
ORA-205 signalled during: ALTER DATABASE MOUNT...
重建控制文件出现:
SQL> CREATE CONTROLFILE REUSE DATABASE "dbtest" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 2336
7 LOGFILE
8 GROUP 1 ('/oracle/app/oradata/dbtest/redo01.log') SIZE 50M,
9 GROUP 2 ('/oracle/app/oradata/dbtest/redo02.log') SIZE 50M,
10 GROUP 3 ('/oracle/app/oradata/dbtest/redo03.log') SIZE 50M
11 DATAFILE
12 '/oracle/app/oradata/dbtest/system01.dbf',
13 '/oracle/app/oradata/dbtest/users01.dbf',
14 '/oracle/app/oradata/dbtest/undotbs01.dbf',
15 '/oracle/app/oradata/dbtest/sysaux01.dbf',
16 '/oracle/app/oradata/dbtest/temp01.dbf',
17 '/oracle/app/oradata/dbtest/example01.dbf',
18 '/dbtest/database/datadoc01.dbf',
19 '/dbtest/database/dataidx01.dbf',
20 '/dbtest/database/datafile01.dbf',
21 '/dbtest/database/data02.dbf';
CREATE CONTROLFILE REUSE DATABASE "dbtest" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/oracle/app/oradata/dbtest/system01.dbf'
ORA-27048: skgfifi: file header information is invalid
文件头都坏了,这样的情况还有可能恢复否?
[ 本帖最后由 yanshoupeng 于 2012-5-7 16:52 编辑 ] |
|