High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Oracle 11g Active Data Guard

 I try Active Data Guard in oracle 11g

SQL> alter database recover managed standby database cancel;

Database altered.
SQL> alter database open read only;
 
Database altered.
SQL> alter database recover managed standby database disconnect;
 
Database altered.

but it generate error:

ORA-38800: Cannot start Redo Apply on the open physical standby database

Both pri and stb DB is 11g.

how to fix it

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center