IBackup - online backup and online storage  

home Support

Signup Pricing plans Products Downloads Security Support Partners FAQ



Oracle Server Backup

The IBackup for Windows 'Oracle server Backup' wizard guides you through a simple step-by-step approach to backup your Oracle server databases to your IBackup account, without interrupting the running Oracle server services.

Note: To perform the Oracle server database backups, download the 'Advanced Backup Plug-in' after installing the 'IBackup for Windows' application.


General Features

  • Authentication of the Oracle server database for backup
  • Provision to backup Oracle server databases without interrupting the running Oracle server services
  • Provision to report the progress of backup jobs
  • Ability to schedule backups for a future date and time with various scheduling options
  • Easy-to-use wizards for scheduling the backup jobs
  • Provision to avail notifications (Email and Desktop) upon completion of scheduled backup jobs
  • Provision to generate log files for each backup session
  • Enhanced security with 128-bit SSL encryption on transfers, optional 256-bit proprietary encryption on storage with a user-defined encryption key that is not stored anywhere on IBackup servers
Resources
Download
Advanced Backup Plug-in
Oracle Server Restore

To view the steps to restore the Oracle server databases, click here.

Related Links

User manual (PDF)
Business Solutions
 

Requirements for backup
Following are the prerequisites for Oracle server backup:
  • Install the IBackup for Windows application on the computer where the Oracle 9i/10g server/client is available
  • Ensure that your computer (the selected temporary directory) has sufficient free disk space for Oracle 9i/10g database backup/restore
  • The database must be in ARCHIVELOG Mode
  • The Oracle server user should have SYSDBA privilege
  • Oracle Recovery Manager (RMAN) should be available on the computer where the IBackup for Windows application has been installed
Enabling ARCHIVELOG Mode
To enable ARCHIVELOG Mode using Oracle Recovery Manager (RMAN), follow the steps given below:
  • RMAN> connect target <username>/<PWD>@<SID> [connect to your Oracle database];
  • RMAN> shutdown immediate;
  • RMAN> startup mount;
  • RMAN> sql 'alter database archivelog';
  • RMAN> alter database open;

 

To backup the Oracle server database, follow the steps listed below:

Step 1

 From the application menu, go to Backup-Restore > Oracle Server > Oracle Server Backup.
Or
From the application Tool bar, go to Wizards > Advanced Backup > Oracle Server > Oracle Server Backup.

Oracle Server Backup

Step 2

Enter the authentication information and log on to the Oracle server database.

Oracle Server Backup

Note: Ensure that the Oracle server user who has logged in has the SYSDBA privileges.

To grant the SYSDBA privileges to the user:
SQL>grant sysdba to <user>

Step 3

 Select the temporary location on your computer using the 'Browse' button.

Oracle Server Backup

Note: Ensure that the selected temporary directory on the local computer has sufficient disk space to hold the Oracle server backup resources. Also, select the temporary location on the computer where the Oracle server service is running.

If you are performing a remote/network Oracle server backup, then select the temporary location on the server where the Oracle server service is running.

Step 4

Click the 'Next' button and select the folder on your IBackup account.



Step 5

Click the 'Next' button and schedule the backup for a future date and time.



Note: For easy identification of the Oracle server backupset, the name of the Backup set will begin with 'IBORACLEBkSet' followed by the Database SID (Database System Identifier) name that you have scheduled for backup.

For example: If the Database SID name is 'JOHN,' then the name of the backup job would be 'IBORACLEBkSet (JOHN_DB)'.

Consult your Oracle DBA for details on the configuration parameters.