Dbv-111 Ora-1219 Sys.X$Dbms_dbverify ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询

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. 还原并恢复文件.