Home » RDBMS Server » Backup & Recovery » ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01152: file 1 was not restored from a sufficiently old backup [message #261468] Wed, 22 August 2007 12:17 Go to next message
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
Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #261486 is a reply to message #261468] Wed, 22 August 2007 15:08 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you restored it from valid backup?

Use only
recover database ;

command.
Previous Topic: Automatic backups
Next Topic: while taking hotback .. instance got shutdown.. how to bring it backup
Goto Forum:
  


Current Time: Thu Dec 08 00:10:13 CST 2016

Total time taken to generate the page: 0.14958 seconds