Restoring DBC and User Data - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product

Data Stream Architecture

Release Number

15.11

Published

December 2016

Language

English (United States)

Last Update

2018-04-17

dita:mapPath

zwp1479744478413.ditamap

dita:ditavalPath

3150_DSA_UG_1511.ditaval.ditaval

dita:id

B035-3150

lifecycle

Product Category

Software

Teradata Tools and Utilities

You must create two restore jobs, one for DBC only and one for all DBC User Data.

Before you create a restore job, a backup job must have been completed successfully or run with a warning.

On the target system, run the DBS Database Initializing Program (DIP) and execute the following:
- For Teradata Database 15.0 and higher, run DIPMIG script, which runs DIPERR, DIPDB, DIPVIEWS, DIPVIEWSV and DIPBAR.
- For Teradata Database 14.10, run DipErrs, DipViews, and DIPBAR scripts (1, 4, and 21).
Check the activation status of the system running SYSINIT and perform one of the following:
- If the system is already configured and activated in DSA, deactivate the system, add the system again, and reactivate the system. Re-adding the system will repopulate the connectinfo macro in the SYSBAR database with the JMS connection information. See Disabling a System or Target Group, Configuring a System and Node, and Enabling a System or Target Group.
- If the target system is not configured in DSA, the system must be added and activated before the restore can proceed. See Configuring a System and Node and Enabling a System or Target Group.
Start DSMain on the target system from the Database Window (DBW) consoles supervisor screen by entering start bardsmain (this starts DSMain).
After bardsmain has started, activate the system by running the following command: Enter dsc enable_component – n Tivtera –t SYSTEM.
On the target system from the Database Window (DBW) consoles supervisor screen, type enable dbc logons to enable logons for the DBC user only.

Create a DBC-Only restore job, excluding all children of DBC: Example: dsc create_job -n Restore-DBC-Only -f RestoreDBCOnlyJob.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC">
    <job_instance>
        <job_name>Restore-DBC-Only</job_name>   
        <job_description>Restore DBC only and exclude all child objects</job_description>
        <job_type>RESTORE</job_type>
        <job_state>ACTIVE</job_state>
        <auto_retire>false</auto_retire>
        <backup_name> DBC-Only </backup_name>
        <backup_version>0</backup_version>
        <all_backup_objects>true</all_backup_objects>
    </job_instance>
    <source_media>1_5_drives </source_media>
    <target_tdpid>systemname</target_tdpid>
    <job_options>
        <enable_temperature_override>false</enable_temperature_override>
        <temperature_override>DEFAULT</temperature_override>
        <block_level_compression>DEFAULT</block_level_compression>
        <disable_fallback>false</disable_fallback>
        <query_band></query_band>
        <dsmain_logging_level>Debug</dsmain_logging_level>
        <nowait>true</nowait>
        <reblock>false</reblock>
        <run_as_copy>false</run_as_copy>
    </job_options>
</dscCreateJob>

When prompted, enter login credentials:

Option	Description
Target username	Enter current DBC user for the target DBS.
Target password	Enter current DBC password for the target DBS.
Is this Restore job a DBC restore?	Enter y.
Username for the backup	Enter dbc.
Password for the backup	Enter DBC password of the source system at the time the backup saveset was generated.

Run the job. Example: dsc run_job -n Restore-DBC-Only After the DBC restore job is complete, the DBC password is set to the DBC password of the source system. The DBC database must restore successfully before you can restore user data.

Create a DBC-All restore job for user data, including all children of DBC. Example:dsc create_job -n Restore-DBC-All -f RestoreDBCAllJob.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC">
    <job_instance>
        <job_name>Restore-DBC-All</job_name>   
        <job_description>Restore user data and all objects in DBC</job_description>
        <job_type>BACKUP</job_type>
        <job_state>ACTIVE</job_state>
        <auto_retire>false</auto_retire>
        <backup_name>DBC-All</backup_name>
        <backup_version>0</backup_version>
        <all_backup_objects>true</all_backup_objects>
    </job_instance>
    <source_media>1_5_drives</source_media>
    <target_tdpid>systemname</target_tdpid>
    <job_options>
        <enable_temperature_override>false</enable_temperature_override>
        <temperature_override>DEFAULT</temperature_override>
        <block_level_compression>DEFAULT</block_level_compression>
        <disable_fallback>false</disable_fallback>
        <query_band></query_band>
        <dsmain_logging_level>Debug</dsmain_logging_level>
        <nowait>true</nowait>
        <reblock>false</reblock>
        <run_as_copy>false</run_as_copy>
    </job_options>
</dscCreateJob>

When prompted, enter login credentials and run job. Example: dsc run_job -n Restore-DBC-All
On the target system, run the DBS Database Initializing Program (DIP) and execute the DIPALL script.
On the target system, from the Database Window (DBW) consoles supervisor screen, enable logons for all users..