Hi,
I am using 12c database on-premise.
I already have data guard configured in the system that was working fine with 2 standby databases. However, I got a request to disable them which i did using (ALTER SYSTEM SET log_archive_dest_state_2 = DEFER)
Now, I got a request to enable one of the standby databases and redo archive should be applied there. What are the parameters that should be modified in this case?
Probably, parameter modifying log_archive_config to have only one standby? What else I have to modify?
As I haven't done Data guard configuration before, i am assuming to change log_archive_config & log_archive_dest_state_2
Is there any parameter missing here? Or the whole approach is wrong?