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