Restoring a Database - Tivoli

Teradata Extension for Tivoli Storage Manager Administrator Guide

Product
Tivoli
Release Number
16.20
16.10
Published
May 2017
Language
English (United States)
Last Update
2019-03-22
dita:mapPath
beb1489436039198.ditamap
dita:ditavalPath
beb1489436039198.ditaval
dita:id
wkq1486409855180
Product Category
Teradata Tools and Utilities

Use the next procedure to run a restore operation.

  1. 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 to the left of the dataset name to expand the tree further.

  2. 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 in the lower right pane under Details.
    • If the database has a hierarchical view, go to step 3.

    • If the database does not have a hierarchical view, skip to step 4.

    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 example shows a database example without a hierarchical view.


  3. The following example shows a database with a hierarchical view. Double-click to navigate to a level in the left pane. The job and its tables appear in the right pane.


  4. Right-click on the database icon or table in the right pane.

    A dialog box for copy and Partitioned Primary Index (PPI) options appears.



    The options for the COPY options tab are:
    Option Description
    Rename Object Gives the object in the archive a different name from 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.
    Checking any of the boxes on this tab automatically selects the COPY script option of the Script Options dialog box for restore operations.
  5. On the PPI options tab, under Partition selection, click on the radio button for one of these three options:
    • Full table – (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.

    All PPI options are valid when restoring a table. Only the All Partitions option is valid when restoring a database.
  6. Click RESTORE object selection > File > Build ARC script.

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

  7. 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 DBCdialog box appears instead of the Script Options dialog box.


  8. 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 TSM prior to 14.0, update the job IDs before restoring the image.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.

    It is possible to specify fewer streams when restoring a job than were specified when the job was archived.

    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.
    Configure
    RestoreScript Objects are restored instead of copied.

    The RestoreScript radio button is automatically selected. To copy objects, click CopyScript.

    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 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;

    Selecting QueryBanding enables the QB Options button.

    QB Options [Optional] Click QB Options. In 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, Tivoli can locate it without searching the entire tape.
    Verify CheckSum [Optional] Verifying the 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 Tivoli considers idle time. If you skip the build steps now, manually run the build step outside of Tivoli after all data is restored.
    Character Set The default is ASCII. Select another character set if appropriate.
    Options [Optional] If TSM options such as node name and password were changed at runtime for the backup job, provide those options for the restore job.
    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.
  9. In the Script Options dialog box, click Save, then Launch. The restore job status appears in the Teradata Tiered Archive/Restore Architecture dialog box.