Background documentationEvaluating the Restart Information and Backup History for Importing Backups Locate this document in the navigation structure

 

To restore a database instance or set up a standby instance, you import backups into a database instance. Before you can import data and log backups, you first have to determine

  • with which page to begin the import

  • in which backup this page is located

  • which backup is the next to be imported

Prerequisites

You can find the prerequisites under Database Manager CLI

db_restartinfo

backup_history_open

backup_history_list

Procedure

You display the restart information of the database instance into which the backups are imported. From the restart information you can find out which log pages are in the log area, i.e. the first log page and the last used log page.

You can also display the backup history of the database instance from which the backups were created.

From the backup history you can determine:

  • for data backups: while restoring, which page should be imported after this backup

  • for log backups: which log pages are in the respective backup, i.e. from which page number to which page number

How you use this information depends on whether you are restoring a database instance or setting up a standby instance.

More Information

Restoring the Database Instance, section "Displaying Backup Information"

Setting Up and Updating Standby Instances