Restoring DBC and User Data - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

Product

Data Stream Architecture

Release Number

16.10

Published

August 2017

Language

English (United States)

Last Update

2018-04-17

dita:mapPath

mbk1487616377418.ditamap

dita:ditavalPath

3150_DSA_UG_1610.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 DIPERRS, 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 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 Enabling a System or Target Group.
Start DSMain on the target system from the Database Window (DBW) console supervisor screen by entering: start bardsmain
After bardsmain has started, activate the system by running the following command: dsc enable_component – n Tivtera –t SYSTEM.
Enable logons for the DBC user only. On the target system, enter the following from the DBW console supervisor screen: enable dbc logons

Create a DBC-Only restore job, excluding all children of DBC, for 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	Current DBC user for the target DBS.
Target password	Current DBC password for the target DBS.
Is this Restore job a DBC restore?	y.
Username for the backup	dbc.
Password for the backup	DBC password of the source system at the time the backup saveset was generated.

Run the job. 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, for 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. dsc run_job -n Restore-DBC-All
On the target system, run the DIP and execute the DIPALL script.
On the target system, from the DBW console supervisor screen, enable logons for all users.