Show TOC

hss_copyfileLocate this document in the navigation structure

Use

All changes in the configuration sent to the virtual server are copied by the system to all databases of the hot standby system.

However, for support purposes it might become necessary to copy a database file to another database in the hot standby system 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.

To directly copy a file from another database, connect to the computer and the database where the file should be copied to (target computer and target database) and instruct this database to retrieve the file. Indicate at least the source computer and the file specification.

Prerequisites

  • You are connected to the hot standby system.

  • You have the server permission InstallMgm.

Structure

hss_copyfile [node=]<computer_name> [database=<database_name>] name=<file_ID>

Option

Description

<computer_name>

Computer name, IP address, or internal number <nnn> of the database computer ( nnn > 1) where the file should be copied from (source computer)

<database_name>

Name of the database the specified file should be copied from (source database)

<file_ID>

File ID of the file to be copied (see: Database Administration, Configuration Files or

Log Files)
Result

OK

In the event of errors, see Reply Format.

Example

For support purposes, you want to copy a database file from the master to the standby database. Use the hss_copyfile command and connect directly to the database on the standby node PARMA. Instruct this database to retrieve the backup history with the file ID BACKHIST from the master database (internal node number 1):

> dbmcli -d DEMODB -n PARMA -OLEG,MONDAY hss_copyfile node=1 BACKHIST

OK

More Information