Getting Started with Oracle

The following high-level process helps to set up your CommCell Console environment and to run your first Oracle backup and restore.

To perform your first backup and restore of Oracle data:

  1. Install the CommServe and MediaAgent.
  2. Install the Oracle Agent on Windows or UNIX.
  3. Open the CommCell Console.
  4. Configure a Storage Device.
  5. Plan your backup by considering the following configuration items.
    Consideration More Information
    Decide what data to back up. Oracle database backups contain one or more of the following:
    • Only the entire database
    • Only archive logs
    • The Oracle control file
    • The Oracle SP file
    • Individual datafiles and tablespaces
    • The Oracle Flash Recovery Area

    Create subclients for each unique data set.

    Subclients for Oracle
    Decide whether to schedule backups. Scheduling backups has the advantage of ensuring data is automatically backed up at regular intervals. Use a schedule to regularly backup the Oracle Flash Recovery Area. Gather the following information prior to configuring schedules:
    • The schedule name
    • The schedule frequency
    • The schedule start time and start date
    • The schedule exceptions

    Create schedules for the backups.

    Scheduling
    Decide whether to encrypt the data for transmission over non-secure networks or storage media. Gather the following information prior to configuring encryption:
    • The encryption type
    • The encryption level (client, instance, subclient)

    Configure the encryption.

    Data Encryption
  6. Configure instances for the Oracle databases. Do this by manually discovering all existing Oracle databases, or by enabling Automatic Instance Discovery.
  7. Configure an online backup subclient.
  8. Perform an online full backup.
  9. Perform an initial restore.
  10. Optional: You must complete the following tasks when you run reports against the Oracle database.
    1. Configure the Oracle database as an external data source when you want to run reports against the Oracle database. For more information, see Configuring External Data Sources.
    2. You can create a report to view Oracle tablespace details. For more information, see Creating a Report to View Data from Oracle Tablespaces.
  11. Optional: If database administrators are performing backups, you must also complete the following tasks for each administrator:
    1. Configure a CommCell Console User for each database administrator.

      Note: This user must be an Oracle user that has access to the Oracle executable and binary files.

    2. Configure the User Group Permissions for each CommCell Console Oracle database administrator.
    3. Configure a Storage Policy for backups.
    4. Pass the following information to the Database Administrator:
      • The CommCell Console user name and password for the database administrator
      • The storage policy name
  12. To plan for recovery of critical data and business functions in the event of a disaster, review Full System Recovery: Oracle Agent.