Friday, November 9, 2012

Product Licenses Oracle GoldenGate and Oracle Active DataGuard


Product Licenses Oracle GoldenGate and Oracle Active DataGuard

Oracle Golden Gate and Oracle Active Data Guard are strategic capabilities within Oracle's software portfolio and are complementary to each other. When used together, Oracle GoldenGate and Oracle Active Data Guard offer a unique data protection and information distribution solution not offered by any other product.

Note:
Oracle GoldenGate is an Oracle product sold independently of the Oracle Database for Oracle and third-party database management systems. It is available for both Oracle Database Enterprise Edition and Oracle Database Standard Edition. A license for Oracle GoldenGate includes a license for Oracle Active Data Guard.


Oracle Active Data Guard requires a separate license and can only be used with Oracle Database Enterprise Edition. It can be purchased as the Active Data Guard Option for Oracle Database Enterprise Edition. It is also included with Oracle GoldenGate. Basic Data Guard functionality does not require a separate license, and it is included with Oracle Enterprise Edition.

Oracle GoldenGate is Oracle's strategic product for data distribution and data integration.
 

Oracle GoldenGate supplements Active Data Guard with its heterogeneous and bidirectional replication capabilities to enable enterprise-wide information distribution, zero-downtime upgrades and migrations, query offloading to heterogeneous systems, and multimaster database solutions.

Depending on the business situation:
Choose Oracle Active Data Guard for a simple, high-performance, drop-in solution for disaster recovery, data protection, and high availability for the entire Oracle database.
 

Choose Oracle GoldenGate to set up a data distribution and data synchronization solution through this Oracle-Oracle replication configuration, or a more flexible multimaster HA solution.

Thursday, November 8, 2012

Comparative Study Between Oracle GoldenGate and Oracle DataGuard


Comparative Study Between Oracle GoldenGate and Oracle DataGuard


Technical Points   Oracle Dataguard / Oracle Active Dataguard   Oracle GoldenGate
         
Operating System   Primary Database and Standby Database Should be same. (But 11g Onwards it supports Heteregenous Data Guard Configurations.                       Example : We can imeplement Oracle Data Guard between Oracle Linux server 6.2 (x86_64)  and Microsoft Windows 2008 Server R2 (x64)   Primary Database and Standby Database need not be same.
         
Database   Should be Oracle Database in both Source and Target.   Database can be different in Source and Target. Example :Source database can be Oracle and Target database can be MY SQL/MS SQL server.
         
Database Version   Primary Database and Standby Database Should be same.   Primary Database and Standby Database need not be same. (Including Database Software).
         
Replication method   Data movement will be in-form of Log Files.   It moves Data Transaction wise through Extract and Replicat process from Source to Target, when commits.
         
Database mode    Source: Read write mode
Target:  Recovery Mode / Open Read Only.
  Source: Read write mode
Target:  Read write mode
         
Replication Type   Unidirectional. (Data movement will happen in single direction).   Multi-Directional.
         
Integrated Feature   No additional software to install. Oracle Data Guard /Active Data Guard includes in Enterprise Edition.   Oracle GoldenGate software to install in Source as well as Target.
         
License Cost   No additional license required for Oracle Data Guard to install. Oracle Active Data Guard is an enterprise option with Oracle Enterprise Edition.   Oracle GoldenGate Software Licence required in Source and Target Databases.
         
Database Edition   Source: Oracle Enterprise Edition
Target: Oracle Enterprise Edition.
  Source: Can be Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One
Target:  Oracle Enterprise Edition/Oracle Standard Edition/Oracle Standard Edition One

Tuesday, November 6, 2012

How to check which Enterprise Options are enabled in your Oracle Database


The following Oracle Database features will require additional enterprise option along with Oracle Enterprise Edition (EE).

1. Oracle Partitioning
2. Oracle OLAP
3. Oracle DataMining
4. Oracle OLTP Compression
5. Oracle Label Security
6. Oracle Advanced Security
7. Oracle RAC
8. Oracle Data Masking Pack
9. Oracle Flashback Data Archive
10. Oracle Active Data Guard

Before moving your databases to production environment, check the above Oracle options enabled in your Oracle Database. Based on Oracle License Options you can disable/enable the above Oracle Features.

Oracle has views to tell if you have been using specific extra cost Oracle features in your Oracle Database.

from which date.


Query :

Set feedback off
Set linesize 122
Col name                         format a45     heading "Feature"
Col version                    format a10     heading "Version"
Col detected_usages  format 999,990 heading "Detected|usages"
Col currently_used    format a06     heading "Curr.|used?"
Col first_usage_date  format a10     heading "First use"
Col last_usage_date   format a10     heading "Last use"
Col nop noprint
Break on nop skip 1 on name
SQL> Select decode(detected_usages,0,2,1) nop,
                          name, version, detected_usages, currently_used,
                          to_char(first_usage_date,'DD/MM/YYYY') first_usage_date, 
                          to_char(last_usage_date,'DD/MM/YYYY') last_usage_date
            from dba_feature_usage_statistics
           order by nop, 1, 2