Hands-free offsite backup of your company’s database; encrypted data transfer for maximum security. The Oracle server backup feature allows you to backup your Oracle server databases to your IDrive account, without interrupting the running Oracle server services.
Following are the prerequisites for Oracle server backup:
To enable ARCHIVELOG Mode using Oracle Recovery Manager (RMAN), follow the steps given below:
Note: Ensure that the Oracle server user who has logged in has SYSDBA privileges. To grant the SYSDBA privileges to the user use the following command: SQL>grant sysdba to <user>
Note:
(a) Ensure that the selected temporary directory on the local computer has sufficient disk space to hold the Oracle server backup resources.
(b) 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.
(c) Once local backup is initiated, '.ServerBackup' folder is auto created.
Note: For easy identification of the Oracle server backup set, the name of the backup set will begin with 'IDOracleServerBkset' 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 'IDOracleServerBkset (JOHN_DB)'.
You can consult your Oracle DBA for details on the configuration parameters.