Home » RDBMS Server » Backup & Recovery » Re: Open Database Error
Re: Open Database Error [message #245857] Tue, 19 June 2007 01:37 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

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: '/oradata/THERAP/datafile/o1_mf_system_36tfdtbg_.dbf'

I have only one image copy backup of system data file. And I use set newname + switch command. How I can solve the problem...

N.B: I tried to restore my database at very early time.But again same message is howing to me. And I have not deleted any redo logs.

[Updated on: Tue, 19 June 2007 05:19]

Report message to a moderator

Re: Open Database Error [message #246032 is a reply to message #245857] Tue, 19 June 2007 10:54 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
I have only one image copy backup of system data file. And I use set newname + switch command. How I can solve the problem...


Did you recover that file by applying archivelogs??how old is that backup .if its old and you dont have archivelogs
its not possible because now your checkpoint information would be different .

Do you have another full backup??
Previous Topic: About RMAN Backup.
Next Topic: Export with compress=y not working?
Goto Forum:
  


Current Time: Mon Dec 05 15:21:17 CST 2016

Total time taken to generate the page: 0.10525 seconds