Solved

how do I tell how Data Guard is configured

Posted on 2012-03-16
5
459 Views
Last Modified: 2012-03-20
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
Comment
Question by:sikyala
  • 3
  • 2
5 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37731668
>>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
 

Author Comment

by:sikyala
ID: 37734555
yes I checked the Master to see if it is in Archivelog mode
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37738006
So is it in archive log mode or isn't it?

What makes you think Data Guard is partially configured?
0
 

Author Comment

by:sikyala
ID: 37738977
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
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37739001
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
constraint check 2 48
Oracle collections 15 27
how to double quote a string for an inline sql statement. 8 73
Loading flat file data in tables 2 41
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question