user585511 wrote:May be physical corruption can occur, But logical corruption only on standby have less chances..
I am setting up a manual physical standby and I want to periodically check the standby database for physical and logical corruption.
I am not sure what is the best way to do it:
1) should I only use dbv?
2) should I open the database read only and use RMAN "validate database check logical ;" ?
3) should I open the database read only and use anlter table ... validate structure cascade ; for every table?
4) Do steps 2 and 3 do the same checks?
your idea is useful to verify whether archive log are being applied , but I am looking for a way to do some integrity check of the physical standby . That is why I was asking about the difference between rman's validate database and "alter table validate cascade" ;Lets suppose you have 3000 of tables, you cant perform validating for each tables?
The Database Administrator's Guide for your version should have a section on "Running Health Checks Manually"
SELECT name FROM v$hm_check WHERE internal_check='N';