Re: Question: RMAN 10g TSPITR - Keeps failing
- From: Sybrand Bakker <postbus@xxxxxxxxxxxxxxxxx>
- Date: Thu, 01 Dec 2005 21:34:59 +0100
On 1 Dec 2005 12:13:17 -0800, "BD" <bobby_dread@xxxxxxxxxxx> 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
.
- Follow-Ups:
- References:
- Prev by Date: Re: Question: RMAN 10g TSPITR - Keeps failing
- Next by Date: Re: init.ora and procesors
- Previous by thread: Re: Question: RMAN 10g TSPITR - Keeps failing
- Next by thread: Re: Question: RMAN 10g TSPITR - Keeps failing
- Index(es):
Relevant Pages
|
