IBM Consulting

DBA Consulting can help you with IBM BI and Web related work. Also IBM Linux is our portfolio.

Oracle Consulting

For Oracle related consulting and Database work and support and Migration call DBA Consulting.

Novell and RedHatConsulting

For all Novell Suse Linux and SAP on Suse Linux questions releated to OS and BI solutions. And offcourse also for the great RedHat product like RedHat Enterprise Server and JBoss middelware and BI on RedHat.

Microsoft Consulting

For all Microsoft related consulting services.

Citrix Consulting

Citrix VDI in a box, Desktop vertualizations and Citrix Netscaler security.

Welcome to DBA Consulting Blog. The specialist for IBM, Oracle, Novell, RedHat, Citrix and Microsoft.

DBA Consulting is a consultancy services specialist who can help you with OS related support and migration and install. Also BI implementations from IBM like Cognos 10 and Microsoft BI like SQL Server 2008, 2012 and the CMS systems releated to it like Microsoft Sharepoint and Drupal and Oracle OBIEE 11R1. We focus on quality and service and customer whishes are central, just like quality of services and customer satisfaction. Our focus on cost savings and no vendor lock in are central in business values.

Oracle related video's


Thursday, January 29, 2015

IBM New Mainframe System z13 and z-Linux

IBM's new mainframe provides unprecedented new capabilities, including: 

ibmsystemz on Broadcast Live Free

z13 is the first system able to process 2.5 billion transactions a day - equivalent of 100 Cyber Mondays every day of the year.  z13 transactions are persistent, protected and auditable from end-to-end, adding assurance as mobile transactions grow -- estimated to grow to 40 trillion mobile transactions per day by 2025. [1]

z13 is the first system to make practical real-time encryption of all mobile transactions at any scale.  z13 speeds real-time encryption of mobile transactions to help protect the transaction data and ensure response times consistent with a positive customer experience.  The system includes 500 new patents including cryptographic encryption technologies that enable more security features for mobile initiated transactions.

z13 is the first mainframe system with embedded analytics providing real-time insights on all transactions. This capability can help guarantee the ability of the client to run real-time fraud detection on 100 percent of their business transactions [2]
The rapid growth of mobile applications has created consumers who expect mobile transactions to be fast and seamless – regardless of which mobile payment platform, retailer, or financial organization is providing the service. As a result, businesses are being forced to evaluate whether their IT infrastructures can support mobile applications that meet and exceed these consumer expectations -- or face the potential of losing clients to competing businesses.

 “Every time a consumer makes a purchase or hits refresh on a smart phone, it can create a cascade of events on the back end of the computing environment. The z13 is designed to handle billions of transactions for the mobile economy.  Only the IBM mainframe can put the power of the world's most secure datacenters in the palm of your hand," said Tom Rosamilia, senior vice president, IBM Systems. "Consumers expect fast, easy and secure mobile transactions. The implication for business is the creation of a secure, high performance infrastructure with sophisticated analytics."

z13 Helps with Secure, Trusted Mobile Transactions

As mobile adoption grows, consumers are driving exponentially larger numbers of mobile transactions. Each of these mobile transactions triggers a cascade of events across computing systems. These events include comparisons to past purchases, data encryption and decryption, bank-to-bank reconciliations, and customer loyalty discounts. This cascade of events causes a so-called “starburst effect” – where a single transaction can trigger as few as four or as many as 100 additional system interactions.

Consequently, the starburst effect can create security vulnerabilities at each interaction point. In fact, 71 percent of CIOs and IT managers surveyed by IBM indicated that security is their most significant mobile enterprise challenge. [3] With data and transactions under constant threat from multiple points of attack, consumers want to know that their mobile transactions are as secure as financial data held by banks.

When combined with IBM MobileFirst solutions, the z13 delivers enhanced performance, availability, analytics and security that will drive optimal mobile user experiences.  IBM MobileFirst Platform enables organizations to deliver better, more secure apps. IBM MobileFirst Protect delivers seamless security and end-to-end management of clients' infrastructure and all its devices, apps, content and transactions.

