Entering content frame

This graphic is explained in the accompanying text Example: Backup and Recovery Locate the document in its SAP Library structure

The following figure shows an example of how you can backup a database instance that is running and then restore the data after a system failure using data and log backups.

This graphic is explained in the accompanying text

Example of backup and recovery

...

       1.      Create a complete data backup up of the database instance HOTELDB to a backup medium.

       2.      Activate automatic log backup. The database system creates log backups regularly from this point in time.

       3.      Create incremental data backups at regular intervals.

       4.      There is a system failure because the hard disk with the data area of the database instance has a hardware error. The hard disk the log area is located in is undamaged, however.

       5.      To restore the database instance, proceed as follows:

                            a.      Replace the defective hard disk.

                            b.      Import the last complete data backup.

                            c.      Import the last incremental data backup.

                            d.      Import the log backups since the last incremental data backup. If there are still log entries in the undamaged log area, then the database system uses these log entries instead of the corresponding log backups.

       6.      The database system transfers the database instance back to ONLINE operational state.

 

Leaving content frame