DBMS Question
Oracle Dataguard architecture

Question

DBMS Question

Oracle Dataguard architecture

Accepted Answer

1) Oracle's Data Guard is a well test and supported solution but it does not come cheap but it is a solution that is practically the same across all companies and one that all DBA's should be able to grasp very quickly when starting at a new company.

2) Data Guard is basically a ship redo and then apply redo, as you know redo is the information needed to recover a database transaction. A production database referred to as a primary database transmits redo to one or more independent replicas referred to as standby databases.

3) Standby databases are in a continuous state of recovery, validating and applying redo to maintain synchronization with the primary database. A standby database will also automatically resynchronize if it becomes temporary disconnected to the primary due to power outages, network problems, etc.

4) Firstly the redo transport services transmits redo data from the primary to the standby as it is generated.

5)Secondly services apply the redo data and update the standby database files.

6) Thirdly independently of Data Guard the database writer process updates the primary database files.

7) Lastly Data Guard will automatically resynchronize the standby database following power or network outages using redo data that has been archived at the primary.

Top Walmart Database Admin interview questions & answers

Popular interview questions of Database Admin