Re: Help with Oracle restore!

W artykule <6bMj9.24$kM6.1905972_at_newssvr14.news.prodigy.com>, Yuri Weinstein \(HotMail\) napisał(a):

> Our oracle server was shut down improperly.
> Now we get this message:
> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
> and when we try to fix this by hand from sqlplus, we get:
> 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: '/usr/local/oracle/oradata/merced/system01.dbf'
>

Did you restore database from backup ?
Is your database in archivelog ?
This error mean that you have old controlfile and new database file. If you wanna help answer this questions

Pozdrawiam

-- 
                                   *************************
Marcin 'PIORO' Przepiórowski       *    BORN TO BE WILD    *
http://oraforum.altkom.com.pl      *************************