Providing Insight with Every Transaction

The z13 features the world’s fastest microprocessor, 2X faster than the most common server processors, 300 percent more memory, 100 percent more bandwidth and vector processing analytics to speed mobile transactions. As a result, the z13 transaction engine is capable of analyzing transactions in “real time” and will be able to help prevent fraud as it is occurring, allowing financial institutions to halt the transaction before the consumer is impacted. IBM has designed the z13 to integrate real-time scoring and guarantees this capability as a feature of the system. This scoring can be used for fraud detection on 100 percent of a client's business transactions. [4]

In addition to assistance with fraud prevention, businesses looking to enhance their customer loyalty programs will be able to use new z13 capabilities to add more personalization by gaining a real-time view of a client's purchasing habits to offer up-sell and cross-sell promotions before they leave the store -- and in some cases before they even enter.
Businesses today don’t have the ability to analyze 100 percent of a consumer's transaction. With the z13, businesses will be able to use IBM's predictive analytics modeling technology, SPSS, and personalize the transaction as it occurs.
The z13 includes new support for Hadoop, enabling unstructured data to be analyzed in the system. Other analytics advances include faster acceleration of queries by adding DB2 BLU for Linux providing an in-memory database, enhancements to the IBM DB2 analytics accelerator, and vastly improved performance for mathematically intense analytics workloads.

The z13 is the ideal private or hybrid cloud architecture, legendary for its ability to scale and reliably and securely handle multiple workloads. In a scale-out model, it is capable of running up to 8,000 virtual servers -- more than 50 virtual servers per core, helping to lower software, energy and facilities costs.
The z13 lowers the cost of running cloud. For compared environments, it is estimated that a z Systems cloud on a z13 will have a 32 percent lower total cost of ownership over three years than an x86 cloud and a 60 percent lower total cost of ownership over three years than a public cloud. [5] Additionally, the z13 is based on open standards, fully supporting Linux and OpenStack.

As part of today’s announcement, IBM will also unveil a preview of new z/OS software that delivers advanced analytic and data serving capabilities.  When available, this new operating system will expand the ability of z13 to process in-memory analytics and provide analysis on mobile transactions, helping clients to further extend mainframe enterprise applications to the mobile user.

This launch complements IBM's ongoing investments to help clients drive mobile innovation across the enterprise. IBM’s 6,000 mobile specialists have been at the forefront of mobile enterprise innovation. IBM has secured more than 4,300 patents in mobile, social and security, which have been incorporated into IBM MobileFirst solutions that enable enterprise clients to streamline and accelerate mobile adoption, helping enterprises embrace mobile from the ground up.
IBM Global Financing offerings for the new model z13 include customized Fair Market Value leases with payment deferrals for credit qualified customers that want to upgrade from older models to z13, convert an owned z system to leasing while upgrading, or acquire a net new z13.

More information on
For more information on z13 and the IBM z Systems portfolio, visit
For additional content and shareable assets visit Mainframe Insights

We can bring the analytics to the data

Analytics is all about getting more value out of our data. Given that almost 55% of world’s commercial transactions run through z Systems and upwards of 70% of all commercial data originates there, it’s easy to see why running transactional analytics within the same system makes sense.

It makes more sense than the cost and time spent moving data off-system, managing multiple copies, protecting data across the network and not knowing if insights are correct. Using z Systems' capabilities, tools and innovation to keep and manage our data on a single platform that supports the full analytics lifecycle, we slash storage costs, reduce complexity and focus on operational efficiency, improving sales and customer satisfaction.

In-transaction analytics = competitive advantage

An integrated transaction analysis program like z Systems merges the systems of record and systems of engagement, delivering right-time insights at the point of impact. We can instantly analyze 100% of our transactions for revenue boosts from cross-sells or up-sells—and by personalizing communication and offers, through engagement analytics, we can lift annual customer value up to 7.6% or more.

