Re: dataguard / applying archive logs

On 7/29/05, David Sharples <davidsharples@xxxxxxxxx> 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

Other related posts: