Oh geeeshhhhh,
I guess I have to explain (spell out) what exactly I was asking for....

I'm not asking about what does "last" mean... for crying out load....

I'm asking...

Do anyone know what "mechanism" does Oracle use to check for corrupt data block that is inherent in a backup??? I'm asking this because of the document statement.. (again)

...
V$DATABASE_BLOCK_CORRUPTION displays information about database blocks that were corrupted after the last backup.
...


In order words, if all I do is cold backups, does that count and will Oracle detect corrupt data blocks when I do cold backups???

I wouldn't think so unless that "mechanism" is built in when I "gracefully" shutdown the database (as I would when I do a cold backup). Or better yet or more likely, when I startup the database (after a cold backup)... since v$ view are not persistent after a shutdown.

How about if all I do is hot backups??? Is that "mechanism" built-in when I put the tablespaces in backup mode???

Someone has said that this is only true if you're doing RMAN backups. They believe this make sense since "only" RMAN is what actually reads/tracks individual blocks. And therefore RMAN can be used to update this v$ view for corrupt block.

This is my question at hand....