We use HDR over a WAN. I will be backing up the databases and transaction
logs from the secondary servers on to a disk array. Are there any issues
with backing up databases or logs on the secondary while the primary is
still up ? Could a situation arise as follows :

a. I use ontape to do a dump at a specific time
b. The primary sends over a log which needs to be applied at the same time.

Will this cause any conflicts ?

TIA,
Jack

If I understand your question correctly, you should be fine. The logs
on the HDR secondary are applied at a specific time, and the secondary
does an archive checkpoint right before backing-up. I don't see a
conflict.

Brice Avila
Minneapolis, Minnesota

"Jack A" <jacka8@excite.com> wrote in message news:<91cb58f7e07d3da172223d59d040eaf0@news.terane ws.com>...
> We use HDR over a WAN. I will be backing up the databases and transaction
> logs from the secondary servers on to a disk array. Are there any issues
> with backing up databases or logs on the secondary while the primary is
> still up ? Could a situation arise as follows :
>
> a. I use ontape to do a dump at a specific time
> b. The primary sends over a log which needs to be applied at the same time.
>
> Will this cause any conflicts ?
>
> TIA,
> Jack

Brice Avila wrote:
> If I understand your question correctly, you should be fine. The logs
> on the HDR secondary are applied at a specific time, and the secondary
> does an archive checkpoint right before backing-up. I don't see a
> conflict.
>
> Brice Avila
> Minneapolis, Minnesota
>
> "Jack A" <jacka8@excite.com> wrote in message news:<91cb58f7e07d3da172223d59d040eaf0@news.terane ws.com>...
>
>>We use HDR over a WAN. I will be backing up the databases and transaction
>>logs from the secondary servers on to a disk array. Are there any issues
>>with backing up databases or logs on the secondary while the primary is
>>still up ? Could a situation arise as follows :
>>
>>a. I use ontape to do a dump at a specific time
>>b. The primary sends over a log which needs to be applied at the same time.
>>
>>Will this cause any conflicts ?
>>
>>TIA,
>>Jack
There are two problems I can see ...

1. If you back up your logs on your primary they will be marked as
backed up on the secondary, therefore unable to be backed up.

2. If you try and back up an "un-backed up" logical log on the secondary
you get :

start_sec > ontape -a

Performing automatic backup of logical logs.

Please mount tape 1 on /ltapedev and press Return to continue ...

Logbackup failed - buc_fe.c : Archive API processing failed at line 502
for rc

This tape contains no log data

Program over.

So, I would say you can't do it