Re: Question: RMAN 10g TSPITR - Keeps failing

On 1 Dec 2005 12:13:17 -0800, "BD" <bobby_dread_at_hotmail.com> wrote:

>Result:
>RMAN-03002: failure of recover command at 12/01/2005 12:59:08
>RMAN-06555: datafile 13 must be restored from backup created before
>2005-12-01 11:54:00
>
>The only way I can get it to proceed is to set the until time to
>11:56:00 - which is the time of the _last_ incremental backup. This
>defeats the purpose of TSPITR, as I should be able to restore to the
>point of any of the incrementals (or so I thought).
>
>I am quite sure the nls_date_format is working, because when I do a
>'list backup', the Completion Time format matches the format of my
>declared date format. Also, I used the same date_format syntax for the
>incomplete recovery, and it worked fine - it allowed me to recover the
>db to the point of one specific incremental backup in the series.
>
>I hope I've supplied enough information to be reasonably clear.
>
>Any ideas out there?

Apparently the tablespace is 'current', so it doesn't need recovery at all. Consequently the error message is obvious. If you want to recover a tablespace prior to the current time, you need to restore it from a backup first. The restore command however is missing from your code.

--
Sybrand Bakker, Senior Oracle DBA