I have a 18c DB in a test environment with a physical standby. I can setup log shipping and apply be enabling the following command.
alter system set log_archive_dest_state_2='enable' scope=both sid='*';
I am trying to figure out how to do it via dgmgrl.
If I log onto dgmgrl I run the following commands.
edit database sb_db SET STATE='apply-on';
edit database prim_db set state='LOG-TRANSPORT-ON';
and i get the following error.
Error: ORA-16516: current state is invalid for the attempted operation
if I go back and check log_archive_dest_state_2 it now says.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string RESET
if i then in turn set alter system set log_archive_dest_state_2='enable' scope=both sid='*';
it starts applying the logs when i check this query.
SEQUENCE# FIRST_TIME NEXT_TIME APPLIED
---------- -------------------- -------------------- ---------
74761 22-JAN-2020 13:07:39 22-JAN-2020 13:07:52 YES
74762 22-JAN-2020 13:07:52 22-JAN-2020 13:13:23 YES
What am i missing? Thanks in advance..