recover database until cancel

From: <dbaplusplus_at_hotmail.com>
Date: 19 Apr 2007 17:03:26 -0700
Message-ID: <1177027406.816801.84830@y5g2000hsa.googlegroups.com>

Recover standby database until cancel using backup controlfile

This question may not be related to standby database per se, but recover database until cancel .... Command.

Oracle suggests a log sequence #. To apply. I am curious which v$ view(s) oracle looks at to come up with suggested no.

When I look at v$log_history, max(sequence#) is higher than what is Suggested by oracle at least initially when I create standby database from
Standby control files and database backup of primary database. After initial
application of archived logs, max(sequence#() in v$log_history is same as what is suggested by Oracle.

I am pretty sure Oracle uses some mechanism other than v$log_history. Appreciate if you can provide any pointers on Oracle's inner workings. Received on Thu Apr 19 2007 - 19:03:26 CDT