AWR Generating & Setting

Oracle database is gathering statistics periodically (snapshots), these statistics can be used for analyzing database performance. These statistics are kept in the Automatic Workload Repository (AWR).

read more »
Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations

Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations

The recommended Oracle® Data Guard configuration is in Maximum Availability mode, when using Oracle Far Sync, which is located near the primary site: Primary Database > Far Sync Instance – Network input/output (I/O) is synchronous (Sync). Far Sync Instance > Standby Database – Network I/O is asynchronous (Async). Primary Database > Standby Database  – As an alternate (when Far Sync is not reachable), network I/O is asynchronous (Async).

read more »
Oracle 12c Release 2 New Features for Active Data Guard

Oracle 12c Release 2 New Features for Active Data Guard

At Oracle Open World 2016 I collected the main improvements and changes are going to be implemented in Oracle Database 12 Release 2: Data Guard Creation with dbca, supports automatic creation of Standby database and Far Sync instance not for RAC (at this point) with the command: dbca -silent -createDuplicateDB     -PrimartDBConnectionString myprymary.domin:1523/chicago.domain     -gdbName chicago.domain -sid boston     -initParams instance_name=boston -createAsStandby     -customScripts /tmp/test.sql Multi-Instance Redo Apply, Parallel, multi-instance recovery – when standby is RAC, all its instances will use the MRP0 process for applying Supports Diagnostic Pack on Active Data Guard AWR+ADDM Reports for Standby are kept in the Primary Supports Tuning Pack and SQL Plan Analyzer Fast Failover – Data Guard take over session draining (switchover to dallas_dr wait;) Read-only sessions connected to Active Data Guard Remain connected during the failover / switchover Become Read/Write after Active Data Guard becomes the primary Password file is managed and transported via the Redo mechanism Alternate prioritization – you will be able to group some destinations and give them a priority over some other destinations. This enables you to decide what will happen when the main destination is back (failback) Support In-Memory Column Store – redo data contains all the information needed for the standby to benefit from the In-Memory Column Store feature. Yossi Nixon Chief Database Architect  

read more »
Disaster Recovery Using Cellular Networks – Are These Six Misconceptions Keeping You from Zero Data Loss and Near-Zero RTO?

Disaster Recovery Using Cellular Networks – Are These Six Misconceptions Keeping You from Zero Data Loss and Near-Zero RTO?

Although disaster scenarios may be carefully addressed in the DRP, meeting the overall recovery time objective (RTO)—especially in asynchronous replication environments—is much less assured. This uncertainty is mainly due to data loss. When you enter the realm of data loss, figuring out what you have lost and then trying to reconcile the data can slow data recovery time to a crawl. Even seconds of data loss can entail hours of downtime as you work to recover data—costing your organization dearly in terms of lost revenue, reputation damage, labor costs, and much more.

read more »
Protect Your Company’s Most Critical Data – Without Breaking into a Sweat

Protect Your Company’s Most Critical Data – Without Breaking into a Sweat

You know the story:  99% (usually less) of your data is protected, and you got management to waive 100% protection by using the old “it’s just impossible” or “it’s too expensive” excuse. Even so, you never want to be the one who bears the news, “Sorry, we lost data, and it can’t be recovered…and by the way, it wasn’t just any 1% of data; it was the data that is most critical to our business.” Once disaster strikes, no one remembers those management waivers. They remember names. And guess whose name will be at the top of the list…

read more »
Disaster Recovery – From Practice to Theory?

Disaster Recovery – From Practice to Theory?

I was recently invited to give a talk at a Research institution about the products we are developing in Axxana. This forced me to step back and look at Disaster Recovery from a more “rigorous” point of view. Here are some key observations. First, let me start with a disclaimer. Our initial focus is on transactional environments where data loss translates very directly into lost revenue, reputation damage and in some extreme cases could lead to business closure. We do not focus on large scale systems that provide “eventual consistency,” but on classical environments that have focused on strong consistency models.

read more »
Using Flash-Based Storage Without Compromising Transactions (or Performance)

Using Flash-Based Storage Without Compromising Transactions (or Performance)

Everyone wants fast write access, high performance, a smaller footprint, green IT solutions, and the lowest possible total cost of ownership (TCO). For these reasons, many organizations use solid state drives (SSDs) or other forms of flash memory instead of the traditional hard disk drives (HDDs). Flash-based storage is designed to provide extremely high volumes of input/output (I/O) with very low latency. The typical use cases for flash-based storage are virtual desktop infrastructures (VDIs), which require high I/O speeds when booting up, and databases, which need fast read access.

read more »
Oracle White Paper Puts Axxana Phoenix System in the Spotlight

Oracle White Paper Puts Axxana Phoenix System in the Spotlight

Thanks to the Axxana Phoenix System and Oracle’s Far Sync technology, disaster recovery just got simpler, more reliable, and more affordable for Oracle customers. That’s the takeaway in a recent white paper by Oracle. The global technology leader is teaming with Axxana to offer a best-of-breed solution that combines Oracle Active Data Guard Far Sync with Axxana Phoenix System to ensure zero data loss in any data center topology.

read more »
The cost saving dilemma

The cost saving dilemma

Every IT team is looking for ways to cut costs. How can this be done without affecting the level of service to the business owners? In my previous blog, I discussed how enterprises are compromising between quick recovery time (minimal RTO) and Zero Data Loss (RPO=0). Which of the two is more critical to the business owners? There is no one correct answer and it was very challenging, until Axxana arrived on the scene, to maintain both. Organizations had to choose, based on the nature of the application, whether Zero Data Loss was more critical than potential down time when switching to the disaster recovery site after a serious failure at their main site. We already established the fact that with Axxana, there is no need to compromise anymore. Axxana’s Phoenix System for Oracle cuts down time to the absolute minimum, by maintaining full application consistency and lowering data reconciliation efforts to zero.

read more »