How to perform incomplete recovery to overcome Oracle database error

I have taken the backup of a database (Oracle 9i, installed in UNIX AIX OS), and when I restore the backup and start the Oracle database, the database is mounted. Then when I issue the "alter database open resetlogs" command, I get the following error:

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'
 
How can I resolve the issue?

To get past this issue and since you tried to open with RESETLOGS, you will have to perform incomplete recovery. Do the following:

STARTUP MOUNT

ALTER DATABASE RECOVER UNTIL CANCEL;

Apply the redo logs. When done, enter CANCEL

ALTER DATABASE OPEN RESETLOGS;