OraFAQ Forum: Backup & Recovery » Re: Open Database Error

Home » RDBMS Server » Backup & Recovery » Re: Open Database Error

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

Re: Open Database Error [message #245857]

Tue, 19 June 2007 01:37

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

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??

Report message to a moderator

Previous Topic:	About RMAN Backup.
Next Topic:	Export with compress=y not working?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 06:42:16 CDT 2025