When do you need to "alter database open resetlogs"?

[marist89]

Indirectly, yes.

You must use RESETLOGS when you do an incomplete recovery. By losing the controlfiles, you either have to recover with a backup controlfile or re-create your controlfiles, effectively requiring you to do an incomplete recovery.