Re: recover rman backup

From: Andy Klock <andy_at_oracledepot.com>
Date: Wed, 21 Aug 2013 10:17:07 -0400
Message-ID: <CADo_RaOWZoJph8YFArWAd3apaSVcFWqxxpkioxe06NKK_Hs2_g_at_mail.gmail.com>

Oliver,
With an inconsistent RMAN backup, (i.e. backup while the database is up) each datafile backed up will correspond to a different SCN. For example, the datafile backed up at 23:00 will have an SCN of 1000, while the last datafile backed up seven hours later will have an SCN of 1100.

An RMAN restore takes the datafiles from the backup files and places them on disk. It is the RMAN recover that uses archive logs to bring all the other datafiles up to that last SCN (1100 in my example). This makes the database consistent. Without the archive logs during the time of the backup, the backup is pretty much useless.

So for your recovery, you'll need to copy over those archive logs to the target and give it another go.

Good luck!

Andy

On Wed, Aug 21, 2013 at 8:56 AM, Patterson, Joel <jpatterson_at_entint.com>wrote:

> I think you can restore until the end of you backup. The archivelogs
> should be part of the backup sets that were used during the backup.
> Other listers can verify, but I did a test for this and it was true in my
> case.
>
> ymmv
>
> Joel Patterson
> Database Administrator
> 904 928-2790
>
> From: Oliver [mailto:ofabelo_at_gmail.com]
> Sent: Wednesday, August 21, 2013 8:40 AM
> To: Patterson, Joel
> Cc: Guillermo Alan Bort; Marcin Przepiorowski; Justin Mungal; oracle-l
> Subject: Re: recover rman backup
>
> Ok thanks, I understand it.
> But then, I can't recover database without applying archivelogs if I want
> recover database in the same point that backup finishes? Backups starts to
> 23:00 and it finishes to 07:00 more or less .. If I want recover the
> database until time that backup is done, is it possible? (I don't have
> archivelogs copied in target). Can I put "recover database" simply and it
> will recover it until 07:00 directly (when backup finishes and it is
> consistent).
> Thanks beforehand.
>
> Regards..
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 21 2013 - 16:17:07 CEST