In-transaction fraud prevention helps keep our business safe while protecting our clients and their information. And we can reduce ETL costs by up to 10 million over four years by keeping our data on a single platform. We gain customer advantage and trust, save money and move at the speed of business. It’s all win.

Why Analyse just a fraction of our transactions?

The key pieces of insight are already trapped inside our data like needles in a haystack. But if we analyze only a small percentage of our business transactions, that potential value remains largely untapped, and we lose an extraordinary opportunity.

If we analyze more types of data together in context, we get greater insights, make better decisions and create more targeted messaging. Looking from the customer perspective, the more highly relevant and contextual offers we present to them, the more brand loyalty and business we build.

Integration improves our data literacy

Integration on z Systems helps our Big Data & Analytics solutions to work at optimal levels, giving us insight into our customers, markets, products, regulations, competitors, suppliers, employees and more. And with a flexible analytic structure, we can get more knowledgeable in finding, manipulating and interpreting data.

We know right now where everyone and everything is. All of which improves our decision-making and helps us create new revenue streams and build better business outcomes.

IBM z Systems analytics solutions
New! IBM InfoSphere z Systems Connector for Hadoop
Bring the power of Hadoop to IBM z Systems' legendary qualities of service.

IBM InfoSphere BigInsights for Linux on z Systems 
Put the power of Hadoop to use on the industry’s most reliable, scalable and available high performance platform.

IBM DB2 Analytics Accelerator 
Delivers extremely fast performance to data-intensive and complex DB2 queries for data warehousing, business intelligence, and analytic workloads.

IBM Signature Solution - Next Best Action on z Systems 
Know and serve each customer as a unique individual on a massive scale with this complete solution.

IBM Capacity Management Analytics
Transform how you manage your resources, ensuring that you are able to meet your business demands.

Enterprise Linux Server for Analytics
Gain insights into all aspects of your Linux-based business.

IBM z Analytics System 9700
An end-to-end z/OS environment for the rapid deployment of enterprise analytics across your enterprise.

IBM z Analytics System 9710
Integrate insights into your enterprise at an entry-level price.

IBM Cognos TM1
A complete planning, budgeting and analytic environment for critical company-wide financial performance activities.

For More Information:

systemz resources:

oracle odi link:

Monday, December 15, 2014

Oracle Data Integrator 12c New Offering

Oracle Data Integrator 12c

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.

It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can now be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

  • High-performance bulk data movement and data transformation
  • E-LT architecture for improved performance and lower TCO
  • Heterogeneous platform support for enterprise data integration
  • Knowledge modules for optimized developer productivity and extensibility
  • Service-oriented data integration and management for SOA environments

ELT is not ETL - Oracle Data Warehouse Solutions 

Installation and setup of Oracle Data Integrator (ODI) 12c on Windows with Weblogic 

Power Oracle BI Applications with Oracle Data Integration 

Data Driven Business

In today’s data-driven business landscape, organizations need to easily and cost-effectively manage an exponentially increasing amount of information being created both inside and outside the company. Governing and managing this vast influx of data is important to ensure it is securely stored and accessible both in the cloud and on premises. The new Oracle Enterprise Metadata Management 12c, part of the Oracle Data Integration portfolio, helps customers meet these challenges and leverage their data to improve IT productivity and performance, lower costs, and deliver tangible business results.

Insights from business data with oracle data integrator

New Features

- Oracle has expanded its Oracle Data Integration portfolio with the addition of Oracle Enterprise Metadata Management 12c, a comprehensive platform that helps reduce compliance risks and ensure the success of governance programs within organisations by providing much-needed business and data transparency.

- A key component of Oracle’s big data governance solution, Oracle Enterprise Metadata Management 12c together with Oracle Enterprise Data Quality, Oracle Big Data SQL, and Oracle Database security solutions enables organisations to manage and control all aspects of data stewardship, lifecycle management, data protection, auditing, security, and compliance.

- Oracle Enterprise Metadata Management 12c helps organisations govern all of their enterprise data, including structured and unstructured data, across Oracle and third-party data integration, database, and business analytics platforms.

