Wednesday 28 December 2016

Oracle Data Guard Concept


Hi Friends,
Today, we will discuss about DataGuard. We will see as why we need Dataguard? We will also check the Advantages and Disadvantage.

Now, what is DataGuard?

A DataGuard provide us following as high availability, data protection, and disaster recovery for enterprise data. It provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. And also, it maintains these standby databases as copies of the production database.

It means, suppose the production database becomes unavailable because of a planned (if there is any maintenance) or an unplanned (like disaster, network issue etc.) outage. So, Data Guard can switch any standby database to the production role, and it will minimize the downtime associated with the outage. It can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability.

Advantages:

* Data Guard provides us below following below points:
* It helps in Data protection, high availability for a database system.
* Human intervention will be less in case of failover and failback switchover.
* By the using standby redo log files Data guard can minimize loss of data.
* It is simple management and centralized.
* It also supports in heterogeneous configurations where the primary and standby systems may have different CPU architectures, operating.

Disadvantages:

Suppose, if the network links connecting primary and standby is over-subscribed, and the redo logs are not shipped in chronological order, then this can result in large gaps appearing in the available of redo at the standby. Such a condition results in the standby being behind the primary.
Here, the same release of Oracle Database Enterprise Edition must be installed on the primary database and all standby databases also, except during rolling database upgrades using logical standby databases. Oracle Data Guard is available only as a feature of Oracle Database Enterprise Edition.

Data Guard Configurations Details:

A Data Guard configuration consists of one production database and one or more standby databases.
Here, we can manage primary and standby databases using the SQL command-line interfaces or the Data Guard broker interfaces, including a command-line interface (DGMGRL) and a graphical user interface that is integrated in Oracle Enterprise Manager.

Primary Database:
A Data Guard configuration contains one production database, which called as the primary database that functions in the primary role. And this is the database that is accessed by most of our applications.
This primary database can be either a single-instance Oracle database or an Oracle Real Application Clusters(RAC) database.

Standby Database:
DataGuard contain a standby database as transactionally consistent copies of the production or primary database. Once standby database created from production database backup copies, Data Guard can automatically maintains each standby database by transmitting the redo data from the production or primary database and then applying the redo to the standby database.

Standby database can also be either a single-instance Oracle database or an Oracle RACdatabase like Primary database.

There are two type of Standby database Physical Standby Database and Logical Standby Database.

A physical Standby Database provides a physically identical copy of the primary database, with on disk database structures that are identical to the primary database on a block-for-block basis. The database schema, including indexes, are the same. It always kept synchronized with the primary database, through Redo Apply, which recovers the redo data received from the primary database and applies the redo to the physical standby database.

A logical Standby Database is kept synchronized with the primary database through SQL Apply, which transforms the data in the redo received from the primary database into SQL statements and then executes the SQL statements on the standby database. A logical standby database can be used concurrently for data protection, reporting, and database upgrade with almost no downtime. 

As above discussion, we can see a simple and important difference between Physical and Logical Standby Database is that, In physical standby database is synchronizing through Redo Apply and In Logical Standby Database is synchronizing though SQL Apply. 


DATAGUARD SETUP STEPS>>

Hope these above details and concepts will be useful and helpful. In next update we will update for DataGuard setup.

DATAGUARD SETUP STEPS>>


Some more useful link:

Interviews Q & A

RAC concepts in Oracle
 

R12.1 Vs R12.2
 

R12.2 Architecture & Concepts

Please write to us for any more details and concepts which is not clear. Always remember, we like to hear from you. Contact us @ora-data.blogspot.com

Thanks

13 comments:

  1. Yes! Finally something about flat head screw.

    ReplyDelete
  2. Good day very nice web site!! Guy .. Excellent .. Superb ..

    I will bookmark your blog and take the feeds additionally?
    I am glad to find a lot of useful info right here within the put up, we want develop more techniques on this regard, thanks for sharing.
    . . . . .

    ReplyDelete
    Replies

    1. Dear User,

      Thank you very much for your support and like it.

      Thanks & Regards,
      ora-data Team.

      Delete
  3. Hello.This post was extremely fascinating, especially since I was investigating for thoughts on this issue last Monday.

    ReplyDelete
    Replies

    1. Dear User,

      Thank you for your feedback.

      Regards,
      ora-data Team

      Delete
  4. I really like reading through an article that will make people think.
    Also, many thanks for allowing for me to comment!

    ReplyDelete
  5. Howdy very nice site!! Man .. Excellent .. Amazing
    .. I'll bookmark your site and take the feeds additionally?
    I'm satisfied to search out a lot of helpful information here in the post, we'd like develop extra strategies on this regard, thank you
    for sharing. . . . . .

    ReplyDelete
  6. Hello, my USB mouse and my USB headphones stopped working but
    my regular USB that can save data is still working.
    Does anybody know a fix? new mouse and headphones.
    fixing them is not easy, and usually more expensive than just buying new ones...

    ReplyDelete
  7. Are you thinking to use Advantages of Oracle Database for your work or business? A reliable storage will store the data from a database, that's the main purpose of using DBMS. Using ACID test, Oracle ensures the top level reliability of your system. As well as, delivers high integrity of data storage.

    ReplyDelete
  8. Simply wish to say your article is as astonishing. The clarity in your post is simply great, and I could assume you are an expert on this subject. Same as your blog i found another one apex oracle .Actually I was looking for the same information on internet for Oracle APEX and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.

    ReplyDelete
  9. Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp a great deal more around this condition. and I could assume you are an expert on this subject. Same as your blog i found another one Oracle Fusion Financials.Actually I was looking for the same information on internet for Oracle Financials Cloud and came across your blog. I am impressed by the information that you have on this blog. Thanks a million and please keep up the gratifying work.

    ReplyDelete
  10. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here.Same as your blog i found another one Oracle Fusion HCM .Actually I was looking for the same information on internet for Oracle Fusion HCM and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  11. Fashion is exciting, so why should buying fashion items involve boring tasks walking around in one store after another?its time to boring more zing to fashion purchases
    Fashion App Development Company

    ReplyDelete

Thank you for your comments and suggestions. It's good to talk you.