Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Oracle9iAS Backup and Recovery

Oracle have released a Perl untility to simplify backup and recovery of Oracle9iAS. This articles presents a summary of the information in the supporting document relating to installation and usage of the utility for an Oracle9iAS Infrastructure instance.

Download Software

The utlity itself and the supporting documentation can be downloaded from here.

If you are running Oracle9iAS on a Windows2000 server you will need to download Active Perl.

Unpack Files

First unzip the utility into the "$ORACLE_HOME/BackupTool" directory.

mkdir $ORACLE_HOME/BackupTool
cd $ORACLE_HOME/BackupTool
/usr/local/bin/unzip_cpq 9iAS_BR.zip
mv 9iAS_BR/* .
rmdir 9iAS_BR

A suitable unzip tool can be downloaded from info-zip.

Configuration

Create a backup directory with appropriate access rights.

su - root
mkdir /u04/backup
chmod 777 /u04/backup

As the Oracle user create the appropriate sub directories.

su - oracle
mkdir /u04/backup/log_files
mkdir /u04/backup/db_files
mkdir /u04/backup/config_files

Make the following amendments to the "config.inp" file.

Line 36: oracle_home=/u01/app/oracle/product/infrastructure
Line 41: log_path=/u04/backup/log_files
Line 56: config_backup_path=/u04/backup/config_files
Line 84: database_backup_path=/u04/backup/db_files

Make sure the "bkp_restore.pl" file is executable.

chmod u+x bkp_restore.pl

Finally, complete the configuration.

./bkp_restore.pl -m configure

Usage

To backup the configuration files issue the following command.

./bkp_restore.pl -v -m backup_config

For this utility to work correctly you must remove references to features that are not present in your installation. The files to be backed up are listed in the config_<feature>_files.inp files. Amend these files to prevent errors for features that are not installed, or remove whole files by removing them from the config_files_list parameter in the config.inp file.

During this example it was necessary to comment out all references to portal configuration files in the list_portal_files.inp and list_ultrasearch_files.inp files. In addition, all newline characters in the config_<feature>_files.inp files had to be replaced.

To perform hot and cold backups of the infrastructure repository issue the following commands.

./bkp_restore.pl -v -m backup_cold
./bkp_restore.pl -v -m backup_online

To restore the configuration files and database issue the following commands.

./bkp_restore.pl -v -m restore_config
./bkp_restore.pl -v -m restore_db

For middle tier nodes the process is the same with the exception of setting the database_backup_path parameter in the config.inp file.

Hope this helps. Regards Tim...

Back to the Top.