- It also includes a powerful business glossary—a critical component for linking business-friendly terminology to the operational metadata that drives data flows across enterprise systems such as Apache Hadoop, ERP applications, data warehouses, and semistructured data used for big data discovery.

- With Oracle Enterprise Metadata Management 12c, customers can benefit from:

- Data lifecycle management. Oracle Enterprise Metadata Management 12c offers customers full access to track data and metadata lifecycles across the third-party and Oracle Data Integration and Oracle Business Analytics platforms. As a result, customers can now increase their security and audit measures to finer granularity from report to source, track lineage, and perform impact analysis.

- Harvesting and integrating third-party metadata. The new solution delivers transparency and analysis across third-party business intelligence, data integration, and database technologies. Customers are no longer bound to metadata analysis within their product stack and can apply metadata management across their full data management platform.

- Data governance, stewardship, and standardisation. Oracle Enterprise Metadata Management 12c fosters stewardship collaboration through feedback and comment review boards, multimedia attachments, annotations, and tagging. The solution also offers semantic lineage via a business glossary.

- Big data transparency. Combined with Oracle Data Integrator’s extensive support for big data standards, including Apache Sqoop, Apache Hive, Apache HBase, and JavaScript Object Notation (JSON), Oracle Enterprise Metadata Management 12c brings data transparency even in big data stores and reservoirs.

- Oracle Data Integration is part of Oracle Fusion Middleware, the leading digital business platform for the cloud.

Oracle Data Integrator

Supporting Quotes

“Data management is becoming increasingly complex and time-consuming for organisations, as data travels through a bewildering sequence of platforms and technologies in its lifecycle,” said Brad Adelberg, vice president of development at Oracle. “By providing the transparency into this data lifecycle, not just within Oracle but also across other widely used platforms, we’re helping customers easily and cost-effectively manage and govern their many streams of data. Furthermore, we’re enabling them to leverage their data, along with the latest technologies such as cloud, big data, and business analytics, to reduce risks and produce real business results.”

“A comprehensive enterprise data management strategy is paramount to an organisations ability to use its data to drive actionable results, whether that means improving operational efficiency, reducing costs, or improving governance,” said Carl Olofson, research vice president, application development and deployment at IDC. “With Oracle Enterprise Metadata Management 12c, Oracle becomes one of the few enterprise vendors that takes seriously the central role of metadata in managing systems.” 

Oracle GoldenGate12c for the Enterprise and the Cloud

Oracle Big Data:

Oracle ODI Webinars Series:

Accelerate your business with oracle data integration

Business Integration for the 21st Century

Oracle ODI Links:,P24_PREV_PAGE:7952,1!/Oracle-Data-Integrator-Training-6-Days/p/43090537

Wednesday, November 26, 2014

IBM WebSphere DataPower Gateway Appliances

Secure, integrate and optimize access across channels with purpose-built IBM DataPower Gateways

IBM® DataPower® Gateway is a purpose-built security and integration platform for mobile, cloud, application programming interface (API), web, service-oriented architecture (SOA) and B2B workloads. It enables you to rapidly expand the scope of valuable IT assets to new channels and use cases and reach customers, partners and employees. It helps quickly secure, integrate, control and optimize access to a range of workloads through a single, extensible, DMZ-ready gateway.

IBM DataPower Gateway is available in both physical and virtual form factors.

IBM DataPower Gateway offers:

  • Single multi-channel gateway platform to secure, integrate, control and optimize delivery of workloads across channels including mobile, API, web, SOA, B2B and cloud—plus integration with IBM MobileFirst and WebSphere® platforms.
  • Converged policy enforcement and advanced security that allows a single entry point to protect access and utilize consistent security policies across business channels and help reduce operating costs and improve security.
  • Rapid security-enhanced integration, control and acceleration to quickly and efficiently support business needs, while providing centralized control and reducing infrastructure complexity.
  • Configuration-driven policy creation and flexible user experience that helps reduce time to market and improve productivity and scale expertise.
  • Purpose-built, DMZ-ready and extensible platform that enables business agility, physical security, drop-in deployment and simplified management, lowering total cost of ownership.

