Show TOC

Backup to a Remote Tape DeviceLocate this document in the navigation structure

Use

With BRBACKUP and BRARCHIVE you can back up files of the Oracle database located on a UNIX system to a remote tape device that is connected to a UNIX host in the network. You can use several tape devices on the remote host for backup and these are used in parallel.

The UNIX versions of the local and remote hosts need not be identical. For example, if the database runs on an HP-UX host, you can perform the backup on an AIX host.

Backup to a remote tape device is not supported for remote hosts running a Windows operating system.

Recommendation

We only recommend remote backup when your network is very fast and stable. Therefore, we do not recommend this procedure for production systems in most cases. However, you can use it to back up test systems.

Prerequisites

  • Make sure that no additional messages (that is, not belonging to command output) are issued on remote login (for example, from or .cshrc). Test the command remsh|rsh <host_name> date. Only one line with the output of the date command should be displayed.

  • For a successful remote shell call, check that there is an entry as follows in the . rhosts file, which is located in the HOME directory of the remote operating system user on the remote host:

    <local_host_name> <local_user_name>

    where:

    <local_host_name> is the host where the database runs

    <local_user_name> is the operating system user who starts the backup

For more information, see your operating system documentation.

Activities

The individual database files are transferred to the remote host using a remote or secure shell call, called a “pipe”. You define the remote host with the init<DBSID>.sap parameter remote_host and the user with the remote_user parameter. You define the shell to be used for data transfer to the remote host in the init<DBSID>.sap parameter pipe_copy_cmd.

On the remote host the files are written to tape using the UNIX dd command. You define the dd command in the profile init<DBSID>.sap, as in the following example:

Example

copy_out_cmd = "dd bs=64k of=$"

copy_in_cmd = "dd bs=64k if=$"

The number of parallel copy processes normally corresponds to the number of backup devices available. You can change this setting with the init<DBSID>.sap parameter exec_parallel or the command option -e|-execute.

More Information