5 Myths of Oracle Database Backup
Oracle Database is one of the most popular business database servers. In fact, it topped the database popularity charts for few years in a row, according to DB-Engines.com. Millions of companies store their most critical data – ERP, CRM, finance databases – in Oracle Database servers and systems. Given the importance of these systems, it’s no wonder there are a lot of opinions and myths about protecting Oracle Databases, and here are the top five:
1. RMAN is the only way to back up Oracle DB
Oracle Database “purists” will insist that only the vendor’s tool can properly and reliably back up the database. While RMAN (Recovery Manager) is undoubtedly a reliable and proven option, it is not the only way. Backup software vendors, including Acronis, worked for years to ensure that the most popular database can be protected by centralized company-wide backup solutions. In addition, Oracle Database supports multiple operating system frameworks, like Microsoft VSS (Volume Shadow Copy Service), ensuring that system-wide disk snapshots contain consistent state of the database.
For example, in Windows, Microsoft VSS sends a freeze signal to the database engine (version 10g and above), which in turn, saves all the pending transactions and report that data is frozen. Backup software like Acronis Backup Advanced, integrated with VSS, takes disk snapshot in less than a second, and immediately thaws the database via the same framework. There is no connection breaking or denial of service, and the process is transparent to users and applications.
2. RMAN is the wrong way to back up Oracle DB
The opposite camp of backup administrators insists that RMAN is a very limited tool, and should not be used in production. They argue that most backup tools provided by vendors are extremely limited, complex, and slow – basing their assertion on the example of built-in backups in Windows, Linux, and popular applications.
However, sometimes RMAN is the only proper way to back up a database. For example, if you use raw partitions or ASM, only the latest update of RMAN will ensure that your database is properly backed up. Even if your backup software claims supporting raw partitions or ASM out of the box, one small update of the database engine can introduce optimizations that can break third-party backup software.
3. Backup of Database data is enough
This very common misconception stems from the fact that the data in a database may be 1,000 times more valuable than the server itself. You can install a new operating system and a database engine, but the lost data cannot be recovered without backup.
However, the biggest mistake here is the failure to consider the time associated with recovery and the cost of downtime. The time spent to reinstall and reconfigure the system will cost the business a lot of money — $8,851 per minute on average, according to Emerson Network Power study.
You have to back up your database data, and you have to back up your database server software – including the server’s operating system and configuration — best done with a disk-imaging backup solution, like Acronis Backup Advanced. This will allow you to restore the entire server quickly within a fraction of a time the manual reinstallation takes.
4. Restoring single tables/partitions/items is easy and safe
Many backup solution vendors are touting the ability of granular recovery as an easy and safe feature. However, there is a reason there is an “R” in the “RDBMS” acronym for your Oracle DB. It’s stands for “Relational”.
Say, for example, your ERP database has the CUSTOMER table with customer data, and another ORDER table with order data. If you restore a week-old CUSTOMER table, but keep the ORDER table as-is, you will have orders referring to customers missing from the CUSTOMER table, creating all sorts of havoc due to table inconsistency. Restoring a single table also can cause issues with indices, views, and other mechanisms in the database.
Unless you are sure what you are doing, dedicate some time and restore the entire database whenever possible.
5. Oracle DB server can be only restored to the same hardware
I remember few years ago trained DBAs telling me that I cannot backup an Oracle Database on an HP server and restore to an IBM server.
I did it successfully with Acronis Backup Advanced – backing up the entire server with the help of Microsoft VSS, and restoring it to dissimilar hardware with Acronis Universal Restore. After rigorous tests, the DBAs conceded that it works perfectly.
Interestingly enough, this myth is linked to the incorrect belief that Oracle Database cannot run on virtual machines. In fact, Oracle Database engine works perfectly on VMs but with one caveat as described in the Oracle support policy that states, “Oracle has not certified any of its products on VMware virtualized environments”. In short, if you have an issue, you may need to have it addressed by VMware support.
Alternatively, you can also choose to use Oracle VM Server virtualization instead of VMware – and you will have full support from a single vendor. Moreover, Acronis Backup Advanced for Oracle VM will help you to protect your virtual machines and databases.
Try it for yourself! Check out Acronis Backup Advanced today and experience the reliable and proven backup solution for your Oracle Database.