Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 

Application Server 10g Backup and Recovery Tool

Oracle Tips by Burleson Consulting
Oct 6,  2004
John Garmany

When Oracle released Application Server 10g, if provided a backup tool that has gotten little press.  In the Oracle Press book, Oracle Application Server 10g Administration Handbook I only mentioned the tool but did not discuss how to use it.  That was because I was working on the AS10g Beta and didn't have it to test.  Well now it is out and I'm a convert!  You can even reinstall an infrastructure on another server and restore your backup over it to recreate a failed infrastructure. COOL!

The Backup and Recovery Tool is actually a Perl script that backs up all of the configuration files for a tier.  If the tier is an infrastructure tier and contains a metadata repository database, it will back that up also. 

Configuration files are static and you can perform a hot backup of any tier while it is running.  The only time they change is when you change the configuration (deploy an app, change a container, etc).  For this reason, you only need to take a new backup when you make changes, although most all my clients take night backups.  The problem is the database.  If you do not have the skills to script a hot backup, you must shutdown the database, which requires that you so shut down the application server. 

Enter the Backup and Recovery Tool.

The tool is located on the AS10g REPCA and Utilities disk. Look in the utilities directory under backup.  Copy the tar file into a directory in the instance ORACLE_HOME.  In Unix untar the file or unzip it in Windows.

I placed mine in the ORACLE_HOME/backup_restore directory.  The first step is to update the configuration file. Change to the config directory and edit the config.inp file.  Use a text editor such as TextPad in windows to insure that extra CR's are not placed at the end of each line.  All you need to change is:

1.  The ORACLE_HOME for that instance.
2.  The directory to write out the script's log file.
3.  The directory to back the configuration file to.
If you are backing up the Infrastructure:
4.  The directory to backup the database to.

Make sure you instance environment is set and run the configuration script.

$ bkp_restore.pl -m configure

You may have to fully qualify the Perl interpreter as below.

c:\oracle\infra904\perl\5.6.1\bin\
MSWin32-x86\perl.exe bkp_restore.pl -m       configure

This script examines your instance and adds parameters to the config.inp.

Now backup the instance configuration:

$ bkp_restore.pl -v -m backup_config

The -v provides a verbose listing of the files as they backup.  All of the configuration files will be backed up to the location you defined.  If any errors are encountered, they will be logged in the log directory you defined in the config.inp.

Now backup the database.

$ bkp_restore.pl -v -m backup_online

The script will use RMAN to create a hot backup of the metadata repository.  If you don't know RMAN there are a number of good books that explain it.  If you need to restore the database, you can use the tool or startup RMAN and manually restore. 

Planning Considerations

1.  Each backup creates a file with the date in the file name.  You can restore to a specific date by specifying a file to restore from.

2.  If you run the tool daily then you will need to add to your log purge script a command to purge old backups.

3.  The database is backed up using RMAN.  You need to learn RMAN to insure that you can recover the database and maintain your backups.  RMAN can determine which logs and backups are no longer needed, etc but YOU have to manage it.  The tool also supports incremental database backups.

4.  The tool must be configure and run for each instance on a server.

5.  If your metadata repository is installed in a back-end database, you cannot use the Backup and Recovery Tool to back up the database.  You can still use the tool to back up the configuration files for the infrastructure and you can separately use RMAN (or a script) to backup the database.

This just scratches the surface of the tool's capabilities.  You can modify the script to include you application created files in the backup, etc.  Read the documentation before trying to implement the Backup and Recovery Tool.

 

 
Get the Complete
Oracle SQL Tuning Information 

The landmark book "Advanced Oracle SQL Tuning  The Definitive Reference"  is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational