Avatar of sikyala
sikyala
Flag for United States of America asked on

how do I tell how Data Guard is configured

I am not familiar with Data Guard and I am trying to patch a database. It appears that Data Guard may be partially configured. According to sources it would have been done through Grid Control. Archivelog is not running, Fast Start is set to maximum performance and failover is set to disabled. When I log into dgmgrl and issue any commands I get ORA-16525 error code.  When I check the switchover_status it returns sessions active value. I have searched for documentation on Data Guard and have not found the right info that can help me figure out the current configuration. If it is a partial configuration I need to know what is missing and how to complete it.
Oracle DatabaseUnix OS

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
sikyala

ASKER
yes I checked the Master to see if it is in Archivelog mode
slightwv (䄆 Netminder)

So is it in archive log mode or isn't it?

What makes you think Data Guard is partially configured?
sikyala

ASKER
no it is not in archivelog mode. I wasn't sure because log_archive_dest parameter is set and when I type select switchover_status from v$database; it returns the value sessions active
as I said earlier I am not familiar with Data Guard that is why I submitted this question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
slightwv (䄆 Netminder)

Sorry.  I mis-read your previous comment "yes I checked the Master to see if it is in Archivelog mode" to say you checked and it was...  I was confused because you originally said it was not.

Archive log mode is separate from Data Guard.  Data Guard needs it but it is not specific to Data Guard.  Having log_archive_dest set really has nothing to to with a Data Guard config.