15.11 - Restoring DBC and User Data - Data Stream Architecture

Teradata Data Stream Architecture (DSA) User Guide

prodname
Data Stream Architecture
vrm_release
15.11
created_date
December 2016
category
User Guide
featnum
B035-3150-026K
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.
  1. 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).
  2. Check the activation status of the system running SYSINIT and perform one of the following:
  3. Start DSMain on the target system from the Database Window (DBW) consoles supervisor screen by entering start bardsmain (this starts DSMain).
  4. After bardsmain has started, activate the system by running the following command: Enter dsc enable_component – n Tivtera –t SYSTEM.
  5. On the target system from the Database Window (DBW) consoles supervisor screen, type enable dbc logons to enable logons for the DBC user only.
  6. 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>
    
  7. 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.
  8. 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.
  9. 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>
    
  10. When prompted, enter login credentials and run job. Example: dsc run_job -n Restore-DBC-All
  11. On the target system, run the DBS Database Initializing Program (DIP) and execute the DIPALL script.
  12. On the target system, from the Database Window (DBW) consoles supervisor screen, enable logons for all users..