Intro to IBM WebSphere DataPower Gateway Appliances 

V7 - Part 1

This 2- unit, web-based course provides a technical introduction to the IBM WebSphere DataPower Gateway Appliances family at the Version 7 firmware level. In this Part 1 of 2, you learn the details of the core members of the DataPower family. A sample message flow that illustrates some of the basic functions and uses of an appliance is presented. Other products that have a DataPower family relationship are briefly outlined.

IBM WebSphere DataPower Version 7.0.0 Knowledge Center:

WebSphere DataPower SOA Appliances web page:

IBM Redbooks (Search on DataPower):

IBM developerWorks (Search on DataPower):

Intro to IBM WebSphere DataPower Gateway Appliances 

V7 - Part 2

This 2- unit, web-based course provides a technical introduction to the IBM WebSphere DataPower Gateway Appliances family at the Version 7 firmware level. In this Part 2 of 2, you examine several of the typical uses cases in which the appliances are used.

IBM WebSphere DataPower Version 7.0.0 Knowledge Center:

WebSphere DataPower SOA Appliances web page:

IBM Redbooks (Search on DataPower):

IBM developerWorks (Search on DataPower):

IBM Data Gateway Appliances Overview:

IBM Global WebsShere Community webcast

More Information:

IBM WebSphere on youtube

Tuesday, November 25, 2014

SUSE Linux Enterprise Server 12 is here!

SUSE Linux Enterprise Server 12 for SAP Applications

SUSE® today announced the general availability of SUSE Linux Enterprise 12, the newest version of its reliable, scalable and secure platform for efficiently deploying and managing highly available enterprise-class IT services in physical, virtual or cloud infrastructure. New products based on SUSE Linux Enterprise 12 feature enhancements that more readily enable system uptime, improve operational efficiency and accelerate innovation. The foundation for all SUSE data center operating systems and extensions, SUSE Linux Enterprise meets the performance requirements of data centers with mixed IT environments, while reducing the risk of technological obsolescence and vendor lock-in.

With this release, SUSE also introduces an updated customer portal, SUSE Customer Center, to make it easier for customers to manage their subscriptions, access patches and updates, and communicate with SUSE customer support.

"Given their competitive cost pressures, IT organizations today have a hard time responding quickly to changing business needs and leveraging innovation," said Nils Brauckmann, president and general manager of SUSE. "SUSE Linux Enterprise 12 helps enterprises stay agile, reclaim budget and easily leverage future open source innovation, helping them compete more effectively now and in the future."

Al Gillen, program vice president for servers and system software at IDC, said, "The industry is seeing growing movement of mission-critical workloads to Linux, with that trend expected to continue well into the future. The modular design of SUSE Linux Enterprise 12, as well as other mission-critical features like full system rollback and live kernel patching, helps address some of the key reservations customers express, and should help accelerate the adoption of Linux in this market segment."

New operating systems and software extensions based on SUSE Linux Enterprise 12 include:

• SUSE Linux Enterprise Server for x86_64, IBM Power Systems and IBM System z—versatile server operating systems for delivering business-critical IT services in a variety of physical, virtual and cloud environments. New features like full system rollback, live kernel patching enablement and software modules increase data center uptime, improve operational efficiency and accelerate the adoption of open source innovation. SUSE Linux Enterprise Server 12 further builds on SUSE's leadership with Linux Containers technology and adds the Docker framework, which is now included as an integral part of the operating system.

• SUSE Linux Enterprise Server takes advantage of IBM POWER8 processor-based hardware optimizations that include support for little-endian Linux applications running on simultaneous multithreaded (SMT8) and PowerKVM environments. SUSE Linux Enterprise Server for System z improves workload performance through instruction set exploitation for the last two generations of IBM System z processors, state-of-the art support for cryptographic accelerators and the related software stack, and enhancements for operational tasks like faster DASD formatting with dasdfmt or multiple point-to-point NETIUCV interfaces between Linux on System z and z/VM instances.

