cancel
Showing results for 
Search instead for 
Did you mean: 

online database backup error

Former Member
0 Kudos

Hi All,

I am taking online backup of SAP oracle database.I have configured BRTools backup configurtion to  local SAN disk.I have made the archivelog backup successfull,but while triggering for online backup am facing below issues.Please let me know any solutions.

BR0051I BRBACKUP 7.20 (23)

BR0055I Start of database backup: bekhiqbz.and 2013-01-10 14.12.51

BR0484I BRBACKUP log file: /oracle/XXX/sapbackup/bekhiqbz.and

BR0477I Oracle pfile /oracle/XXX/112_64/dbs/initXXX.ora created from spfile /oracle/CBD/112_64/dbs/spfilexxx.ora

BR0280I BRBACKUP time stamp: 2013-01-10 14.12.53

BR0301W SQL error -1031 at location saplikey_read-1, SQL statement:

'OPEN curs_122 CURSOR FOR'

'SELECT SELECT LIKEY, VALUE FROM SAP_SAPLIKEY ORDER BY LIKEY'

ORA-01031: insufficient privileges

BR1301W Error message from likeywlib: 96 likey_init: Couldn't get the list of all records from the persistence.

BR1302W Initialization of license key library likeywlib failed, return code 1

BR1304W Checking SAP license failed at location BrLicCheck-122

BR0602W No valid SAP license found - please contact SAP

The solution i got for the above is there is a license problem and i got the SAP note 912969(BR*Tools 7.00 fails due to license problems)

BR0280I BRBACKUP time stamp: 2013-01-10 14.12.54

BR0319I Control file copy created: /oracle/XXX/sapbackup/cntrlxxx.dbf 29114368

BR0280I BRBACKUP time stamp: 2013-01-10 14.12.55

BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:

'PREPARE stmt_1 FROM'

'SELECT TABSPACE FROM "SAPXXX".TSORA UNION SELECT INDSPACE FROM "SAPxxx".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

BR0056I End of database backup: bekhiqbz.and 2013-01-10 14.12.55

BR0280I BRBACKUP time stamp: 2013-01-10 14.12.55

BR0054I BRBACKUP terminated with errors

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

From which User you are trying to take backup through BRTOOLS

Use ORA<SID> not <SID>ADM

http://scn.sap.com/thread/1807483

Former Member
0 Kudos

Hi ,

I have done via ORA <sid> and folowed the sap note 113747 too.Still am facing the issue

Regards

Ram

Former Member
0 Kudos

check note 912969

In log license issue is showing

BR0301W SQL error -1031 at location saplikey_read-1, SQL statement:

'OPEN curs_122 CURSOR FOR'

'SELECT SELECT LIKEY, VALUE FROM SAP_SAPLIKEY ORDER BY LIKEY'

Former Member
0 Kudos

Hi Shahnas,

I followed that note and inported sapdba role as per case 2.

Case 2:

Import the SAPDBA role (Version 7.00) in accordance with Note 134592. To do this, use the script sapdba_role.sql from the attachment sapdba_role_ora10.SAR provided in this note

I have done this and my database is 11gr2 and imported the spadba role for 11g too..stsill issue persisting

Regards

Ram

Former Member
0 Kudos

Caution 1:

----------

On Unix systems, you must also set the

environment variable DIR_LIBRARY  to the directory that contains the

libsapsecu library, for example:

DIR_LIBRARY = /usr/sap/<SID>/SYS/exe/run

or

DIR_LIBRARY = /usr/sap/<SID>/SYS/exe/uc|nuc/<platform>

This

is especially important if you use an external scheduler (cron, at  or

BACKINT scheduler) to start BR*Tools. In that case, this variable  must

be set in the environment of this scheduler (for example, in an

environment file).

The same applies to the environment variable SAPSYSTEMNAME.

It  must always be set if the SAP SID differs from the Oracle SID. In 

addition, it often has the incorrect value after a system copy. In 

particular, this applies to the environment of the user ora<sid>

and of an external scheduler.

Caution 2:

----------

If you

still operate an older level of the SAP kernel, it is often  necessary

to exchange the libsapsecu.so. The most recent versions of the

libsapsecu.so are available on SAP Service Marketplace.

For more information about downloading patches, see Notes 12741 and 19466.

