I got stuck up when i was doing recovery. Please help me.
I opened the database in noarchivelog mode and inserted 5 records and made logswitch purposely but I dint gave any DML statements so that SYSTEM datafile gets affected. After that I shutdown the database and before starting the database I corrupted the datafile for which I inseted the records but I dint corrupt SYSTEM file.
After that when I tried to start the database I got the following error:-
ORACLE instance started.
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\KARTHIK\NAVDBF.DBF'
After that I restored the datafile to its original location and since I had started the database in noarchive mode I gave the following command:-
ALTER DATABASE RECOVER UNTIL CANCEL;
After that it gave
Warning: RECOVER succeeded but must use RESETLOGS or NORESETLOGS option for database open
After that I gave following command:-
SQL> alter database open resetlogs;
alter database open resetlogs
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\KARTHIK\SYSTEM01.DBF'
But I dint gave any DML statements so that SYSTEM datafile gets affected when database was up and running in noarchivelog mode before recovery.
Please guide me.