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 -- //www.freelists.org/webpage/oracle-l