- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 14:03:26
|
查看: 1204 |
回复: 0
数据库版本:12.1.0.2.0,平台:suse linux(虚拟机)
undo表空间数据文件损坏,无法open,alert报错如下:
Errors in file /oracleser/app12102/oracle/diag/rdbms/persondb/persondb/trace/persondb_dbw0_2470.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/data/oradata/persondb/undotbs01.dbf'
ORA-27048: skgfifi: file header information is invalid
尝试offline后数据库能够open:
alter database datafile '/data/oradata/persondb/undotbs01.dbf' offline
发现有很多需要回滚的segments
SEGMENT_NAME OWNER TABLESPACE_NAME STATUS
------------------------------ ------ ------------------------------ ----------------
SYSTEM SYS SYSTEM ONLINE
_SYSSMU10_832514571$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU9_4156997882$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU8_2674672116$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU7_527884491$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU6_2527403850$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU5_2096373581$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU4_4234299770$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU3_3668536125$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU2_3094239023$ PUBLIC UNDOTBS1 NEEDS RECOVERY
_SYSSMU1_3118338713$ PUBLIC UNDOTBS1 NEEDS RECOVERY
请问如何恢复undo表空间,如果需要恢复的segments很重要,不能丢失,该如何恢复呢?
undo头文件有损坏,有什么恢复方法呢?
oracle@pdccbpersondb:~> dbv file=/data/oradata/persondb/undotbs01.dbf
DBVERIFY: Release 12.1.0.2.0 - Production on Tue Mar 22 23:38:42 2016
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
DBV-00107: Unknown header format (0) (0)
dbv检查报错,是测试环境,随便搞~
|
|