RESTARTABLE_RESTORE configuration parameter
Use the RESTARTABLE_RESTORE configuration parameter to enable or disable restartable restores.
- onconfig.std value
- RESTARTABLE_RESTORE ON
- values
- OFF
- Disables restartable restore. If a restore fails and RESTARTABLE_RESTORE is OFF, you are not able to restart it.
- ON
- Enables restartable restore. Set RESTARTABLE_RESTORE to ON before you begin a restore. Otherwise, you will be unable to restart the restore after a failure.
- takes effect
- After you edit your onconfig file. If you need to restart a physical restore, you do not need to restart the database server before you can use RESTARTABLE_RESTORE. If you need to restart a logical restore, you must restart the database server before you can use restartable restore.
Turning on RESTARTABLE_RESTORE slows down logical restore performance. For more information, see onbar -RESTART syntax: Restarting a failed restore.