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.