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

MOSC Banner

recovery_mode in v$archive_dest_status

Non-Active Data Guard 12.1.0.2 - ASYNC

We are configured with Data Guard broker - dgmgrl. 

Whenever we are doing something that needs to have the log apply turned off, or canceled, in dgbroker we do the following, but the apply-off for the primary isn't right. 

With it in, or not, when I query v$archive_dest_status on the primary I still see recovery_mode as 'MANAGED REAL TIME APPLY'.  I expect it to be IDLE. 

On the standby, the same query shows IDLE. 

Am I missing something that I need to tell the primary to cancel?

edit database ${SBY_DB} set state='apply-off';

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