Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how do I tell how Data Guard is configured

Posted on 2012-03-16
5
Medium Priority
?
471 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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 78

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 78

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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

885 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