<dbaplusplus@hotmail.com> a écrit dans le message de news: 1177027406.816801.84830@y5g2000hsa.googlegroups.co m...
| 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.
|

It starts with the archive containing the lowest scn found in the file headers.

Regards
Michel Cadot