Restore Statement
The restore statement is used to identify what to restore and to which location to restore it.
Format for Restoring Data
![[image expected here]](/assets/images/RestoreStmtFormatData_2.22-a082f5af512ef4809a89381a3bb27639.png)
Format for Restoring Catalog
![[image expected here]](/assets/images/RestoreStmtFormatCatalog_2.22-9fb7e3c1362b1b4c2845bd869b046692.png)
Where:
![[image expected here]](/assets/images/RestoreStmtWhere_2.22-839afe5258399869d8ce0aabbc720e50.png)
The Catalog can only be restored from TAPE. The Catalog cannot be restored from CATALOG.
Description
- NODE (nodename nodetype [ipaddress])
| nodename | The name in the Catalog of the node to which the data will be restored. |
| nodetype | The operating system on the node. Valid entries are UNIX, WINNT, WIN95, NETWARE, and NDMP. |
| ipaddress | The TCP/IP address of the node to which the data will be restored. |
- DISK (disk fstype)
DISK does not apply to UNIX operating systems.
| disk | The disk to which the data will be restored. Example: C:. |
| fstype | The type of file system on the disk. Valid entries are NTFS, FAT, DOS, NETWARE, and RAW. |
- SELECT (selection)
Includes or excludes specific files.
| selection | The specific files to include or exclude. To include files, precede the files with I (for example, I "/home/."). To exclude files, precede the files with E (for example, E "/home/."). An asterisk can be used as a wildcard. Separate multiple selections with semi-colons. Selection strings must be enclosed in quotes. |
- CATALOG
Used exclusively to restore the Catalog. The Catalog can only be restored from TAPE. The Catalog cannot be restored from CATALOG.
- NODE (nodename nodetype ipaddress) [DISK disk] PATH path
Specifies the location to which the data will be restored. If this is omitted, DPX restores data to its original location.
| nodename | The name of the node to which the data will be restored. |
| nodetype | The operating system on the node. Valid entries are UNIX, WINNT, WIN95, WIN31, and NETWARE. |
| ipaddress | The TCP/IP address of the node to which the data will be restored. |
| disk | The disk to which the data will be restored. DISK is not valid for UNIX. |
| path | The directory to which the data will be restored. The path specification must be enclosed in quotes. Example: "/tmp/restore/" |
- CATALOG DATE (startdate enddate)
Limits the Catalog search to files that were backed up between specific dates.
| startdate | The starting date for the Catalog search. The format for the date is mm/dd/yyyy. |
| enddate | The ending date for the Catalog search. The format for the date is mm/dd/yyyy. |
- JOBNAME
jobname
Limits the Catalog search to files that were backed up by a specific backup job definition.
| jobname | The name of the backup job definition that backed up the file. |
- JOBID jobid
Limits the Catalog search to files that were backed up by a specific instance of a backup job.
| jobid | The number assigned to the job by DPX. Each time a job runs, DPX assigns a number to the job. |
- TASKID taskid
Limits the Catalog search to files that were backed up by a specific SnapVault backup job task.
| taskid | The number assigned to the task by DPX. Each time a task runs, DPX assigns a number to the task. |
- DEVICECLUSTER devicecluster
| devicecluster | The name of the device cluster from which DPX will select a device to restore. |
- DEVICE devicename
| devicename | The name of the specific device or devices to restore from. |
- RDEVICE (d_evicefilename devicetype nodename nodetype ipaddress_)
The physical location of a device. Used with devices that have not been configured into DPX.
| devicefilename | The OS specific name used to refer to the device. Example (on Solaris): /dev/rmt/0. Example (on Windows): \.\Tape0. |
| devicetype | The device type. Example: 4mm. |
| nodename | The name of a node to which the device is attached. This node must have been previously defined (via the Enterprise function). You can have multiple devices on a node, up to the limit the hardware will support. |
| nodetype | The operating system on the node. Valid entries are UNIX, WINNT, WIN95, and NETWARE. |
| ipaddress | The TCP/IP address of the node to which the device is attached. |
- TAPE ({volser partition;}. . . )
Restores files from a specific tape or tapes. Separate multiple tape selections with semi-colons.
| volser | The volume serial number of the tape that contains the files to restore. |
|---|---|
| partition | The partition on the tape that contains the files to restore. Specify 0 to indicate all partitions. |