Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help with Oracle restore!

Help with Oracle restore!

From: Yuri Weinstein \(HotMail\) <yuriw_at_hotmail.com>
Date: Mon, 23 Sep 2002 22:01:38 GMT
Message-ID: <6bMj9.24$kM6.1905972@newssvr14.news.prodigy.com>


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'

Any help is greatly appreciated.

Thx

Yuri Weinstein Received on Mon Sep 23 2002 - 17:01:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US