Problem with putting Standby Database in managed recovery mode
Hi DBA Gurus,
We have a problem with keeping our Oracle standby database in 'MANAGED RECOVER MODE'.
Following is the situation:
In Standby database, I issue the following query
SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> RECOVER STANDBY DATABASE;
All the archived logs are properly transferred from Primary to Standby Database.
When I issue the RECOVER STANDBY DATABASE, all the logs gets applied. However , when I want to put the Standby in 'MANAGED RECOVER MODE'
by issuing 'RECOVER MANAGED STANDBY DATABASE', it comes out after few seconds with the error message as follows:
ORA-00308 : cannot open archived log
ORA-27041:unable to open file
ORA-04002:unable to open file
O/S- Error : The system cannot find the file specified.
The funny part is that the next sequence log(00392, in this case), which it is expecting has not been generated in the Primary Database itself.
I don't know why it is not waiting in the managed recover mode. We are using Oracle 8.1.6 running on windows NT.
Please help me. Thanks in advance for your valuable help.