Hi Guys
Need you help to recover this NEW detabase. NO BACKUP
I had to recreate the controlfile and now it is complaining about recovering the system file.
Any suggestion and recommendation and appreciated.
Thanks



Total System Global Area 6442450944 bytes
Fixed Size 2050200 bytes
Variable Size 687871848 bytes
Database Buffers 5737807872 bytes
Redo Buffers 14721024 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


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:

'/opt/app/hmpm1d1/oradata01/HMPROD/dbf/system_01.dbf'