User Manual | Tutorial | Help | Instructions | How to
Backup Software / Support / User Manual v8 / Technologies / Plug-ins / Data Source and Storage / Oracle plug-in
Oracle Database is a database management system produced and marketed by Oracle Corporation. Oracle Database software have been translated into more than 60 languages.
The Oracle Backup plug-in allows protecting data stored and used by Oracle database, without stopping the service.
Before using Oracle plug-in you must configure the Oracle database engine first, and then add a specific user in a ORA_DBA group allowing him or her to run Oracle backup and restoration procedures. If you have already configured the plug-in, please refer to the next chapter.
In order to make "hot backups" without stopping an Oracle engine, it is necessary first to enable the ARCHIVELOG mode. If the database runs in the NOARCHIVELOG mode, then it will backed up in "cold" mode only (after stopping it).
To check which mode is active just now, use the following SQL operation:
SQL> select log_mode from sys.v$database;
If the value of LOG_MODE is NOARCHIVELOG, then you need to change it applying the following query:
SQL> alter database archivelog;
Note: To change the mode, your Oracle database instance must be mounted but not open. If it is open, you need to shutdown it, startup it with the mount option, enable the ARCHIVELOG mode, and then open the database for normal use:
SQL> shutdown immediate;SQL> startup mount;SQL> alter database archivelog;SQL> alter database open;
If you use the Server Network edition of this software, it is possible to work with Oracle databases located on a workstation connected with the server via network. Follow these steps to set up this option properly:
Backups of local database can be created with any edition that has the Oracle plug-in available. The user account under which the program runs must have membership of the ORA_DBA group.
To add a user to the ORA_DBA group, you must perform these next operations:
After an Oracle engine has tuned properly, you can easily make backup or restoration tasks using Oracle databases as target data type.
To make a backup, do the following:
Ralated page: Oracle Backup Software
User Manual contents
Download User Manual V8
Copyright © 2004-2020 Novosoft LLC. All rights reserved. Handy Backup software.
10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top