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: RMAN Point In Time Recovery question

Re: RMAN Point In Time Recovery question

From: <sybrandb_at_yahoo.com>
Date: 11 Dec 2003 06:47:38 -0800
Message-ID: <a1d154f4.0312110647.331d1c91@posting.google.com>


"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

Original text of this message

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