Loading...

Advanced Backup - FlexFrame for Oracle

Table of Contents

Full Backups

Incremental Backups

Archive Log Backups

Control File Backups

On-Demand Backups

Incrementally Updated Backups

Running RMAN Scripts from Application Command Line

Previewing RMAN Scripts from CommCell Console

Customizing RMAN Scripts from CommCell Console

Updating the Customized RMAN Script

Validating Backups for Restore

Disabling RMAN Warnings from RMAN Output

Managing Jobs

Full Backups

You can use this procedure to back up the entire database and the control file. Backups of online databases also include the log file.

Tip: After you install the Oracle Agent, perform a full back to verify the configuration.

A full backup is the most comprehensive backup and is the baseline for incremental backups.

  1. From the CommCell Browser, expand Client Computers > client> Oracle >instance.
  2. Right-click the subclient and click Backup.
  3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:
    1. In the Backup Type section, select Full.
    2. If you selected the Cumulative check box, specify the backup incremental level in the Oracle Incremental Level box.
    3. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

  4. Optional: Uniquely identify a backup.
    1. Click Advanced.

      The Advanced Backup Options dialog box appears.

    2. On the Oracle Options tab, in the Backup Tag box, enter a unique tag.

      You can include variables in the tag. For supported tag variables, see Oracle Tag Variables.

    3. Click OK to close the Advanced Backup Options dialog box.
  5. Optional: Set the backup load distribution across disks to improve performance. For more information, see Configuring the Disk Ratio for Oracle RMAN.
  6. Optional: View or customize the RMAN script that is generated from the selected options. For instructions, see Viewing Oracle Backup RMAN Scripts and Customizing Oracle Backup RMAN Scripts.
  7. Click OK to close the Backup Options dialog box.

Incremental Backups

You can perform an incremental backup when the Oracle database is online or offline.

For more information on incremental backups, see Incremental Backups.

  1. From the CommCell Browser, expand Client Computers> client> Oracle >instance.
  2. Right-click the subclient, and then click Backup.
  3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:
    1. In the Backup Type section, choose the backup type.
    2. If you selected the Cumulative check box, specify the backup incremental level in the Oracle Incremental Level box.
    3. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

  4. Optional: Uniquely identify a backup.
    1. Click Advanced.
    2. On the Advanced Backup Options dialog box, click the Oracle Options tab, in the Backup Tag box enter a unique tag.

      You can include variables in the tag. For supported tag variables, see Oracle Tag Variables.

      The Oracle tag you that you specify for the backup overrides the tag defined for the subclient.

    3. Click OK to close the Advanced Backup Options dialog box.
  5. Click OK to close the Backup Options dialog box.

Archive Log Backups

Use log backups in the following scenarios.

  • To restore the database to the most recent state after a database failure.
  • To restore specific logs, which are identified using a serial number or identification tag that are missing in the database.
  • To restore logs from a specific time range that were lost due to a hard disk corruption. Use a point-in-time archive log restore.

The current redo log file is closed (even if it is not filled up completely) and the next redo log file is used for writing using a log switch during an archive log backup. The closed redo log file is then archived during the log phase.

You can specify database log only backups to start when the log files on the disk reach a specified percentage of the disk or the number of log files on the disk matches the specified number. For more information on automatic log backup schedule policies, see Creating an Automatic Schedule for Database Log Backups.

Before You Begin

