| Data guard availability [message #358510] |
Tue, 11 November 2008 12:06  |
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  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
