Previous Topic: Back Up Online Databases Using SAPDBA and BRBACKUPNext Topic: Back Up Offline Redo Logs Using SAPDBA and BRARCHIVE


Back Up Offline Databases Using SAPDBA and BRBACKUP

You can back up database files that were detected during the last online connection to the option.

Note: The control file is not backed up when an offline database is backed up.

To back up offline databases using SAPDBA and BRBACKUP

  1. Log on to SAPDBA.

    The SAP Database Administration screen displays.

    Offline Database Admin

  2. Select h - Backup database.

    The Backup Database screen displays.

    Offline Backup Database

  3. From the Backup Database screen, select c - Backup device type.

    The Select backup device type screen displays.

    Offline Select Backup Device

  4. From the Select backup device type screen, select g - external backup tool <backint>.
  5. Enter q to return to the Backup Database screen.
  6. From the Backup Database screen, select e - Backup type, and confirm that the current value is set to offline.
  7. Enter q to return to the Backup Database screen.
  8. From the Backup Database screen, select d - Objects for backup.

    The Backup Mode/Backup Objects screen displays:

    Offline Backup Mode_Backup Objects

  9. Specify the mode and objects to apply to this backup.
  10. Enter q to return to the Backup Database screen.
  11. Select s - Start BRBACKUP

    The backup starts.

Note: Optionally, you can call the brbackup command line utility to execute the offline database backup. The syntax for this command is as follows:

brbackup -d util_file -t offline -m all