cancel
Showing results for 
Search instead for 
Did you mean: 

General database backup error troubleshooting

Michael_G_Ander
Level 6
Certified

When troubleshooting database backups, it is important to remember that a database backup is in principle an user initiated backup,
so the backup is actually started from the client by the script/database backup api.

The database backup is more sensitive to name resolution than file backup, partly because of the above

 

 

Places to look for information/things to do:

The activity monitor, probably where you would see the error first.

Talk with your DBA <- This is a very very important step!!

The bphdb log folder which gives the script exit status, environment information and other things there can help figure out what the issue is.

The dbclient log folder with 777 permission which gives detailed information about the backup done by the database api e.g. rman

The database api's log e.g. rman messagelog

The database's log e.g the alert log for Oracle

The OS system logs, but often this a copy of the messages from the database's logs

If none of this gives an indication of the problem run the script from a prompt if possible, as this might give an output not catched by any of the logs
In case of layered scripts like Oracle, first run the cmd/shell script as administrator/root,
then run the rman script as administrator/oracle user

Sometimes it is necessary to run the scripts one line of time to catch the error

In my experience this approach enables you to find most of the issues with the database backups

 

 

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue
0 REPLIES 0