Data Guard Commands to stop and start when you are NOT using DGMGRL

# from the standby – to start real time apply
sql> startup mount;
sql> alter database recover managed standby database using current logfile disconnect;
# from the standby to stop real time apply – still open in mount mode
sql> alter database recover managed standby database cancel;
# on the standby – open in read only – make sure you cancel first
sql> alter database open read only
# now – if you start the apply with the command below – you better have a “Active Data Guard License” cuz this will register it as such with a license “high water mark” so DON’T DO THE FOLLOWING WITH THE DB open READ ONLY – unless you want to use Active Data Guard
sql> alter database recover managed standby database using current logfile disconnect;
# better yet – just shut it down and restart the apply
sql> shutdown immediate;
sql> startup mount;
sql> alter database recover managed standby database using current logfile disconnect;
# from the primary
sql> select recovery_mode from v$archive_dest_status where dest_id = 2;
RECOVERY_MODE
————————–
MANAGED REAL-TIME APPLY

Scroll to Top