Configure a subclient for Oracle Archive Log Backups.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > Oracle > instance.
  2. Right-click the subclient configured for the archive log backup and then click Backup.
  3. On the Backup Options for Subclient dialog box, select the backup type and initiation:
    1. In the Backup Type section, choose the backup type.
    2. If you selected the Cumulative check box, specify the backup incremental level in the Oracle Incremental Level box.
    3. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

    4. Click Advanced.

      The Advanced Backup Options dialog box appears.

  4. Select the option to determine the logs to back up and delete.

    On the Backup Archive Logs tab, and Delete Archive Logs tab:

    Choice

    Description

    All

    Backs up or deletes all logs

    Older than n Days

    Backs up or deletes logs older than the specified number of days

    Not Older than n Days

    Backs up or deletes logs not older than the specified number of days

    By Log Time

    Backs up or deletes logs in the specified time range.

    Select the Start Time and End Time check boxes and enter the start and end times of the logs.

    If you only specify the start log time, all logs are backed up from the start time to the current time.

    By Log Seq Num

    Backs up or deletes logs in a specified sequence range.

    The Log Sequence Number uniquely identifies an archive log. For example, if you create a database with two online log files, then the first file is assigned log sequence number1. When the first file fills, Oracle switches to the second file and assigns a log sequence number of 2.

    Select the Start Sequence Number and End Sequence Number check boxes and enter the beginning and ending sequence numbers

    By Sys change Num

    Backs up or deletes logs in the specified System Change Number range.

    The SCN is a stamp that defines a committed version of a database at a point in time. Oracle assigns every committed transaction a unique SCN. For example, SCNs of two successive committed transactions could be 576601 and 576799.

    Select the Start Sys chg Num and End Sys chg Num check boxes and enter the beginning and ending SCNs:

    The end serial number must be greater than or equal to the start serial number.

    The start and the end SCN cannot be 0.

    If you provide only the start SCN, is the only one provided, only the logs starting that start from that sequence number are backed up.

    Like

    Backs up or deletes logs with a file name that starts with a specified string.

    Enter the string to match.

    Not Backed up

    Backs up or deletes logs that have not been backed up a specified number of times.

    Enter the number of times a log must be backed up.

  5. On the Backup Archive Logs tab, specify the location where the backed up logs are stored:
    1. Select the ArchiveLog Destinations for Backup check box.
    2. Click Add.
    3. On the Select an Archive Log Destination dialog box enter the full path to the directory where backed up archive logs will be stored.
    4. Click OK to close the Select an Archive Log Destination dialog box.
  6. Click OK to close the Advanced Backup Options dialog box.
  7. Click OK to close the Backup Options dialog box.

Control File Backups

The control file contains metadata about the physical structure of the database including the location of all files, the current database state etc. Each control file is associated with only one database. The control file backups are used for creating standby databases from the CommCell Console. Standby databases are used during database recovery.

The subclients need to be configured prior to running control file backups; see Control File Subclients.

Use the following steps to backup the control file:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | Oracle | <Instance>.
  2. Right-click the<Subclient>configured for control file backup, and click Backup.
  3. Click Advanced.

    The Advanced Backup dialog box appears.

  4. On the Oracle Options tab, select the Backup Controlfile for Standby check box.
  5. Click OK.

On-Demand Backups

For information on Oracle On-Demand backups, see RMAN Example: Performing Oracle On-Demand Backups.

Incrementally Updated Backups

For information on Oracle merged incremental backups, see Merging Incremental Backups for Oracle or RMAN Example: Merging Oracle Incremental Backups.

Running RMAN Scripts from Application Command Line

For information on how to run RMAN command line backups, see Oracle Backup Examples Using the RMAN Command Line Interface

Previewing RMAN Scripts from CommCell Console

For information on how to view the CommCell Console RMAN scripts, see Viewing Oracle Backup RMAN Scripts.

Customizing RMAN Scripts from CommCell Console

For information on how to customize the CommCell Console RMAN scripts, see Customizing Oracle Backup RMAN Scripts.

Updating the Customized RMAN Script

For information on how to update the CommCell Console RMAN scripts, see Updating Oracle Backup RMAN Scripts.

Validating Backups for Restore

You can validate previously run backups to ensure the integrity of the data for successful restores.

Use the following steps to validate the backup jobs of a subclient:

  1. From the CommCell Browser, navigate to Client Computers | <Client>| Oracle | <Instance>.
  2. Right-click the Subclient and click Properties.
  3. Click the Advanced tab, and then click the Options tab.
  4. Select the Validate check box.
  5. Click OK.

Run the backup.

Disabling RMAN Warnings from RMAN Output

For information on how to disable RMAN warnings, see Disabling RMAN Warnings from RMAN Output.

Managing Jobs

For information on how to manage the job, see Job Controller Overview.

Last modified: 3/19/2018 12:35:35 PM