Re: recover rman backup

From: Oliver <ofabelo_at_gmail.com>
Date: Thu, 22 Aug 2013 08:49:11 +0100
Message-ID: <CALQkqm-rRT1ocFc-RPtTP0ZVFqvQgU62qTD9kGqroJWZsY6YjA_at_mail.gmail.com>

Thank you very much to all.
Ok, I'm getting a new copy with archivelogs backup and passing to target. One question more please. Source database is large and I'm having space issues in target server .. When I do restore, could I indicate not restoring about some datafiles? Is it possible? I see that datafiles are numbered .. 1, 2, 3, 4, ... I have 95 datafiles, could I do restore of specific datafiles? Or if I do that, then, when recovered is done, I couldn't open database :-?
Thanks beforehand.
Regards...

2013/8/21 Andy Klock <andy_at_oracledepot.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 Thu Aug 22 2013 - 09:49:11 CEST