Oracle 10, RMAN, TSM - missing arch logs backups

[PiotrBoetzel]

Hello,

I have an environment in which backup is performed of Oracle 10 databases with the use of RMAN and Tivoli Storage Manager (Data Protection for Oracle).
There are several databases and for every one there is a daily full backup and hourly archive logs backup.

Sometimes when full db backup takes longer (up to 4 hours) archive logs backups are missed - as TSM node cannot perform two backups at a time. I would like not to have those missed backups.

Option A was to delete association of the arch log scheduler during full backup. But when removing association we lose historical data about backup. And we need historical data to be able to create weekly / monthly / quarterly statistics of completed backups. We need to have 99% completed.

Option B was to create two nodes in TSM (TDPO) and one will do full backup only and another one only arch logs backup. So the problem is moved to RMAN.

But from RMAN specialist I heard that this may cause problems with full backup. During full backup also archive logs are backed up (at the start and end) so there might be a problem with accessing the file that is used by another process. And this may cause problem with full backup - which we want to avoid especially.

Do you find this reasoning correct? Do you have suggestions how this should be done properly?

Your help will be appreciated.

 

[moon-buddy]

You cannot do RMAN ARCH log backup when fulls are running. That has been and will always be the case. This is the same for MS-SQL.

The idea of two nodes, needless to say, is useless.

Write a script such that when the FULL is running, no ARCH log backups will be done. Thus, you will not see missed ARCH LOG backups.

 

[PiotrBoetzel]

Thanks.

But how to avoid missed arch logs backups then?

 

[moon-buddy]

Thanks.

But how to avoid missed arch logs backups then?

As I said, you can write a script so that ARCH logs are not done when the FULL backup is running. If you just have the schedule running on an hourly basis for the ARCH LOGS, and while the FULL is running, you will see missed backups. As is, you will really see missed ARCH LOG backups.

In my environment, I ignore these, or I can choose for the script to take care of this.

You really CANNOT run ARCH LOG backups when FULL backups are running.