on 2011 Mar 03 6:15 PM
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
Did you try to login with <sid>adm and execute the backup?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
10 | |
10 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.