Preparing Linux to backup Oracle

This article describes how to prepare a Linux operating system for backing up an Oracle database environment.

Xopero ONE agent requires the availability of the rman and sqlplus tools. Before starting, ensure that these tools are installed and accessible.

1

Using the Linux command line, log in to the account used for backing up your Oracle database and execute the following commands:

echo 'connect target /; quit' | rman

echo 'SELECT INSTANCE_NAME FROM V$INSTANCE;' | sqlplus / as sysdba

2

If these tools are unavailable (example below) you need to configure the environment variables.

1. Edit the /home//.bash_profile file and add the following records:

export ORACLE_SID=<database_ID>

export ORACLE_HOME=database_directory

The database_directory specifies the location of the Oracle database.

export PATH=$ORACLE_HOME/bin:$PATH

Example of correctly configured environment variables.

1. Now, after logging in again, executing the following commands should complete successfully.

echo 'connect target /; quit' | rman

echo 'SELECT INSTANCE_NAME FROM V$INSTANCE;' | sqlplus / as sysdba

3

Once done, your Linux system should now be ready to backup an Oracle environment.