Re: RMAN until sequence

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Wed, 27 Jul 2016 16:02:10 +0530
Message-ID: <CAFW4NVzAMFyKP9mShJr7Pp4viTmY7gopTVNQNVrxKPjQUAdsEw_at_mail.gmail.com>



So in my case it will do recovery upto 20415 . .Upper limit (20416) will not be included in recovery right ? Just a sample script below :

run {

set until sequence 20416 ;
recover database ;

}

On Wed, Jul 27, 2016 at 3:54 PM, Stefan Koehler <contact_at_soocs.de> wrote:

> Hey BR,
> Oracle documentation describes it or may i misunderstood your question?
>
> http://docs.oracle.com/database/121/RCMRF/rcmsubcl022.htm#RCMRF160
>
> "Specifies a redo log sequence number and thread as an upper, noninclusive
> limit. RMAN selects only files that it can use to restore or recover up to
> but not including the specified sequence number."
>
> Best Regards
> Stefan Koehler
>
> Freelance Oracle performance consultant and researcher
> Homepage: http://www.soocs.de
> Twitter: _at_OracleSK
>
> > sumit Tyagi <dba.tyagisumit_at_gmail.com> hat am 27. Juli 2016 um 12:16
> geschrieben:
> >
> > set until sequence 20416 ;
> >
> > Will this include archive 20416 during RMAN recovery or will it do upto
> 20415 . ??
> >
> > --
> >
> > --
> > BR
> > Sumit
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 27 2016 - 12:32:10 CEST

Original text of this message