Skip to content

Backup and Restore of metadata manually

Jatinder-Luthra edited this page Aug 13, 2020 · 2 revisions

To backup and restore the Delphix Engine metadata manually, execute the dxtoolkit scripts provided below.

Metadata Backup steps

  1. Backup users

     dx_get_users -d <SourceEngine> -export /backupdir/users.csv -profile /backupdir/profile.csv
    

    Above command will generate two files users.csv and profile.csv

    profile.csv contains role information for standard users only (if any)

  2. Backup policy

     dx_get_policy -d <SourceEngine> -export -outdir /backupdir -mapping /backupdir/policy.mapping
    

    Above command will generate multiple files, one for each policy with suffix .policy. Will also generate another file as policy.mapping which contains policy to object mapping.

  3. Backup VDB Config templates

      dx_get_template -d <SourceEngine> -export -outdir /backupdir
    

Above command will generate multiple files, one for each VDB config template with suffix .template

  1. Backup Hook Operation templates

     dx_get_op_template -d <SourceEngine> -exportHook -outdir /backupdir
    

Above command will generate multiple files, one for each hook operation template with suffix .opertemp

  1. Generate environments script

     dx_get_env –d <SourceEngine> -backup /backupdir
    

    Above command will generate a file backup_env.txt

  2. Generate script for all dSources and VDB

     dx_get_db_env -d <SourceEngine> -backup /backupdir
    

    Above command will generate two files, one for dSource backup_metadata_dsource.txt and another one for vdb backup_metadata_vdb.txt

  3. Generate script for Self Service templates

     dx_get_js_templates -d <SourceEngine> -backup /backupdir
    

    Above command will generate a file backup_selfservice_templates.txt

  4. Generate script for Self Service containers

     dx_get_js_containers -d <SourceEngine> -backup /backupdir
    

    Above command will generate a file backup_selfservice_containers.txt

Metadata Restore steps

Restore of metadata can be done by executing scripts manually which are generated by backup.

Make sure hostname entry in conf file for target engine must be same as source engine for restore scripts to execute. Else, update the hostname -d <engine> in backup scripts to match target engine.

Update the password for OS users and DB users in backup scripts to actual passwords before restore.

Delphix

Clone this wiki locally