Show TOC

Function documentationBackup to a Remote Disk Locate this document in the navigation structure

 

You can perform an Oracle backup to a remote disk directly with BRBACKUP or BRARCHIVE, or as part of an incremental backup using the Oracle Recovery Manager (RMAN).

Recommendation 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.

End of the recommendation.

Prerequisites

  • The target directories for the backup defined in the parameter stage_root_dir and archive_stage_dir must exist on the remote host.

  • The name of the remote host and the relevant user must be specified in the initialization profile with the parameters remote_host and remote_user.

  • If you use FTP as the transmission program, a password is needed for the remote host. Do one of the following for this:

    • Specify the password in the remote_user parameter.

      remote_user = "<user_name> <password>"

    • Let BRBACKUP use the password of the database user, which happens if you do not explicitly specify a password in the remote_user parameter. Make sure that the password of the operating system user is the same. However, to achieve this, you must enter the password in the option -u. It is not possible to use the OPS$ mechanism.

  • No password is needed if you use the RCP command for the remote disk backup. A prerequisite for a successful RCP call is, for example, the following entry in the .rhosts file, which is located in the HOME directory of the remote user on the remote host:

    <host_name> <user_name>

    For more information, see your operating system documentation.

Features

Remote Disk Backup with BRBACKUP

A remote disk backup removes the need for a Network File System (NFS) disk mount, if the backup is across the network. The NFS protocol is relatively insecure, which means that the backup must be verified. In contrast, RCP and FTP are relatively secure ways of transferring data over the network, which means that you do not have to verify the backup (but you can still if you want).

You need to meet the prerequisites above and make the following entries in the initialization profile init<DBSID>.sap:

backup_dev_type = stage|stage_copy|stage_standby stage_copy_cmd = rcp|ftp|scp

This graphic is explained in the accompanying text.

A remote backup to disk is particularly useful with the standby database and hierarchical storage management systems.

Incremental Remote Backup with RMAN

You can use RMAN to perform an incremental disk backup on a remote host.

You need to meet the prerequisites above and make the following entries in the initialization profile init<DBSID>.sap:

backup_dev_type = stage

backup_mode = incr

You must have the SAP backup library installed on your system.

FTP is always used automatically as the transmission program for incremental backup to remote disk.

This graphic is explained in the accompanying text.