Former Member
0 Kudos

Hi Shahnas,

SAPSYSTEMNAME,DIR_LIBRARY,LD_LIBRARY_PATH,dbms_type,dbs_ora_tnsname,dbs_ora_schema

are same in ORASID ,SIDADM

DIR_LIBRARY is  already set properly and SAPSYSTEM NAME too is fine

The kernel version is 201.

still am facing issues

Regards

Ram

Former Member
0 Kudos

Hi,

Can you please try this.

grant SELECT on SAPPBW.TSORA to sapdba;

Please check and provide your feedback.

Thanks and Regards,

Vimal


Former Member
0 Kudos

Hi Maria Joseph Vimalan,

Now the online database backup is running fine after granting sapdba to SAPPBW.TSORA.

Thanks for valuable answer

Many thanks for everone for giving good support

Regards

Ram

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi All,

Let me know if anyone can give me any help on this below one:

BR0280I BRBACKUP time stamp: 2013-01-10 14.12.54

BR0319I Control file copy created: /oracle/XXX/sapbackup/cntrlxxx.dbf 29114368

BR0280I BRBACKUP time stamp: 2013-01-10 14.12.55

BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:

'PREPARE stmt_1 FROM'

'SELECT TABSPACE FROM "SAPXXX".TSORA UNION SELECT INDSPACE FROM "SAPxxx".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

Regards

Ram

divyanshu_srivastava3
Active Contributor
0 Kudos

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

Set correct permission of exe....

former_member185239
Active Contributor
0 Kudos

Hi Ram,

Note 91216 - BRBACKUP/SAPDBA: ORA-01031 Insufficient privileges

you can also assign the role sapdba and sysoper role to sapsr3 user.

Logon as ;

1. sqlplus /nolog

2. connect / as sysdba

3. grant sysdba ,sysoper to sapsr3;

then try the backup.

With regards

Ashutosh Chaturvedi

Former Member
0 Kudos

Hi All,

The workaround we have done is we have granted sapdba role, sapconn role to SAPPBW( SAP schema name).I have followed above SAP notes and followed the instructions appropriately, but the online backup is failing at the below these 2 issues .


I have installed new licenses to the system. But still issue persists

BR0301W SQL error -1031 at location saplikey_read-1, SQL statement:
'OPEN curs_122 CURSOR FOR'
'SELECT SELECT LIKEY, VALUE FROM SAP_SAPLIKEY ORDER BY LIKEY'
ORA-01031: insufficient privileges
BR1301W Error message from likeywlib: 96 likey_init: Couldn't get the list of all records from the persistence.
BR1302W Initialization of license key library likeywlib failed, return code 1
BR1304W Checking SAP license failed at location BrLicCheck-122
BR0602W No valid SAP license found - please contact SAP

BR0280I BRBACKUP time stamp: 2013-01-11 05.52.16
BR0319I Control file copy created: /oracle/CBD/sapbackup/cntrlCBD.dbf 29114368
BR0280I BRBACKUP time stamp: 2013-01-11 05.52.17
BR0301E SQL error -1031 at location BrSapTspList-8, SQL statement:
'PREPARE stmt_1 FROM'
'SELECT TABSPACE FROM "SAPPBW".TSORA UNION SELECT INDSPACE FROM "SAPPBW".TSORA ORDER BY 1'
ORA-01031: insufficient privileges

Can anyone provide  further inputs to us as we are stuck in triggering the online backup

Regards

Ram

Former Member
0 Kudos

Hi ,

Hope i have given the role sapdba and sapconn as the below SQL query has given the confirmation

select grantee, granted_role, default_role from dba_role_privs where grantee = 'SAPPBW';

GRANTEE                        GRANTED_ROLE                   DEF
------------------------------ ------------------------------ ---
SAPPBW                         DBA                            YES
SAPPBW                         SAPDBA                         YES
SAPPBW                         CONNECT                        YES
SAPPBW                         SAPCONN                        YES
SAPPBW                         RESOURCE                       YES
SAPPBW                         SELECT_CATALOG_ROLE            YES

Regards

Ram

former_member185239
Active Contributor
0 Kudos

Hi Ram,

Grant the same roles to SYSTEM user sapdba and sysoper and sysdba privileges as well

With Regards

Ashutosh Chaturevdi