Want to check whether I have corrupted blocks
I have 10.2.0.4 database on windows and have recovery catalog database on a different machine and I set up daily backups. Everything is working fine.
Now I want to check whether I have any corrupted blocks in my database. To find out corrupted blocks in the database, I issued validate database command after connecting to the target database at rman prompt. The command resulted the following error.
D:\oracle\product\10.2.0\db_1>rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Tue Sep 28 08:23:16 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: SSD1 (DBID=100000075)
RMAN> validate database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============