• SUSE Linux Enterprise High Availability Extension and Geo Clustering for SUSE Linux Enterprise High Availability Extension—clustering software for increasing services availability, physical and virtual, local and global. A new web console, updated OCFS2 and GFS2 file system support, and the latest updates in ReaR for disaster recovery make protecting core business systems quick and easy.

• SUSE Linux Enterprise Virtual Machine Driver Pack—for boosting Windows virtual machine performance on Linux hosts. It now supports a wider variety of Windows operating systems, such as Windows Server 2012 R2 and Windows 8.1.

• SUSE Linux Enterprise Desktop and SUSE Linux Enterprise Workstation Extension—for improving productivity while lowering costs and increasing security. Users can turn servers into full-featured development or administrator workstation environments.

SAP HANA Sp8.2 installed on SLES 12 SUSE Enterprise 12 with Fully Patch

SUSE History

On September 2, 1992, four twenty-somethings from Nuremberg, Germany—Roland Dyroff, Thomas Fehr, Burchard Steinbild, and Hubert Mantel—formed the Gesellschaft für Software und System Entwicklung GmbH. Literally translated as "Company for Software and Systems Development," the company has always been known as SUSE.

They may not have realized it at the time, but these young men changed the face of Linux forever. When their first planned distribution lacked a good installation and configuration tool, YaST (Yet another Setup Tool) was developed. Popular for its easy use, attractive graphical interface and the capability to customize your systems quickly during and after the installation, YaST took the Linux enterprise community by storm. And this was just the beginning.

SUSE's technical expertise and customer focus always stood out from other Linux distributions. IBM took notice and increasingly cooperated with SUSE in development work for their high-end platforms. Built on top of the open source Linux kernel and distributed with system and application software from other open source projects, SUSE was one of the first to deliver the value of open source to the enterprise.

In 2004 Novell bought SUSE and expanded community contributions further by sponsoring the openSUSE project and openSUSE Build Service. They made major contributions to the Linux kernel as well as Xen, KVM,, GNOME and KDE. SUSE continues to innovate and serve the business needs of its partners and customers worldwide with the best Linux distribution on the market.

See marketing artifacts from SUSE throughout the years.

In 2012, SUSE announced its 20 year anniversary. Check out SUSE's major historical milestones.

On November 20, 2014 SUSE became part of Micro Focus International.

SAP HANA Webinar | HANA Online Seminar Video | SAP HANA Video

More information:

Thursday, October 30, 2014

Oracle Zero Data Loss Recovery Appliance

Today’s solutions for protecting business data fail to meet the needs of mission critical enterprise databases. They lose up to a day of business data on every restore, place a heavy load on production servers during backup, fail to ensure database level recoverability, and cannot scale to meet the needs of ever expanding databases. Fundamentally they treat databases as a set of disjoint files to copy, not as transactional systems with specific integrity and performance requirements.
Oracle’s Zero Data Loss Recovery Appliance is a ground-breaking data protection solution that tightly integrates with the Oracle Database in order to address these requirements head-on. It eliminates data loss exposure and dramatically reduces data protection overhead on production servers. In addition, the Recovery Appliance scales to protect thousands of databases, ensures end-to-end data validation, and implements full lifecycle protection including disk backup, tape backup, and remote replication.

Today’s Database Data Protection Problems

The fundamental problems with today’s database protection solutions stem from:
  • Backup and recovery methods that are based on decades-old nightly backups paradigm, where up to a day’s worth of data can be lost on every restore
  • High backup overhead on production servers and networks for processing all database data during backups, whether it has changed or not
  • Ever-increasing backup windows due to non-stop data growth
  • Backup appliances that cannot scale to protect the hundreds to thousands ofdatabases in the data center
  • Poor visibility and control of the full data protection lifecycle, from disk to tape to replication 

