-
Hi i have tried this command several times but shipped logs do not get applied to standby database.
the seq of commands i executed is as follows:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
SQL> alter database mount standby database;
Database altered.
SQL> recover managed standby database disconnect from session;
Media recovery complete.
SQL> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active
SQL> alter database open read only;
Database altered.
-
Oracle for sure provide some information in the alert log. Why don't you read your alert log or any trace files and find out what is going on after you start the MRM?
once again make sure that all the logs are are shipping to standby location and you don't have any archive log gaps.
Thanks,
-
man i read those files the first time i encountered the error. But not able to figure out what went wrong..MRP0 starts and completes successfully but logs do not get applied. anyways thanks for responding.
