诗檀软件专业数据库修复团队
oerr ora 1219
01219, 00000, "database not open: queries allowed on fixed tables/views only"
// *Cause: A query was issued against an object not recognized as a fixed
// table or fixed view before the database has been opened.
// *Action: Re-phrase the query to include only fixed objects, or open the
// database.
Ora-01219 Ora-01219 Ora-01219 Ora-01219
Ora-1219 Ora-1219 Ora-1219 Ora-1219
症状
备用数据库的几个文件上报告DBV-00111 错误
.
原因
损坏文件
1. 用 RMAN 来检查损坏:
RMAN (BACKUP VALIDATE CHECK LOGICAL DATAFILE 9,10;)
It completed.
2. 查询 V$DATABASE_BLOCK_CORRUPTION 看是否有任何损坏被报告:
select * from v$database_block_corruption;
It returned:
File#: 10
Block#: 83107
Blocks: 1
Corruption: Logical
3. 我们不能在dba_extents上运行查询来找出备用的对象，所以就在主机上运行以下查询来寻找损坏块:
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = 10
and 83107 between block_id AND block_id + blocks - 1;
.
解决方案
为实现该解决方案，请执行以下步骤:
1. 还原并恢复文件.