All pages
Powered by GitBook
1 of 1

Loading...

Preparing Linux to backup Oracle

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

Oracle database backup involves generating a database dump using backup scripts and then backing up the resulting dump file.


Linux preparation process

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:

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

3

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

export ORACLE_SID=<database_ID>
export ORACLE_HOME=database_directory
export PATH=$ORACLE_HOME/bin:$PATH
echo 'connect target /; quit' | rman
echo 'SELECT INSTANCE_NAME FROM V$INSTANCE;' | sqlplus / as sysdba

The database_directory specifies the location of the Oracle database.

Example of correctly configured environment variables.