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的话
就表示有块坏