Introducing Zero Data Loss Recovery Appliance

The Oracle Zero Data Loss Recovery Appliance is the world's first engineered system designed specifically for database protection. The Recovery Appliance delivers continuous protection for critical databases while offloading all backup processing from production servers to minimize overhead.
The Zero Data Loss Recovery Appliance is massively scalable, allowing a single appliance to handle the data protection requirements of thousands of databases.
Oracle’s Zero Data Loss Recovery Appliance tightly integrates with new Recovery Appliance specific capabilities in the Oracle Database and the Recovery Manager (RMAN) backup tool to provide data protection capabilities and performance that are not possible with any other data protection solution.

Eliminate Data Loss

The principal design goal for the Recovery Appliance is to eliminate the loss of critical database data that is still possible using existing data protection solutions.
Real-time Redo Transport
Redo logging is the fundamental means of implementing transactional changes within the Oracle database. All Oracle 11g or later databases can now continuously send redo directly from in-memory log buffers to the Recovery Appliance. This provides unique real-time data protection that allows databases to be protected until the last sub-second. Since redo is sent from database shared memory, the overhead on the production systems is extremely low.
Real-Time Redo Transport was first implemented for Oracle’s Data Guard technology and has been deployed in thousands of mission-critical databases around the world. The Recovery Appliance extends this technology beyond the top tier of databases in a simple and cost-effective manner. The Recovery Appliance provides similar levels of data protection as in Data Guard today, for databases that do not necessarily require Data Guard’s fast failover and query offload capabilities.
Secure Replication
Backups on a local Recovery Appliance can be easily and quickly replicated via secure transport to a remote Recovery Appliance for protection against disasters such as site outages or regional disasters. The replication topology can be tailored to match the data center’s requirements. For example, replication can be set up in a simple one-way topology, or two Recovery Appliances can be set up to replicate to each other, or several satellite Recovery Appliances can be set up to replicate to a central Recovery Appliance. In all topologies, only changed blocks are replicated to minimize WAN network usage. 
If the local Recovery Appliance is not available, restore operations can run directly from the remote Recovery Appliance without staging the data locally.

Autonomous Tape Archival
Tape offers a very low cost solution for long-term data retention and archival. It also provides low-cost unalterable protection from intentional attacks by hackers or employees, production software/hardware malfunctions, and accidental data deletion. However, the requirement for periodic full backups to tape imposes high overhead on production systems.
The Recovery Appliance automates and offloads full and incremental backups to tape, completely eliminating the impact of tape backup on production database systems. 16Gb Fibre Channel Adapters can be optionally added to the Recovery Appliance to send data directly from the Recovery Appliance to tape libraries, using the included and highly integrated Oracle Secure Backup media management software.
Tape archival offload is a significant Recovery Appliance differentiator compared to today’s backup solutions. It allows businesses to continue to use their existing tape libraries while eliminating tape backup overhead on production systems. Expensive media manager database backup agents are no longer needed on production servers. Because all tape activity is offloaded to the Recovery Appliance, tape drives can now run all day without slowing production systems, which enables better utilization of tape drives and lower costs.
All tape hardware products supported by Oracle Secure Backup, including Oracle’s StorageTek Tape, are supported by the Recovery Appliance. Alternatively, other vendors’ tape backup agents may be deployed on the Recovery Appliance for integration with existing tape backup software, media servers, and processes.

Recovery Reassurance: End-to-End Data Validation
The Recovery Appliance understands internal Oracle database block formats, which enables deep levels of data validation. All backup data and redo blocks are automatically validated as they are received by the Recovery Appliance, as they are copied to tape, and as they are replicated. In addition, backup blocks are also periodically validated on disk. This ensures that recovery operations will always restore valid data – another unique differentiator that is only possible because of the Recovery Appliance’s deep database integration. If a corruption is discovered during validation, the Recovery Appliance’s underlying storage software automatically reads the good block from a mirrored copy and immediately repairs the corrupted block.
In addition, the Recovery Appliance storage software performs periodic inspections of the underlying hard disks. If bad sectors are detected, they are immediately repaired from a mirrored copy.

