HP StorageWorks P9000 Command View Advanced Edition Suite Software 7.0 Mainframe Agent Installation and Configuration Guide (TB581-96014, November 2010)

Specifies that the database should be restored in standby mode. When this option is specified, the
database can be used as read-only once the restoration has finished. Temporary files will be created
for each database in the undo file storage directory registered by the drmsqlinit command. If the
UNDO file storage directory has not been set using the drmsqlinit command, an error message
appears, indicating that no parameters are set for the drmsqlinit command. Specify the UNDO
file storage directory using the drmsqlinit command.
When this option is omitted, a regular restoration is performed. In this case, the database will be
placed in loading status once the restoration has finished, and will not be usable.
-nochk_host
Specify this option to restore the data to a host other than the one specified in the drmsqlbackup
command. This option is useful when the host name has been changed, or when the log distribution
function in SQL Server 2005 or SQL Server 2008 is used.
This option is not available when you restore a system database (master, model, msdb, or distribution).
Note
When you specify the -nochk_host option, confirm that backup data is restored on the appro-
priate host, because the validity of the host name in the backup catalog is not checked when
restoring backup data.
-instance name-of-the-SQL-Server-instance
Specify this option to restore the data to a SQL Server instance that is different from the SQL Server
instance on which you executed the drmsqlbackup command. If you specify DEFAULT as the SQL
Server instance name, you will be connected to the preset instance of the SQL Server. If the restoration
targets include a system database (master, model, msdb, or distribution), you cannot specify this
option.
-target database-name(s)
Specify this option to restore a particular database in the specified instance. The specified database
needs to exist in the backup catalog specified by the backup ID. When databases that do not exist
in the backup catalog are specified, those databases will not be restored. When specifying multiple
databases to be restored at the same time, use a comma to separate each database name. If you
specify a database name containing a space character, enclose the database name in double quotation
marks (").
When both this option and the -f option are omitted, the entire instance specified by the backup ID
will be restored.
-f target-definition-file-name
Like the -target option, this option restores an instance containing specific databases. Unlike the
-target option, this option lets you specify a target definition file that collectively specifies all the
databases to be restored. The target definition file containing the list of databases must be created
before you attempt to use this option. Use an absolute path name to specify the target definition file.
If you specify a target definition file name containing a space character, enclose the target definition
file name in double quotation marks (").
When both this option and the -target option are omitted, all the objects included in the instance
specified by the backup ID will be restored.
-no_resync
Specify this option to apply only the metafiles for the data on the primary volume, without performing
restoration processing or backing up data from the secondary volume to the primary volume. Use this
option when the restore operation cannot be performed with the drmsqlrestore command (for
example, when restoring backup data directly from a tape device to the primary volume because of
a drive failure).
Basic commands180