Re: dataguard / applying archive logs

On 7/29/05, David Sharples <davidsharples_at_gmail.com> wrote:
> When we put the standby into managed recovery can we say only apply up
> to sequence 1 for each thread? It should be possible if someone was
> watching the logs being applied and cancelling managed recovery but
> that is dangerous and prone to failure.
>
> Anyway this can be done automatically

David,

I haven't used it myself, but doesn't this command do what you want? ALTER DATABASE RECOVER MANAGED STANDBY DATABASE [ THROUGH ARCHIVELOG [ THREAD n ] SEQUENCE n ] ] (from chapter 13 of the dataguard manual)

Actually, the syntax diagram has only "through all archivelog [...]" but the following command description has a line for "through archivelog [...]" that looks to do exactly what you want.

HTH or points you in the right direction.

Steven

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