Commands for Restoring

The Database Manager supports the restoring of the database instance after hardware errors. The last state of the database is restored. A prerequisite for this is that all the data specified in the backup history is available.

To obtain the highest possible throughput of data, full and incremental data backups can be imported from a number of backup media simultaneously. The number of parallel backup media used for the restore does not depend on the number of parallel backup media used to make the backup originally. Even a backup made to single medium plus continuation media can be imported in parallel.

You define the maximum number of backup media that can be imported concurrently using the parameter MAX_BACKUP_DEVS. The use of up to 32 tape devices allows you to reduce restore times considerably.

Prerequisites

Note the operator authorizations required for the particular DBM commands.

The prerequisite for executing all other restore commands is to execute the command to restore the database instance first.

Syntax

Displaying Current Information About the Database Instance

db_restartinfo

Displaying the Current Restore Status

recover_state

Terminating an Interrupted Restore or Backup Check

recover_cancel

Continuing a Parallel Restore or Backup Check

recover_ignore

Restoring the Database Instance

recover_start

Restoring the Parameter File from a Data Backup

recover_config

Restoring a Database Instance with Initialization

db_activate RECOVER

Recreating a Damaged Index

sql_recreateindex

Restoring with External Backup Tools

---

Restoring or Checking a Backup with Succeeding Medium

recover_replace

End of Content Area

No comments:

topics