Re: recover rman backup
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: jpatterson@xxxxxxxxxx
- Date: Wed, 21 Aug 2013 10:17:07 -0400
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@xxxxxxxxxx>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@xxxxxxxxx]
> 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..
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
