Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

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.
0
sikyala
Asked:
sikyala
  • 3
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
>>Archivelog is not running

Are you logging into the 'master. or the failover database?

If the master and not in archive log mode, then I don't see how data guard is set up.

>>have not found the right info that can help me figure out the current configuration

The online docs should have it all.
0
 
sikyalaSenior Database AdministratorAuthor Commented:
yes I checked the Master to see if it is in Archivelog mode
0
 
slightwv (䄆 Netminder) Commented:
So is it in archive log mode or isn't it?

What makes you think Data Guard is partially configured?
0
 
sikyalaSenior Database AdministratorAuthor Commented:
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
0
 
slightwv (䄆 Netminder) Commented:
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.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now