Re: recover database until cancel

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 20 Apr 2007 07:02:24 +0200
Message-ID: <46284960$0$14546$426a34cc@news.free.fr>

<dbaplusplus_at_hotmail.com> a écrit dans le message de news: 1177027406.816801.84830_at_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.
|

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

Regards
Michel Cadot Received on Fri Apr 20 2007 - 00:02:24 CDT