By copying the database files, you can duplicate the configuration files of the master database to all standby databases of a hot standby system after having changed the database configuration.
To copy database files from one database to another within a cluster system, always use the DBM command hss_execute.
However, for support purposes it is possible to copy a database file to another database using the DBM command hss_copyfile, irrespective of whether the source database or the target database currently acts as the master or standby database. You need not even determine, which database is currently the master database.
You are connected to the cluster system.
You have the server permission InstallMgm.
hss_copyfile node=<source_component> name=<file_ID>
Option |
Description |
---|---|
<source_component> |
Computer, on which the file to be copied is located |
<file_ID> |
File ID of the file to be copied (see: Database Administration, Configuration Files or |
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB on the virtual server HOTEL_VIRTUAL, and copy the backup history with the file ID BACKHIST from the computer PARMA to the virtual server, which forwards it to the target database GENUA:
>dbmcli -u OLEG,MONDAY -d DEMODB -n HOTEL_VIRTUAL hss_execute GENUA hss_copyfile node=PARMA name=BACKHIST
OK
Database Administration, Hot Standby