Restoring a Database

Click Teradata Tiered Archive/Restore Architecture > Task > Restore.

The RESTORE object selection dialog box appears.

In the left pane are datasets (jobs). The names underneath the Datasets icon are backup images and are listed in chronological order (earliest image to latest image). Click the icon to the left of the dataset name to expand the tree further.

To restore a job, select the box next to it.

The name of the specified object appears in the upper right pane, and the Backup Application name appears in the lower right pane.

Double-click on the icon to the left of the object name to expand the tree and show the specific tables to be restored.

The following screen capture shows a database with a hierarchical view.

[Optional] Right-click on the database icon or table in the right pane to specify copy and Partitioned Primary Index (PPI) options.

A dialog box with COPY options and PPI options tabs appears.

[Optional] Specify COPY options as described in the following table.

Option	Description
Rename Object	Gives the object in the archive a different name than the target object.
Disable fallback on table (NO FALLBACK)	Copies fallback tables into non-fallback tables. If the archived table is already non-fallback, this option has no effect.
Disable journaling on table (NO JOURNAL)	Copies all tables with journaling disabled, whether journaled in the archive or not.
Replace table creator value (REPLACE CREATOR)	Replaces the LastAlterUID, creator name, and Creator ID of the tables in the target database with the user ID and the current user name, that is, the user name specified in the LOGON command.
Specify different journal table	Specifies that a copied database has journaling for the specified database and journal table.
APPLY TO list	Identifies the tables in the target system where the change images apply.

[Optional] To specify PPI options, select the PPI options tab, then click one of the following radio buttons:
- Full table, which is the default, restores the entire table
- All Partitions restores all partitions
- Selected Partitions restores the specified partitions
Under the Other PPI Options portion of the dialog box, select the LOG WHERE box to specify rows to be logged to an error table for manual insertion and deletion. Select the Error table name box to enter a table name other than the default name that is shown.

In the RESTORE object selection dialog box, click File > Build ARC script.

After the database objects are selected, the Selection dialog box appears.

When you click OK, the Script Options dialog box appears.

If you are restoring a job that backed up only the DBC database or all of the DBC database, the Restore DBC dialog box appears instead of the Script Options dialog box.

In the RESTORE object selection dialog box, select options as described in the following table.

Option	Description
Job Name	Entries in the Job Name box are case-sensitive. A job name must not contain any spaces, or these characters: < > ~ " * , ? \ / Scripts that are created or modified manually are not checked to see if the name contains spaces or the characters listed above. The maximum length of the job name for Archive and Restore scripts is 220 characters. If this limit is exceeded, an error message requests that the job name be re-entered.
Always restore latest	[Optional] Check the Always restore latest box to automatically restore the last image that was backed up successfully. If you are restoring an image created with a version of Teradata Extension for NetBackup prior to 14.0, update the job IDs before restoring the image. Select the Update Latest Job Ids box in RESTORE object selection > Edit > Update Latest Job Ids.
Description
TDPID	This list reflects the TDPID with which you logged on. To restore a database or table from one Teradata Database to another Teradata Database, select another TDPID from the list of TDPIDs.
User Name	The user name with which you logged on appears. To create another job for the specified database using another user name and password, type the new user name.
Password	The password with which you logged on appears. To create another job for the specified database using another user name and password, type the new password.
SingleStream or MultiStream	Click SingleStream or MultiStream. For MultiStream, type the number of streams in the Multi stream box. The number of streams is essentially the number of BAR server tape drives that are configured. For example, if there are four BAR servers, each having two tape drives, enter eight streams. You can specify fewer streams when restoring a job than were specified when the job was archived. See Restoring a Multistream Archive Using Fewer Streams.
Default Group	The list defaults to all clients, that is, no client group. If there are many clients, select a name from the list of available client groups. Using a client group reduces the amount of selections needed when building a new archive/restore job.
Assign Clients	Each stream defaults to All clients. Click Assign Clients to assign a specific client to each stream. Assign a client system that uses a current name or the restore job will fail.
Configure
RestoreScript	Objects are restored instead of copied. The RestoreScript radio button is automatically selected. To copy objects, click CopyScript.
Full or Dictionary Only	[Optional] Select Dictionary Only from the drop-down list to restore only the dictionary, or allow the Full Backup selection to restore the dictionary and data. The drop-down list is enabled only when the RestoreScript or CopyScript radio button has been selected.
CopyScript	To copy, instead of restore an object, click CopyScript. The RestoreScript radio button is cleared.
Analyze	When this option is selected, all the records are validated to ensure the correct order and type of records are on the tape. The entire backup image is analyzed, regardless of the databases that are selected for the analyze job.
QueryBanding	[Optional] Select QueryBanding. In the QueryBanding box, specify one or more pairs of names with associated values to identify the source of a query. This allows setting different priorities for different requests, and the ability to make better use of system resources. For example, enter name and value pairs, ending with a semi-colon: aaa=bbb;ccc=ddd;
QB Options	[Optional] Click QB Options to open the QueryBanding Options dialog box. Selected options are added to the job script. [Optional] Check the TVS Temperature box to enable a list with the following selections: Hot Specifies that the job is hot data, which is frequently accessed and changed. Warm Specifies that the job is warm data, which is more frequently accessed and changed than cold data. Cold Specifies that the job is cold data, which is infrequently accessed and rarely changed. Auto The temperature setting is based on the target system temperature settings. [Optional] Check the Block Compression box to enable a list with the following selections: Yes Block level compression is enabled. This setting overrides the setting information saved with the archive job. No Block level compression is disabled. This setting overrides the setting information saved with the archive job. Auto The block level compression setting is based on the target system block level compression settings.
Sessions (per stream)	The default for the selected database is set in the Teradata tab of the TARA Server Configuration dialog box. A general rule is to have one session per amp being archived in the stream. An adequate number of parallel ARC sessions per stream are necessary to keep data moving. Too few sessions cause ARCMAIN to be the bottleneck during archival. Too many sessions waste resources because some of the sessions remain idle. Refer to Teradata Archive/Recovery Utility Reference (B035-2412) for more detail.
Extra Options	[Optional] Enter any ARCMAIN command line options that are not part of the GUI ARC build flow. IOTRACE=5 is the default.
Use Catalog	[Optional] Select Use Catalog to specify positioning data so that when an object is restored, NetBackup can locate it without searching the entire tape.
Verify CheckSum	[Optional] Verify Checksum verifies that the data being restored is valid. The checkbox is selected by default. However, the overhead of error checking slows the restore process. To improve performance, clear the checkbox. Job scripts created prior to clearing the Verify Checksum box have the verify checksum feature enabled by default.
Skip Build Steps	[Optional] Select this check box to skip the build steps, which NetBackup considers idle time. If you skip the build steps now, manually run the build step outside of NetBackup after all data is restored.
CharacterSet	The default is ASCII. Select another character set if appropriate.
Extra Buttons
Save	Click Save to accept the script options that have been selected.
Launch	Click Launch to launch the job. The job appears in the Teradata Tiered Archive/Restore Architecture dialog box.
Preview	[Optional] Click Preview to open the Script Editor dialog box and display the job script. Make any corrections, then click Save in the Script Editor dialog box, then Launch to launch the job.
Close	Click Close,but do not click Save, to close the dialog box without saving any changes.

In the Script Editor dialog box, click Save.

Click Launch.

Restore job status appears in the Teradata Tiered Archive/Restore Architecture dialog box.

Restoring a Database - NetBackup

Teradata Extension for NetBackup Administrator Guide