For sanjay92:

SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using BACKUP CONTROLFILE until cancel;
ORA-00279: change 478885897 generated at 04/30/2002 17:52:04 needed for thread
1
ORA-00289: suggestion : /export/home/u03/oradata/noya/arch/arch_1_470.arc
ORA-00280: change 478885897 for thread 1 is in sequence #470


Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/export/home/u03/oradata/noya/system01.dbf'


ORA-01112: media recovery not started


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/export/home/u03/oradata/noya/system01.dbf'