Backup and redo log back up works only with BRTOOLS

[Former Member]

Hi!

I am facing with the problem that the backup (online) and redo log backups work only with BRTOOLS commandos (brbackup -f , brarchive -f).

When I schedule the actions from SAP system via tcode DB13, the actions do not work and I get the following errors:

BR0002I BRARCHIVE 7.00 (38)

BR0006I Start of offline redo log processing: aeafgyzd.svd 2009-03-26 13.25.17

BR0484I BRARCHIVE log file: F:oracleSC3saparchaeafgyzd.svd

BR0280I BRARCHIVE time stamp: 2009-03-26 13.25.18

BR0301W SQL error -1012 at location BrDbConnect-5, SQL statement:

'SELECT NAME, NVL(RESETLOGS_CHANGE#, 0), NVL(TO_NUMBER(TO_CHAR(RESETLOGS_TIME, 'YYYYMMDDHH24MISS')), 0), NVL(TO_NUMBER(TO_CHAR(CREATED, 'YYYYMMDDHH24MISS')), 0) FROM V$DATABASE WHERE ROWNUM = 1'

ORA-01012: not logged on

Any helpful information will be very appreciated!

regards

Jürgen

[Former Member · Accepted solution]

Hello Jürgen,

The difference is the following:

-> When you just call brarchive -f without any further options, then the user system with the

default password will be used

-> When you use DB13 then the default call will be brarchive -u / ... which means that you will logon as

OPS$ user

I would now think of a problem with the OPS$ connect. Does it work when you call sqlplus /@adm or do you get an error here?

Best Regards,

Michael

[Former Member · Accepted solution]

Hi!

many thanks for your response!

The commando >sqlplus /nolog with adm is working fine.

When I execute >sqlplus @<SID> as <SID>adm following happen:

SP2-0310: unable to open file "SC3.sql"

Enter user-name:

adm

ERROR:

ORA-01017: invalid username/password: logon denied

Any ideas how to proceed?

Thank you!

regards

Jürgen

[Former Member · Accepted solution]

Hi,

Login to windows as <sid>adm and then try following

Start->run->cmd

sqlplus "/as sysdba"

Hope this work for you.

Manoj

[Former Member · Accepted solution]

As for Micheal's suggestion: sqlplus /@<SID>

you missed the /

[Former Member · Accepted solution]

Hi,

You may also try like this

Open Command prompt

sqlplus /nolog

SQL> connect /@<SID>

SQL> exit

or

sqlplus /nolog

SQL> connect /@<SID> as sysdba

SQL. exit.

or

sqlplus "/@<SID> as sysdba"

Thakns

Manoj

[Former Member]

hi,

execute sapdba_role.sql.

Check SAP note 134592

regards,

sachin Rane.