Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN Point In Time Recovery question
"Latyr" <latyr-nospam_at_free.fr> wrote in message news:<3fd3bbb8$0$7151$626a54ce_at_news.free.fr>...
> Hello
>
> I have a question about RMAN Pint In Time Recovery way of working.
> Let's assume this.
> I am performing 2 daily (11:00 - 23:00) hot full backups of my production
> database.
> After a month I have so 2x30 backup sets.
> Let's still assume that I have a 10 days windows retention.
> So all backupsets older that 10 days have been marked as expired in the
> repository and then deleted.
> So taking the last backup, would I be able to perform a Point In Time
> Recovery to restore/recover my database in the state it was 25 days ago at
> 12:55 ?????
>
> Thanks in advance.
>
> Latyr
No of course not. Recovery is rolling back uncommitted transactions
and rolling forward committed missing transaction. You would need a
backup of 25 days ago.
RMAN wasn't designed as a time machine: it was designed to go forward
only.
Sybrand Bakker
Senior Oracle DBA
Received on Thu Dec 11 2003 - 08:47:38 CST