archive log backup fails in brtools

[Former Member]

Hi, I have latest BRTOOLS PATCH, and I use BRTOOLS STUDIO.

I NEED TO DO A ARCHIVELOG BACKUP IN MY SOLUTION MANAGER SYSTEM.

I log on on brtools studio with sapsr3 user, with same privileges as these sap notes.

Note 134592 - Importing the SAPDBA role (sapdba_role.sql)

Note 834917 - Oracle Database 10g: New database role SAPCONN

Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

1. click in avaibility

2. click in Archivelog

3. click in execute

4. in function = save or save_deleted(at the end, the same mistake)

5. in device= disk

6. in number i left blank

7- click in next

8. compresion = yes or no(at the end, the same mistake)

9. verify = no

10.fill mode = no

11.In modify and delay, I choose the 3 option(at the end, the same mistake)

12.Confirm

13.Back up.

here the job begin and some minutes or seconds later the job finish.. the only log that i can see is this:

ERROR 2009/11/21 01:13:38 [Tools] Instance QAS_SAPSR3_USER reports failure while running job Archivelog Backup:

BR0002I BRARCHIVE 7.00 (44)

BR0156E Illegal value 'delay' found for option '-modify'

BR0007I End of offline redo log processing: aebypmny.log 2009-11-21 01.13.38

BR0280I BRARCHIVE time stamp: 2009-11-21 01.13.38

BR0005I BRARCHIVE terminated with errors

if i search for aebypmny.log, i found nothing.

below if i choose modify no then it says:

Illegal value 'no' found for option'-modify' or if i choose yes it says:

Illegal value 'yes' found for option '-modify'

Then my question. how can i perform this archilog backup in brtools studio???

[peter_dzurov · Accepted solution]

Hi,

obviously options -modify <delay> is causing this error.

Please check [THIS|http://help.sap.com/saphelp_nw04/helpdata/EN/0d/d30d064a0c11d182b80000e829fbfe/content.htm] link and note that you should use number (how many minutes) after options -m or -modify (Do you want to use this option? Do you have standby DB?).

[Former Member]

Hello, in first my post. i wite this:

below if i choose modify no then it says:
Illegal value 'no' found for option'-modify' or if i choose yes it says:
Illegal value 'yes' found for option '-modify'

then that is not the problem. thaks anyway

[markus_doehr2]

Manfred,

the value after delay is a NUMBER not, 'yes' or 'no'.

Markus

[Former Member]

Thanks markus,

But then, is it a bug in brtools studio??, because it only show 3 options for modify and delay: no, yes and delay

And another question markus

why in avaibility option i can´t select this options | Restore | Recovery | Disaster Recovery???, I only can select Copy | Backup

I do a offline and online backup. but options for revorey are unavailable.

[markus_doehr2]

But then, is it a bug in brtools studio??, because it only show 3 options for modify and delay: no, yes and delay

That option should be only active if you have a standby database, do you have one?

And another question markus

why in avaibility option i can´t select this options | Restore | Recovery | Disaster Recovery???, I only can select Copy | Backup

I do a offline and online backup. but options for revorey are unavailable.

Is a standby database active?

Makrus

[Former Member]

Markus I don't know if i have a standby database. I guess that i don't have stanby database.

This because i just install my SOLMAN 7 with oracle database in windows server 2003, then I patch my database to 10.2.4 and I don't know how to set up a standby database.

How can I verify if i have standby db?

[peter_dzurov]

How does it look like in step 11.In modify and delay, I choose the 3 option(at the end, the same mistake)

[Former Member]

Thanks for answer and sorry for delay.

It looks like

[http://img26.imageshack.us/img26/73/brtoolsbug.jpg]

EDIT:

has anyone a new idea for my problem?

Thanks in advance

Edited by: Manfred Kaufmann on Dec 1, 2009 5:02 AM

[peter_dzurov]

Is there a possibility to paste whole log or do you have only that error message posted above?

[Former Member]

Hi, thanks for your answer

Only posted log before.

ERROR 2009/11/21 01:13:38 Tools Instance QAS_SAPSR3_USER reports failure while running job Archivelog Backup:
BR0002I BRARCHIVE 7.00 (44)
BR0156E Illegal value 'delay' found for option '-modify'
BR0007I End of offline redo log processing: aebypmny.log 2009-11-21 01.13.38
BR0280I BRARCHIVE time stamp: 2009-11-21 01.13.38
BR0005I BRARCHIVE terminated with errors
if i search for aebypmny.log, i found nothing.

are this issue related to this problem?

.

 why in avaibility option i can´t select this options | Restore | Recovery | Disaster Recovery???, I only can select Copy | Backup
I do a offline and online backup. but options for revorey are unavailable..