Previous Topic: Back Up Offline Redo LogsNext Topic: The BACKINT Job Status


Restore and Recover Using SAPDBA

You can use the following procedure to restore and recover using SAPDBA.

To restore or recover databases with SAPDBA

  1. Log onto SAPDBA.

    The SAPDBA main screen opens.

  2. Ensure that Expert mode is ON.

    Note: Before restoring data through SAPDBA, you must be in Expert mode. See your SAP manual for instructions.

  3. From the main screen, enter k—Restore/recovery.

    The Restore / Recovery screen opens.

    Recover and Restore using SAPDBA

    Full Restore lets you restore the database and startup open (no recovery possible), or restore the database and startup mount (for manual recovery using the backup control file).

    Full Restore and Recovery allows you to select a full online or offline backup, restore and recover database objects, recover until (allows you to choose among proper timestamps), or show the status of the job.

  4. Choose the type of restore from the Restore/Recovery menu options.

    See your SAP manual for more information about completing the remaining restore or recovery steps.