Showing posts with label ORA-38740. Show all posts
Showing posts with label ORA-38740. Show all posts

Monday, 18 June 2012

ORA-38740: Usable blocks value string is not valid.

ORA-38740: Usable blocks value string is not valid.

Cause: A flashback database log file header contained a usable blocks value greater than the file size. The flashback database log file file is corrupt.

Action: If you are doing a FLASHBACK DATABASE, then the flashback cannot be performed because of the corrupted log. A restore and an incomplete recovery must be performed instead.