Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Oracle database online/offline backups with brtool failing with error

Dear All,

I'm scheduling oracle online/offline backup using brtools.

It's throwing error message "SQL error -1031 at location in BrSapTspGet-8, SQL Statement :

'PREPARE stmt_1 FROM' 'SELECT TABSPACE FROM "SAPSLM".TSORA UNION SELECT INDSPACE FROM "SAPSLM".TSORA ORDER BY 1'

ORA-01031: insufficient privileges

I've performed stack12 upgrade on solman 7.1. After successful completion of upgrade, I'm taking database backup as post steps. This issue is coming.

Kindly see the screenshot for more info.

Note: Archive log backup with BRtools is working fine.




Thanks & Regards


Venkatesh P

Former Member
replied

This has been discussed before. Have you thought of executing the sapdba_role.sql script?

134592 - Import of SAPDBA role (sapdba_role.sql)

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question