WITH t AS ( SELECT COUNT(1) AS cnt FROM V$BACKUP_CORRUPTION
UNION ALL
SELECT COUNT(1) AS cnt FROM V$COPY_CORRUPTION
UNION ALL
SELECT COUNT(1) AS cnt FROM V$DATABASE_BLOCK_CORRUPTION )
SELECT SUM(cnt) AS cnt
FROM t;
你用上面的语句查一下
看查出来的是大于0的话
就表示有块坏
UNION ALL
SELECT COUNT(1) AS cnt FROM V$COPY_CORRUPTION
UNION ALL
SELECT COUNT(1) AS cnt FROM V$DATABASE_BLOCK_CORRUPTION )
SELECT SUM(cnt) AS cnt
FROM t;
你用上面的语句查一下
看查出来的是大于0的话
就表示有块坏
本文提供了一种使用SQL查询来检查Oracle数据库中是否存在损坏的块的方法。通过查询V$BACKUP_CORRUPTION, V$COPY_CORRUPTION和V$DATABASE_BLOCK_CORRUPTION视图,并汇总结果,可以确定是否有损坏的块存在。
616

被折叠的 条评论
为什么被折叠?



