Entering content frameProcedure documentation Restoring Individual Files Locate the document in its SAP Library structure

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.

Caution

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:

  1. Non-database files
  2. Database data files
  3. Control files
  4. Online redo log files
  5. Offline redo log files
  6. Oracle profiles init<DBSID>.ora and init<DBSID>.dba
  7. BRBACKUP/BRARCHIVE profile init<DBSID>.sap
  8. Main SAPDBA log reorg<DBSID>.log and the structure log struct<DBSID>.log (if it exists, also the script create_raw_links)
  9. Summary BRBACKUP/BRARCHIVE log
  10. Detailed BRBACKUP/BRARCHIVE log

Select the required file type. Your selection is indicated by an arrow and displayed in the status line Current selection: <file type>.

Note

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 -n|-number for BRRESTORE.

Caution

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 +<file number>. Enter -<file number> to change the flag back to no.

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.

 

 

Leaving content frame