Minimal Impact Backups

Despite the requirement for 24x7 operations, many businesses still need to reserve multi-hour backup windows during which production jobs are minimized. Backup windows provide no immediate business benefit, but instead compete with business critical reporting and batch workloads for off-hours processing time. In an increasingly global economy, backup windows continue to shrink, while data volumes grow. 
Impact of Current Disk-Based Data Protection Solutions
Current disk-based data protection solutions impose large loads on production systems. This impact continuously increases as databases grow. Some key challenges are:
  • Most deduplication appliances require periodic full backups. Full backups read the entire database which creates a heavy impact on production storage, servers, and networks. 
  • Somededuplicatingappliancesperformsource-sidededuplicationonproduction systems to reduce network requirements. This imposes high CPU and memory loads on production servers. 
  • Incrementalbackupsarerelativelyfast,butapplyingtheincrementalbackupto restored data files during recovery is very expensive, especially as this operation usually runs across the network.
Minimal Impact Backups
The second key design goal for the Recovery Appliance is to reduce backup related processing on production database systems to the absolute minimum – transmitting only the changed data. With unnecessary backup processing eliminated, production systems can now focus on their primary goal - serving business critical workloads.
The Recovery Appliance implements an incremental-forever backup architecture to minimize impact on production systems. This architecture is based on two innovative technologies: Delta Push and Delta Store.

Delta Push

With Delta Push, protected databases only send incremental backups containing unique changes to the Recovery Appliance. There is no need for recurring full backups. Delta Push is also known as “incremental forever” because, after a one-time full backup, only incremental backups are run on production systems. Effectively, Delta Push is a highly optimized form of source-side deduplication. Changed blocks on production databases are very efficiently identified using RMAN block change tracking which eliminates the need to read unchanged data.
Special integration between protected databases and the Recovery Appliance eliminates committed undo, unused, and dropped tablespace blocks from the backup stream, significantly reducing overhead and space consumption.
Because Delta Push sends only changed data and not full backups, network traffic is greatly reduced compared to other solutions. This enables low-cost 10 Gig Ethernet to be used for backups. Expensive dedicated Fibre Channel or Fibre Channel over Ethernet backup networks are not needed. Also, minimizing network traffic allows the Recovery Appliance to be located further away from the protected databases, and even in some cases, across a WAN in a remote data center.

Delta Store

Delta Store represents the “brains” of the Recovery Appliance software engine. Delta Store validates the incoming changed data blocks, and then compresses, indexes and stores them. These changed blocks are the foundation of Virtual Full Database Backups, which are space-efficient pointer-based representations of physical full backups as of the point-in-time of an incremental backup. Virtual full backups can improve storage efficiency by 10 times or more depending on the data set and change rate of the protected database.

The space efficiency of the Delta Store architecture enables a large number of Virtual Full Backups to be kept online, greatly extending the disk based recovery window.
When a restore operation is required, Delta Store efficiently recreates a physical full backup based on the closest incremental backup time. The restore operation is supported by the massive scalability and performance of the underlying hardware architecture of the Recovery Appliance. Restoring from a Recovery Appliance eliminates the slow traditional process of restoring a full backup and then sequentially restoring and applying all relevant incremental backups.

Zero Data Loss Recovery Appliance: Technical Overview   

Most Backup Operations Offloaded

Practically all backup-related processing is offloaded to the Recovery Appliance. This includes time-consuming compression, backup deletion, validation, and maintenance operations. This frees production system resources, even outside the backup window, which increases the performance of the production systems.

To summarize, with Real-time Redo Transport and Delta Push, protected databases do the minimum possible backup-related work – transmitting only the changed data to the Recovery Appliance. All other backup and recovery related processing, including tape backup, is handled by the Recovery Appliance. This is one of the core architectural innovations of the Recovery Appliance, above and beyond today’s backup solutions.

IBM Videos