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 -> Re: Houston we have a problem.....

Re: Houston we have a problem.....

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 02 Oct 2006 20:45:43 +0200
Message-ID: <efrmdg$pv0$1@news6.zwoll1.ov.home.nl>


Doug Jones schreef:
> Ok, I successfully completed the restore and recover command... however
> at the end of the walk through it says to enter "alter database open
> resetlogs;" at this point I get the following:
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of alter db command at 10/02/2006 13:51:48
> ORA-01152: file 1 was not restored from a sufficiently old backup
> ORA-01110: data file 1:
> 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\WINRLS\SYSTEM01.DBF'
>

>> Posting machine details, like OS, would help.
>> Posting your init.ora contents and rman commands would

>
> 2.8ghz Xeon running windows server 2003 standard. 5gb of RAM and 1tb of
> storage. What other info would you like?
>
> Do you still need my "init.ora" contents posted?
>
> Thank you,
>
> Doug Jones
>
>

01152, 00000, "file %s was not restored from a sufficiently old backup "
// *Cause:  An incomplete recovery session was started, but an insufficient
//         number of logs were applied to make the database consistent. This
//         file is still in the future of the last log applied. The most
//         likely cause of this error is forgetting to restore the file
//         from a backup before doing incomplete recovery.
// *Action: Either apply more logs until the database is consistent or
//         restore the database file from an older backup and repeat 
recovery.

Which of the two possibilities apply, I cannot say.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Oct 02 2006 - 13:45:43 CDT

Original text of this message

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