Monday Nov 04, 2013

Makes Sure To Learn About Oracle GoldenGate 12c

Whether you use, or are interested in using, Oracle GoldenGate for

  • real-time data integration
  • database upgrades or migrations, or
  • heterogeneous database replication

the recently launched GoldenGate 12c release will certainly proof very interesting for you.

To learn more about it, make sure to attend the upcoming webcast:


In addition, there are several great blog entries over at the Oracle Data Integration blog:

Oracle GoldenGate 12c - Leading Enterprise Replication

Replicating between Cloud and On-Premises using Oracle GoldenGate

Welcome Oracle Data Integration 12c: Simplified, Future-Ready Solutions with Extreme Performance 

Wednesday Aug 07, 2013

MediSwitch makes the switch to Oracle Database Appliance

MediSwitch chose Oracle Database Appliance over competing solutions to replace a legacy database system of hardware and software from many different providers.  Recently, I had the pleasure of interviewing Wayne Botha, IT Manager of MediSwitch as he discussed their experience with Oracle Database Appliance.  Not only did they complete a complex migration using Oracle GoldenGate to facilitate a near zero downtime migration in a very short period of time they upgraded their database to Oracle Database 11g. Listen as Wayne describes how simple Oracle Database Appliance was to install and deploy and how the capacity-on-demand licensing played a key factor in their decision to purchase. Best of all they were able to consolidate all of their development testing and pre-production databases and can now use a single resource to patch everything in one go over their legacy system. Their big surprise was the significant performance benefit running reports that use to take 4 hours and now only take 45 minutes. If you are considering Oracle Database Appliance, you won't want to miss this podcast.





Wednesday Mar 20, 2013

Starwood Hotels Transforms Business in Real-Time with Oracle Exadata

Listen as Arup Nanda from Starwood Hotels and Resorts describes how Oracle Exdata Database Machine transformed their business to deliver real-time market data and  on-demand reports which allowed them to react quickly to changing market conditions while reducing IT infrastructure costs.

Tuesday Jan 15, 2013

Maximum Availability With Oracle GoldenGate

Real-time, heterogeneous, and transactional data replication capabilities make Oracle GoldenGate a key component of the Oracle Database Maximum Availability Architecture.

Listen to this recently recorded podcast to hear Nick Wagner from Oracle GoldenGate product management team, and Joe Meeks from Oracle Database product management team discuss how to use GoldenGate for maximum availability and the new features of GoldenGate 11gR2 that strengthen its high availability solutions.

This podcast is a little recap of the great live webcast we hosted back in December 2012. In case you missed it, make sure to watch it on demand, at your convenience.

Great questions were asked during that webcast, and our expert Joe Meeks was able to answer plenty of them. Here are some great examples of that:

Q: What is the difference between the logical standby and GoldenGate ?
Joe: Data Guard logical standby (SQL Apply) is an included feature of Oracle Enterprise Edition.  It utilizes all of the same transport and role management features used by Data Guard Redo Apply (physical standby database), but it uses SQL to apply changes to a standby database that is open read-write  (physical standby uses media recovery).  The focus SQL Apply is as a feature of Data Guard for database rolling upgrades.  The process begins with a primary and Data Guard physical standby.  The standby is converted to a logical and upgraded.  Production is then switched to the standby and the original primary (now a standby) is upgraded.  From 11g onward we use the Transient Logical Rolling Upgrade Process - this results in the upgrade concluding with a primary and physical standby both at the new version.  SQL Apply is only used for replication across version

GoldenGate is our comprehensive logical replication product.  It is meant to address all advance replication needs and is the preferred solution for requirements such as reporting offload where the target database must be open read-write, bi-directional and multi-master replication, zero downtime upgrades/migrations, data integration, etc.

Q: What is it that Oracle Data Guard can do that Oracle GoldenGate can't ?
Joe: This is a backward way of asking this question :-).  GoldenGate is a comprehensive, feature rich replication product.  It can do many things Oracle Data Guard can't.

Data Guard is very focused - simple physical replication.  Unlike GoldenGate, it maintains an exact physical replica of the primary (backups are interchangeable), it has no datatype or other restrictions to consider, it uses standard Oracle Media Recovery so has very high performance for all workkloads, it has advanced corruption protection - lost-write protection and automatic block repair.  It offers both Synchronous (a guarantee of zero data loss) and Asynchronous replication.

Data Guard's primary goal is to provide the simplest, fastest, most complete data protection for Oracle Database, period.

GoldenGates primary goal is to provide the most feature-rich replication solution for the broadest possible range of requirements.

My recommendation is to first understand your requirements and preferences, then chose the right tool for that job.

Q: How can we use the new DBFS in conjunction with Oracle Data Guard and GoldenGate ?
Joe: DBFS is useful in a GoldenGate configuration to store the GoldenGate trail files and checkpoint files in DBFS to provide recoverability and failover capabilities in the event of a system failure. Using DBFS is fundamental to the continuing availability of the checkpoint and trail files in the event of a node failure. Ensuring the availability of the checkpoint files is essential to ensure that, after a failure occurs, the Extract process can continue mining from the last known archived redo log file position and Replicat processes can start applying from the same trail file position before a failure occurred. Using DBFS allows one of the surviving database instances to be the source of an Extract process or destination for the Replicat processes.

From a Data Guard perspective - anything that is in DBFS is protected just as any other database data is protected.  So DBFS provides a way to have Data Guard protect file system content for you as well that would otherwise be external to the Oracle database.

Monday Dec 03, 2012

Webcast: Maximum Availability with Oracle GoldenGate

Make sure to register here for this upcoming live webcast, with great speakers, and a live Q&A chat session.
It is scheduled for Thursday, December 13th, 2012, at 10am Pacific Time.

There are no doubts about the strength, and depth, of Oracle's offerings for highly available database environments. But depending on the nature of your data center environments, your different uses cases and workloads, your service level agreements and expectations, there might still be some open questions about what the best solutions and architectures are to assure high availability and/or affordable, efficient disaster recovery.

Therefore, this webcast will answer questions such as:

Tuesday Sep 18, 2012

Questions and Answers from Today's Upgrade Webcast with Roy Swonger

Thanks for attending today's live webcast, 3 Compelling Reasons to Upgrade to Oracle Database 11g with Oracle Database Upgrade Expert Roy Swonger. We had an amazing turnout this morning and responded to more than 40 of your upgrade questions that I just couldn't wait to share with you.

Don't worry if you missed today's live webcast. You can register for the On-Demand version to learn about Oracle Database 11g upgrade best practices with real customer examples, plus loads of great upgrade resources for making database upgrades faster and easier. You can also download a copy of our webcast presentation.

About





Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
4
5
6
8
9
10
12
13
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today