| 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??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
