Restoring One Tablespace
In certain situations, it may be necessary to restore one tablespace. In this case, however, SAPDBA only provides limited support for the recovery. This action should only be used by experienced database administrators.
Select Restore one tablespace.
Enter the name of the tablespace. You can selectively restore objects that were backed up using BRBACKUP (or an external backup program). SAPDBA displays the backups it finds. Select the required backup.
Restoring the Files of a Tablespace
Depending on the situation, the program displays important parameters and option values used by BRRESTORE. You can change these values if necessary.
See
Changing the Restore and Recovery Options.If the current settings are correct, select the option Return to restore process and continue to start the restore process.
During the restore process, the backups are physically restored using the SAP utility BRRESTORE. SAP asks whether you really want to restore the files of the specified tablespace. The database is closed and the files are restored. The database remains closed once the restore process is complete.
Once you have restored the files of the database, you will probably have to recover the database. SAP displays the log sequence number of the first redo log file required for the recovery.
If you have merely restored old data files, and the redo log and control files are current, you can use the SAPDBA menu Check (and repair) database to update these files. The check will determine that some of the data files are outdated, and display the period necessary for recovery. For more information, see
Partial Restore and Complete Recovery with SAPDBA.Check the log file written by SAPDBA
<SAPDATA_HOME>/sapreorg/<timestamp>.dba. To do this, select the SAPDBA function Show/Cleanup ® Show log files/profiles.See SAPDBA Log Files and Their Contents.