OraFAQ Forum: Backup & Recovery » ORA-01152: file 1 was not restored from a sufficiently old backup

Home » RDBMS Server » Backup & Recovery » ORA-01152: file 1 was not restored from a sufficiently old backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01152: file 1 was not restored from a sufficiently old backup [message #261468]

Wed, 22 August 2007 12:17

naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore

Member

Hi,
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:-

SQL> startup;
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
Database mounted.

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.

Regards,
Naveen

Report message to a moderator