ORA-00265:instance recovery required, cannot set ARCHIVELOG mode
Hi,
Step 1:
SQL> startup pfile=E:\oracle\product\db\admin\orcl\pfile\init.ora.552008135236
ORACLE instance started.
Total System Global Area 1526726656 bytes
Fixed Size 1299048 bytes
Variable Size 352325016 bytes
Database Buffers 1166016512 bytes
Redo Buffers 7086080 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 28 - see DBWR trace file
ORA-01110: data file 28:
'D:\ORACLE\PRODUCT\DB\ORADATA\ORCL\DATAFILE\O1_MF_CONTENT__44L884LK_.DBF'
Step 2:
I have mounted the database, and issued the command:
alter database open resetlogs;
But im prompting with ORA-1139 error
Please help.
Regards,
- sri