In certain situations, it may be necessary to restore individual database files (data files, control files, or online redo log files) or non-database files.
Please note that SAPDBA does not check whether restoring the files is sensible. If the restore process causes inconsistencies in the database, you - the database administrator - are responsible for implementing the required recovery measures.
A recovery with SAPDBA (updating the data files) is only partially supported (see
Restoring One Tablespace). The restore is performed by calling the SAP utility BRRESTORE.Select Restore individual file(s).
Restore individual file(s) |
||
A |
- File type: |
<no selection> |
b |
- BRBACKUP run: |
<no selection> |
c |
- Instance name: |
<no need for a selection> |
d |
- Enter/show files: |
<no selection> |
S |
- Start BRRESTORE |
|
q |
- Return |
Defining the Type of File
Select menu item File type to define the type of the files to be restored.
The following files can be restored:
Select the required file type. Your selection is indicated by an arrow and displayed in the status line
Current selection: <file type>.Note that all the specified profiles and logs are always reloaded for options 6, 8 and 9. No further selection is possible.
See command option
Note that logs and profiles can only be restored from certain types of backup (device types
tape, pipe, tape auto, pipe auto) (see -d|-device). A restore from disk, for example, is not supported. Please note the appropriate warning messages from SAPDBA.Select Return to continue with the process.
Finding the Backup Files
The selected file type is shown in the Restore individual file(s) menu. You can now use menu item BRBACKUP run to specify the backups to be used for restoring the files.
Selecting/Displaying the Files to Restore
Select Enter/show files, if required.
You can flag a file for restoring (Res yes) by entering its number or by entering
In some cases, the list of files found may be quite long. Use
RETURN to scroll through the list.Only those files assigned the flag Res yes are restored. If the selection is correct, press
RETURN to continue processing.Restoring the Files
Select the menu item Start BRRESTORE. The important parameters and options used by BRRESTORE are displayed for the specific situation. You can change these values if necessary.
See
Changing the Restore and Recovery Options.If the information displayed is correct, select the option Return to Restore individual file(s) and continue to start the restore process.
SAPDBA does not check the database state or whether the restore operation is logical. You will probably have to recover the database once you have restored the database files.
During a restore, backups are physically restored with the SAP utility BRRESTORE. BRRESTORE checks whether the files to be restored still exist. If so, a warning message is issued, and you will have to confirm (by entering
cont) that you want to overwrite these files.Depending on the data medium selected, other prompts may be displayed involving the type of backup device, the backup program, etc.
Once the backup has been restored, the menu Restore individual file(s) menu is displayed again.
Inspect the log file written by SAPDBA
<SAPDATA_HOME>/sapreorg/<timestamp>.dba. Select the SAPDBA function Show/Cleanup ® Show log files/profiles.See SAPDBA Log Files and Their Contents.