Oracle Server Backup

Requirements for backup

Enabling ARCHIVELOG Mode

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

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;

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.

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

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.

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.

View the steps to restore the Oracle Server.