backup error

[Former Member]

i got this problem can any one kindly tel me. get this problem when iam doing brbackup. first time i am using br tools.

BR0051I BRBACKUP 7.00 (32)

BR0055I Start of database backup: befiznup.aft 2011-03-03 23.18.35

BR0484I BRBACKUP log file: D:\oracle\DD1\sapbackup\befiznup.aft

BR0477I Oracle pfile D:\oracle\DD1\102\database\initDD1.ora created from spfile D:\oracle\DD1\102\database\spfileDD1.ora

BR0613I Database instance DD1 is shut down

BR0329I Database instance DD1 will be opened now

BR0280I BRBACKUP time stamp: 2011-03-03 23.18.35

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:

BR0280I BRBACKUP time stamp: 2011-03-03 23.19.04

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2011-03-03 23.19.04

BR0304I Starting and opening database instance DD1 ...

BR0280I BRBACKUP time stamp: 2011-03-03 23.19.47

BR0305I Start and open of database instance DD1 successful

BR0280I BRBACKUP time stamp: 2011-03-03 23.19.47

BR0301E SQL error -28009 at location BrDbConnect-2, SQL statement:

'CONNECT sys/********'

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

BR0310E Connect to database instance DD1 failed

BR0280I BRBACKUP time stamp: 2011-03-03 23.19.47

BR0301E SQL error -28009 at location BrDbConnect-2, SQL statement:

'CONNECT sys/********'

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

BR0310E Connect to database instance DD1 failed

BR0280I BRBACKUP time stamp: 2011-03-03 23.19.47

BR0307I Shutting down database instance DD1 ...

BR0280I BRBACKUP time stamp: 2011-03-03 23.20.16

BR0308I Shutdown of database instance DD1 successful

BR0056I End of database backup: befiznup.aft 2011-03-03 23.19.47

BR0280I BRBACKUP time stamp: 2011-03-03 23.20.16

BR0054I BRBACKUP terminated with errors

[Former Member]

Did you try to login with <sid>adm and execute the backup?

[former_member182034]

Dear AH,

please try following command and then run brbackup.

sqlplus /nolog @sapdba_role.sql

or

SQL> grant DBA to OPS$<SID>ADM;

SQL> select granted_role from dba_role_privs where grantee = 'OPS$<SID>ADM';

Regards,

[former_member182313]

I don't know if you run brtools, and then pick backup from the menu or execute brbackup directly.

The error implies that you need to specify "sys/password as sysdba". You can avoid entering sys/<password> altogether by entering just "/".

If run brbackup from command:

brbackup -u / -c -d ........

If you run brtools, then you would see option for "user"(I believe 3rd item). Enter "/" (no quotes) and kick off backup.

Bala