ORA-01113 and ORA-01110 DURING ALTER DATABASE OPEN RESETLOGS

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'D:\ORCL\DATABASE\ORADATA\GINE\SYSTEM01.DBF'

One of my student after doing incomplete recovery for the database, encounter “ORA-01113 and ORA-01110” while issuing alter database to open mode with reset-logs. 

After checking, I came to know that, during incomplete recovery  he was providing the wrong input and he must give input as “RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;”.

Now as you can see the database opened.

Note: whenever we open database with resetlogs option the redo logs are re-created.

After database recovery, Kindly consider full database backup for future safety.

Stay Tune.