Restoring a database in interactive mode

The interactive command line interface allows single-key entry, plus the Enter key to navigate through each menu. Use:

Space – to move back to the previous menu.
q – to quit the session.
? – to display help.

When the Restore Database wizard starts, which is based on the given parameters. For example, you see the menu shown below when you start sybrestore with the minimal options of user name, password, and server name:

sybrestore -Usa -P -SaseServer1

<<<<<<====Restore Database Menu ====>>>>>>>

s : Select Database
t : Target Server
r : Recreate Database
e : Use External Dump
c : Check Geometry
d : Dump Directory
o : Online Database
p : Preview
g : Go

This example illustrates how the Restore Database menu is affected if you include the point-in-time parameter in the sybrestore command:

sybrestore -Usa -P -SaseServer1 -t

<<<<<<====Restore Database Menu ====>>>>>>>

s : Select Database
t : Target Server
r : Recreate Database
i : Point-In-Time
c : Check Geometry
o : Online Database
p : Preview
g : Go

**Table 10-1: Restore Database menu**
Menu Option	Input Required
Select Database	Select the database to be restored.
Target Server	Select the target server if it is not same as source server. Provide the target server information: Server name or host name and port number. User name. Password. A mapping directory that maps the mount point of the dump files in the source server to the mount point of the dump files in the target server. Specify whether the target database has the same name as the source database.
Recreate Database	When the input is yes, the database is dropped and re-created using specified devices and device sizes, and log devices and log sizes.
Use External Dump	Whether you want to restore the database from dump history files. When the input is no, provide the external backup files to restore the database: The archive directory for the dump database file location and the dump database file name, including respective stripe names. The dump transaction log file location and multiple dump transaction log file names, including respective stripes names. Using the external dump option overrides using dump history files.
Geometry Check	When the input is yes, you see the comparison between the data size and log size of the device fragments of the dumped database, and the corresponding data size and log size of the device fragments of the target database. This option is provided when dump history files exist and external dump files are not being used to restore the database.
Dump Directory	When yes, you can change whether to dump the last transaction of the source database, and change the dump directory for dumping the last transaction.
Online Database	When yes, the database is brought online after restoring the database.
Point-In-Time	Select the point in time to restore the database.
Preview	Shows the SQL statements that will be executed.
Go	Use “Go” to run all the menus options without having to select menus individually. “Go” runs all menu options in sequence and then exits. If a menu item has already been executed, for example, if you have already selected a database, you are not prompted again to select a database.