You must create two backup jobs, one for DBC only and one for all DBC user data.
Before you create a restore job, a backup job must have completed successfully or with a warning.
-
Create a backup job that includes only the DBC database.
Example: dsc create_job -n DBC-Only -f
DBCOnlyJob.xml
The following code example excludes all children of DBC by setting the <includeAll> attribute to false.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC"> <job_instance> <job_name>DBC-Only</job_name> <job_description>Backup DBC only and exclude all child objects</job_description> <job_type>BACKUP</job_type> <job_state>ACTIVE</job_state> <auto_retire>false</auto_retire> <objectlist> <objectinfo> <object_name>DBC</object_name> <object_type>DATABASE</object_type> <parent_name></parent_name> <parent_type>BACKUP_JOB</parent_type> <object_attribute_list> <includeAll>false</includeAll> </object_attribute_list> </objectinfo> </objectlist> </job_instance> <source_tdpid>systemname</source_tdpid> <target_media>1_5_drives</target_media> <job_options> <online>false</online> <data_phase>DATA</data_phase> <query_band></query_band> <dsmain_logging_level>Error</dsmain_logging_level> <nowait>true</nowait> </job_options> </dscCreateJob>
- When prompted, enter login credentials.
- Run the job. Example: dsc run_job -n DBC-Only
-
Create a backup job for user data that includes all children of DBC but excludes the DBC database.
Example: dsc create_job -n DBC-All -f
DBCAllJob.xml
The following code example includes all children of DBC by setting the <includeAll> attribute to true.
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <dscCreateJob xmlns="http://schemas.teradata.com/v2012/DSC"> <job_instance> <job_name>DBC-All</job_name> <job_description>Backup user data and all objects in DBC</job_description> <job_type>BACKUP</job_type> <job_state>ACTIVE</job_state> <auto_retire>false</auto_retire> <objectlist> <objectinfo> <object_name>ABC</object_name> <object_type>DATABASE</object_type> <parent_name></parent_name> <parent_type>BACKUP_JOB</parent_type> <object_attribute_list> <includeAll>true</includeAll> </object_attribute_list> </objectinfo> </objectlist> </job_instance> <source_tdpid>systemname</source_tdpid> <target_media>1_5_drives</target_media> <job_options> <online>false</online> <data_phase>DATA</data_phase> <query_band></query_band> <dsmain_logging_level>Error</dsmain_logging_level> <nowait>true</nowait> </job_options> </dscCreateJob>
- If prompted, enter login credentials
- Run the job. Example: dsc run_job -n DBC-All