Hi,

It appears that you have issued the "RECOVER DATABASE" command instead of "RECOVER DATABASE UNTIL CANCEL".

If you issue "RECOVER DATABASE" oracle interprets that and complete recovery and will give you the error you mentioned as it expects more log files. If you issue "RECOVER DATABASE UNTIL CANCEL" then oracle interprets that as incomplete recovery and will allow you to open the database when you stop the recovery using CANCEL command.

Issue the imcomplete recovery command and stop it by issueing CANCEL. That should allow you to open the database with resetlogs.

Baliga