Oracle Backup Using Native Methods
Handy Backup / Features / Oracle Backup Using Native Methods
As Oracle database engines of all versions include latest 11g and 12c becomes more and more essential in all areas of expertise, so it does methods of backup and restoration of Oracle data. Anytime a need to tell Oracle backup schema or a single database using native methods can emerge. So let us view on some instruments capable to perform this task.
These are two main programs designed to perform backup and restorations of Oracle schemas or data.
Data Pump Export (expdp) implements for a logical data backup from selected tables. To be restored properly some time later, this export operations must be performed in internal consistent mode with a strong check of data integrity ensured. Otherwise the database cannot be recovered. In a modern days, using of this utility may be performed almost exclusively in conjunction with a more powerful and capable RMAN.
The short list of expdp merits and flaws:
Recovery manager (RMAN) is based on Extensive Backup Utility (EBU) developed earlier, and seriously increasing the capabilities of EBU including possibilities such as writing an Oracle backup script or scheduling a restoration task, for examples. It is a command-line backup client with no GUI. RMAN backs up Oracle databases with automatic consistency and full range of features typical for this class of software.
RMAN uses its own glossary of terms and definitions not common to backup matters in other IT world. This fact can discourage unskilled users, but all these terms are readily available and explained both in the Internet and in RMAN manuals.
RMAN capabilities and disadvantages can be characterized summarily by the following list:
Version 7.5.2, built on August 20, 2014. 22.5 MB, 32-bit (above) or 28.8 MB, 64-bit versionBackup Software from Novosoft LLC. 199 USD per license.
To back up and restore your Oracle databases, you need to use the Small Server edition. Free 30-days trial version!
As some advantages takes RMAN significantly over expdp utility, almost everything Oracle backup command set or strategy eventually uses RMAN. It is true for, say, third-party Oracle backup software.
It is completely possible to use third-party software designed as an interface or a bridge between RMAN and user. Such programs can provide user with intuitive GUI and set some Oracle backup script operations into an overall strategy of data-keeping along with other types of data.
Loading comments, please wait...
+1 (707) 703-13-11
Upgrade to version 7
See all volume order prices
2014/09/01 - Release of Version 7.5.2: Improved E-mail Notifications and Independent Yandex.Disk Data Storage
2014/07/17 - Release of Version 7.5.1: Cleared User Interface, Revised MS SQL and MySQL Functionality, New Speed of WebDAV
MySQL Backup - read how Handy Backup can help you to back up MySQL databases
MS SQL Backup - learn about backing up Microsoft SQL Server data
PostgreSQL Backup - check out how to perform PostgreSQL backup and recovery
Database Backup - protect your databases with different plug-ins available in our software
Oracle RMAN - software performing all backing up and restoring operations of Oracle databases
Copyright © 2004-2014 Novosoft LLC. All rights reserved. Handy Backup software.
Back to Top