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 frustration

Re: RMAN frustration

From: Rogbaker <Rogbaker_at_gdi.net>
Date: 29 Jan 2003 08:55:15 -0800
Message-ID: <e40a12ea.0301290855.420c6c0@posting.google.com>


I am confused. I insert rows into a table then do a full backup. So, it seems logical that if I later delete rows in a table I should be able to recover them by recovering to a time that is between the time of the rows were added until the time that I did the backup. I am not sure if I can pick any point between this time, or it must be the time listed in the LIST BACKUP output. In any event, I was not able to recover the deleted rows.
-Roger

Everytime I did a full backup, I was changing the name of the backup file.

"Eberhard Niendorf" <eberhard.niendorf_at_epost.de> wrote in message news:<b17bbd$35s$05$1_at_news.t-online.com>...

>

> The error message is absolutely correct, the earliest time-point for
> point-in-time
> recovery is the completion time of the level 0 (full) backup. You can get
> the
> completion time from the "LIST BACKUP" output and then You can use
> this time as the point-in-time. The time must be before Your
> truncation-time.
> Look at the format attribute of Your example, if You write more than one
> backup with this format, You will destroy Your old backup.
Received on Wed Jan 29 2003 - 10:55:15 CST

Original text of this message

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