System file recovery Help
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.
Total System Global Area 6442450944 bytes
Fixed Size 2050200 bytes
Variable Size 687871848 bytes
Database Buffers 5737807872 bytes
Redo Buffers 14721024 bytes
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:
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.