Create Backup Set

Backup Requirements

Please ensure that the following requirements are met by the Oracle database server:

  1. The Oracle databases selected for backup will be temporarily spooled to a temp directory before being uploaded to the backup server.
    It is recommended that the temporary directory have disk space of at least 120% of the total database size (e.g. total size of all database files).
  2. All database selected for backup, must be in ARCHIVELOG mode.
    ARCHIVELOG mode guarantees complete data recoverability, and must be enabled to perform online backups.

    To enable ARCHIVELOG mode, please refer to the following instruction:


  3. Grant JAVASYSPRIV to the system account.
    SQL> grant javasyspriv to system;
  4. Archived logs are not deleted automatically after an Oracle database backup. On the next backup job, the script file "UpdateOracleRmanRecords.bat" in CloudBacko_HOME\bin will be executed to remove these archived logs. To grant the privilege for the script to run. Please do the following.

    Assume the path "D:\oracle\product\10.2.0\db_1\bin" is the path for the Oracle binaries.

    D:
    cd \oracle\product\10.2.0\db_1\bin
    sqlplus "/ as sysdba"
    SQL> grant sysdba to system;
    SQL> quit
    set ORACLE_HOME=D:\oracle\product\10.2.0\db_1

    ?

    Please also restart your scheduler to ensure the CloudBacko™ scheduler is running with the above ORACLE_HOME. Warning messages may be shown in the backup report if the CloudBacko™ scheduler starts before the above ORACLE_HOME statement when machine reboots.



Set the name of the backup set

Name This is the name of the backup set. You can create a meaningful name for it.
Backup Type Enter the correct backup type from the drop down box.
Login ID This is the login ID. Default using system login.
Password This is the password for the system login.
Host This is the host of the Oracle server. Default using localhost.
Port This is the listening port of the Oracle server. Default is 1521.
SID This the Oracle SID.

To create a backup set name:

  1. Type in a meaningful backup set name.
  2. Enter correct backup type, eg: Oracle Database Backup.
  3. Enter the Login ID.
  4. Enter the password.
  5. Enter the host.
  6. Enter the port.
  7. Enter the SID.
  8. Click [Next] button to continue.
  9. Note: Click [Next] button again to start the verifying process