Start of Content Area

This graphic is explained in the accompanying text Homogeneous System Copy with the Database Manager CLI Locate the document in its SAP Library structure

You can generate a Structure linkhomogeneous system copy of your database instance by using the following DBM commands:

Creating a backup medium for complete data backups in the original instance:

dbmcli -d TST -u dbm,dbm medium_put databasecopy /usr/sapdb/dbcopy FILE DATA 0 0 NO

Creating a complete data backup of the original instance:

dbmcli -d TST -u dbm,dbm -uUTL -c backup_start databasecopy

Installing the target instance:

dbmcli -s –R <dependent_path> db_create TST1 dbm,dbm

Copying and modifying database parameters from the original instance:

dbmcli -d TST1 -u dbm,dbm -uSRV -c recover_config databasecopy
dbmcli -d TST1 -u dbm,dbm
  > param_startsession
  > param_put RUNDIRECTORY <newrundirectory>
  > param_put DIAG_HISTORY_PATH <newdiaghistorypath>
  > param_checkall
  > param_commitsession

Configuring data volumes of the target instance:

dbmcli -d TST1 -u dbm,dbm param_addvolume DATA <newdatavolume> <datatype> <datasize>
dbmcli -d TST1 -u dbm,dbm param_addvolume LOG <newlogvolume> <logtype> <logsize>

Creating the backup medium in the target instance:

dbmcli -d TST1 -u dbm,dbm medium_put databasecopy /usr/sapdb/dbcopy FILE DATA 0 0 NO

Switching the target instance to the operational state ADMIN:

dbmcli -d TST1 -u dbm,dbm db_admin

Initializing the target instance:

dbmcli -d TST1 -u dbm,dbm util_execute INIT CONFIG

Importing the data backup of the original instance into the target instance:

dbmcli -d TST1 -u dbm,dbm -uUTL -c recover_start databasecopy

Switching the target instance to the operational state ONLINE:

dbmcli -d TST1 -u dbm,dbm db_online

Loading the system tables, assigning passwords for SYSDBA and DOMAIN users:

dbmcli –d TST1 –u dbm,dbm load_systab –u <sysdba>,<password> -ud <password2>

 

End of Content Area