Quote Originally Posted by vnktummala View Post
Dave -

Calling oracle support is the last option for all the DBAs on the earth after putting every attempt from there side. Thanks for your suggestion.
WHAT? if you have no clue - oracle support is the first call, thats what you pay them for!



As per the error posted, I understood that one of the redo logs had a block corruption. He didn't mention whether that redo log is current or inactive. He renamed the corrupted log with other name (not sure how far renaming on the same physical location works). So, the work around i suggest is ...

1. Recover until cancel
2. Open resetlogs.

Appreciate comments on this.

Thanks,
if it wasnt the online log then no recovery would be needed would it?

if you are going to say dangerous advice, keep it to yourself!