Home » Server Options » Data Guard » Data guard availability
Data guard availability [message #358510] Tue, 11 November 2008 12:06 Go to next message
OracleDBA1
Messages: 7
Registered: November 2008
Junior Member
Hi everyone,
I have two questions :

1. How can we know whether the particular database has a standby database configured for it. (not by looking into the PFILE..)

2. Which are all the backgroung process is accosiated with data guard. And how can we monitor the progress of the log apply (not via sqlplus client but OS level (not sure, may be via dumps)

3.Why is Physical Standby preffered? WHile Logical confirms the resource utilization better?


regards,
Re: Data guard availability [message #363357 is a reply to message #358510] Sat, 06 December 2008 01:05 Go to previous messageGo to next message
Khurram Siddiqui
Messages: 5
Registered: March 2004
Junior Member
1. How can we know whether the particular database has a standby database configured for it. not by looking into the PFILE..)


You can check it via using data guard broker (if you configured DG brojker) either by using DGMGRL or enterprise manager with grid control

e.g with DGMGRL

DGMGRL> connect sys/sys@prod
Connected.
DGMGRL> show configuration

Configuration
  Name:            DRSolution
  Enabled:         YES
  Protection Mode: MaxPerformance
  Databases:
    PROD - Primary database<---------------------
    STBY - Physical standby database<------------

Current status for "DRSolution":
SUCCESS


2. Which are all the backgroung process is accosiated with data guard. And how can we monitor the progress of the log apply
(not via sqlplus client but OS level (not sure, may be via dumps)


The background process associated with data gurad are LGWR,ARCn.For the progress of the log apply you will have to monitor it by SQLPLUS tool or better do it with dataguard broker.


3.Why is Physical Standby preffered? WHile Logical confirms the resource utilization better?


Logical confirms the resource utilization better in what sense? Logical standby database transfer the log files into SQL statments and then executing the SQL statments on logical standby database.While redo apply technology used by the physical standby database applies changes using low-level recovery mechanisms, which bypass all SQL level code layers; therefore, it is the most efficient mechanism for applying high volumes of redo data.

Khurram

[Updated on: Sat, 06 December 2008 01:11]

Report message to a moderator

Re: Data guard availability [message #363400 is a reply to message #363357] Sat, 06 December 2008 13:59 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks Khurram

Previous Topic: dba
Next Topic: STANDBY ERR - ORA-16032
Goto Forum:
  


Current Time: Sat Dec 10 14:26:44 CST 2016

Total time taken to generate the page: 0.08506 seconds