In interactive mode, you can specify:
A different target server than the source server. If the target database you specify does not exist, a new database is automatically created.
Whether the last transaction is dumped from the source server and loaded on to the target server. If your data device fails and the database is inaccessible, the dump transaction does not truncate the log.
Whether to drop and re-create the database.
Whether to use the current dump history files or external dump files.
The location for the dump transaction.
Whether to bring the database online immediately after the restore.
A point in time, within the range of time during which the database is backed up in the dump history files, from which to restore the database.
Reinitialize and re-create the database devices of an offline database for which the devices are offline. Then restore the re-created database.