Show TOC

Deleting Offline Redo Log Backups on Disk with BR*ToolsLocate this document in the navigation structure

Use

You can use BR*Tools for Oracle to delete disk backups of the offline redo log files (that is, the archivelogs). BRARCHIVE performs the deletion.

Caution

Make sure that you copy disk backup files to another storage medium, such as tape, before you delete them with this procedure.

Caution

BRARCHIVE deletes all available disk backups of offline redo log backups when you perform this procedure, unless you restrict this by setting the Maximum number of files (see the table below).

Prerequisites

Make sure that you have set the necessary BRARCHIVE parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRARCHIVE.

Procedure

  1. Start BRGUI or BRTOOLS.

  2. Choose Start of the navigation path Backup and database copy Next navigation step Additional functions Next navigation step Deletion of archivelog disk backups End of the navigation path.

  3. Set the required options:

    Menu Entry

    Equivalent BRARCHIVE

    Command Option

    BRARCHIVE profile (profile)

    -p|-profile

    Database user/password (user)

    -u|-user

    Backup device type (device)

    -d|-device

    Delete after second copy (sec_copy)

    -dc

    Maximum number of files (number)

    -n|-number

    Confirmation mode (confirm)

    -c|-confirm

    Query mode (query)

    -q|-query

    Additional output (output)

    -o|-output

    Message language (language)

    -l|-language

    BRARCHIVE command line (command)

    This shows you the BRARCHIVE -a -ds|dc command that is to be executed using the current settings.
    Caution

    Choose as device type the same device that you used for the backup of the disk backup of the offline redo log files (tape or Backint or stage). Do not use device type disk, because this deletes the original files in oraarch or saparch.

  4. To start processing with the selected options, choose Continue.

  5. You check the results in the BRARCHIVE logs.

    • The summary log arch<DBSID>.log displays the return code.

    • The detail log a<encoded timestamp>.<ext> displays progress.

For more information on how to view the logs, see Showing Profiles and Logs with BR*Tools.