Hi all,

I have a doubt in standy Database Configuration.
We are using Oracle 8.1.6 working on windows 2000.

The standby databse is configured to receive archivelogfiles and
archive log files are transferred automatically. Till this is fine.

Now if i want to put the standby database in managed recovery mode

SQL> Recover managed standby database;

we recive an error Archive logfile not found
eg. Arc008.log not found
Actually there are only upto arc007.log even in the primary db and Standby DB


if i issue this command in the primary database after two log switches

sql> Select max(sequence#) from v$log_history;
output is 9

if i issue this command in standby database i get the old number before the log switches
sql> Select max(sequence#) from v$log_history;
output is 7

but the archive log files are tranferred.
Arc008.lo and arc009.log are found in teh standby host

but i dont think its applied automatically.

How do you set the atandby databse to apply these logs automatically as soon as they receive them.


Thanks and regards