Solved

how do I tell how Data Guard is configured

Posted on 2012-03-16
5
461 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Nested table uses ? 2 60
sed command 3 30
leap year shell script 10 53
/etc/sudoers on Solaris 2 20
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

751 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