SAP for Oracle Best Practices

Updated

Running on UNIX Environments

If you run more than one database application on the same UNIX client, perform the following administration on the client before you install the Oracle Agent:

  • Create a new user group for the databases.

  • Add the users and owners of each database application to the user group you created.

Creating Subclients

  • Leave the default subclient contents intact to act as the catch-all entity for data.

  • Create separate subclients for data that needs frequently changes and needs a unique backup schedule.

  • Create separate subclients for data and log backups.

  • Use the above recommendations to distribute the data across subclients, which can help improve performance by distributing the workload.

Performing Command Line Operations

  • Verify the availability of the required resources before you run command line scripts to ensure the resources are online and not reserved by another backup or recovery process.

  • Use separate scripts for data and logs, because only one data type can be passed through the argument file. This system uses the data type to mark the archive files created by the backups as DATA or LOG in the CommServe database. If you have scripts containing both data and logs, the archive files are marked as either DATA or LOG, depending on the data type that is defined in the argument file.

Scheduling Log Backups

Use the archive log subclient that the Commvault software creates by default, to run archive logs backup. Take the following into consideration when planning your log backup schedule:

  • The number of transactions that the database generates

  • The disk size for the log file destination

After you have that information, configure an automatic schedule to back up the logs before the archive log destination fills up to 80% of the space (Backup Task Options dialog box, Schedule Pattern tab, Start backup when disk at log destination is box). For information on how to configure an automatic schedule, see Creating an Automatic Schedule for Database Log Backups.