Show TOC

Procedure documentationBacking Up the Database with BR*Tools Locate this document in the navigation structure

 

You can use BR*Tools for Oracle to back up the database. BRBACKUP performs the backup.

Note Note

Remember that the SAP system is not available for production work during an offline backup, since the database is closed. However, you can perform an online backup when the database system and SAP system are running.

End of the note.

Prerequisites

  • Make sure the database is running in ARCHIVELOG mode. For more information, see Setting Up Archiving.

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

  • Make sure you have the right backup volumes. When you back up to tape, make sure that you have read the notes on managing and initializing the tapes. For more information, see Volume Management.

  • Allow enough time for the backup. Hardware compression can halve the backup time.

Procedure

  1. Start BRGUI or BRTOOLS.

  2. Choose   Backup and database copy   Database Backup  .

  3. Set the required options:

    Menu Entry

    Equivalent BRBACKUP Command Option

    BRBACKUP profile (profile)

    -p|-profile

    Backup device type (device)

    -d|-device

    Tape volumes for backup (volume)

    -v|-volume

    BACKINT/ Mount profile (parfile)

    -r|-parfile

    Database user/password (user)

    -u|-user

    Backup type (type)

    -t|-type

    Files for backup (mode)

    m|-mode

    Confirmation mode (confirm)

    -c|-confirm

    Query mode (query)

    -q|-query

    Compression mode (compress)

    -k|-compress

    Verification mode (verify)

    -w|-verify

    Fill-up previous backups (fillup)

    -f|-fillup

    Parallel execution (execute)

    -e|-execute

    Additional output (output)

    -o|-output

    Message language (language)

    -l|-language

    BRBACKUP command line (command)

    This shows you the BRBACKUP command that is to be executed using the current settings.

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

  5. Check the results in the BRBACKUP logs.

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

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

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