cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Database online backup issue after ERP 6.0 EHP4 update

Former Member

on ‎07-11-2009 7:58 AM

0 Kudos

Dear Folks!...

I have an issue with ERP 6.0 system with database oracle.

After performing EHP4 update unable to trigger online backup.

Shows bellow error message:

-

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.10

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

'PREPARE stmt_1 STATEMENT FROM'

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

ORA-01031: insufficient privileges

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.10

BR0307I Shutting down database instance RES ...

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.17

BR0308I Shutdown of database instance RES successful

BR0056I End of database backup: beazhkrz.afd 2009-07-10 14.53.10

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.17

BR0054I BRBACKUP terminated with errors

-

At SAP level check with table TSORA shows current existing tablespaces.And from DB13 able to perform DB actions except backup related.

Could any one suggest to help me to fix the issue.

Thanks in Advance.

Regards,

Venkata.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎07-30-2009 7:35 PM
0 Kudos

Hello Folks

I have fixed the issue as early when i have executed sapdba_role.sql i found in sapdba_role.log that few tables are missing SAPSR3 owner role and further granted roles to the tables which are missing, by that my issue has been solved.

For solution see the forum which i have replied init:

Special thanks to Sunny Pahuja for reminding me to recheck regarding the roles.

Best Regards,

Venkata.

Show replies
Show replies
Former Member
‎07-11-2009 9:02 AM
0 Kudos

Dear presu

It has been installed on Windows OS 64 bit AMD processor.And related to permissions of the folder was given completely.

Complete log Message:

BR0051I BRBACKUP 7.00 (39) BR0055I Start of database backup: beazhkrz.afd 2009-07-10 14.52.43

BR0484I BRBACKUP log file: G:\oracle\RES\sapbackup\beazhkrz.afd

BR0477I Oracle pfile G:\oracle\RES\102\database\initRES.ora created from spfile G:\oracle\RES\102\database\spfileRES.ora

BR0613I Database instance RES is shut down BR0329I Database instance RES will be opened now BR0280I BRBACKUP time stamp: 2009-07-10 14.52.45 BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP: BR0280I BRBACKUP time stamp: 2009-07-10 14.52.49 BR0257I Your reply: 'c' BR0259I Program execution will be continued...

BR0280I BRBACKUP time stamp: 2009-07-10 14.52.49 BR0304I Starting and opening database instance RES ...

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.01 BR0305I Start and open of database instance RES successful

BR0101I Parameters

Name Value

oracle_sid RES

oracle_home G:\oracle\RES\102

oracle_profile G:\oracle\RES\102\database\initRES.ora

sapdata_home G:\oracle\RES

sap_profile G:\oracle\RES\102\database\initRES.sap

backup_mode ALL

backup_type offline

backup_dev_type disk

backup_root_dir Y:\Backup

compress no

disk_copy_cmd copy

cpio_disk_flags -pdcu

exec_parallel 0

system_info resadm RCIHWRES13V Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info RES 10.2.0.4.0 8192 8188 87296881 RCIHWRES13V UTF8 UTF8

sap_info 701 SAPSR3 RES TEMPLICENSE R3_ORA INITIAL

make_info NTAMD64 OCI_10201_SHARE Dec 7 2008

command_line G:\usr\sap\RES\DVEBMGS13\exe\brbackup.exe -p initRES.sap -d disk -t offline -m all -k no -e 0 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance RES

Parameter Value

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination M:\oracle\RES\oraarch\RESarch

Archive format ARC%S_%R.%T

Oldest online log sequence 8185

Next log sequence to archive 8188

Current log sequence 8188 SCN: 87296881

Database block size 8192 Thread: 1

Current system change number 87304439 ResetId: 689356796

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\RES\SAPDATA1\SR3_1\SR3.DATA1 2222989312 4 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_21\SR3.DATA21 2097160192 48 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_22\SR3.DATA22 2097160192 49 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_23\SR3.DATA23 2097160192 50 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_24\SR3.DATA24 2097160192 58 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_25\SR3.DATA25 2097160192 59 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_26\SR3.DATA26 2097160192 60 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_27\SR3.DATA27 2097160192 61 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_28\SR3.DATA28 2097160192 62 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_29\SR3.DATA29 2097160192 63 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE+ H:\ORACLE\RES\SAPDATA1\SR3_2\SR3.DATA2 2243960832 5 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3_30\SR3.DATA30 2097160192 64 7 NOLINK FILE 0 0 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\RES\SAPDATA2\SR3_8\SR3.DATA8 2139103232 11 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ I:\ORACLE\RES\SAPDATA2\SR3_9\SR3.DATA9 2432704512 12 8 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ J:\ORACLE\RES\SAPDATA3\SR3_11\SR3.DATA11 2264932352 14 9 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ K:\ORACLE\RES\SAPDATA4\SR3_18\SR3.DATA18 2181046272 21 10 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ K:\ORACLE\RES\SAPDATA4\SR3_19\SR3.DATA19 2181046272 22 10 NOLINK FILE 10485760000 20971520 8192

PSAPSR3 ONLINE* ONLINE+ K:\ORACLE\RES\SAPDATA4\SR3_20\SR3.DATA20 2202017792 23 10 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE+ ONLINE+ H:\ORACLE\RES\SAPDATA1\SR3700_1\SR3700.DATA1 2705334272 24 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE+ ONLINE+ H:\ORACLE\RES\SAPDATA1\SR3700_2\SR3700.DATA2 2705334272 25 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE+ ONLINE+ H:\ORACLE\RES\SAPDATA1\SR3700_3\SR3700.DATA3 2747277312 26 7 NOLINK FILE 10485760000 20971520 8192

PSAPSR3700 ONLINE+ ONLINE I:\ORACLE\RES\SAPDATA2\SR3700_20\SR3700.DATA20 2147491840 54 8 NOLINK FILE 0 0 8192

PSAPSR3700 ONLINE+ ONLINE J:\ORACLE\RES\SAPDATA3\SR3700_21\SR3700.DATA21 2147491840 55 9 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3701_11\SR3701.DATA11 2097160192 72 7 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE H:\ORACLE\RES\SAPDATA1\SR3701_12\SR3701.DATA12 2097160192 73 7 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE I:\ORACLE\RES\SAPDATA2\SR3701_10\SR3701.DATA10 2097160192 71 8 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE I:\ORACLE\RES\SAPDATA2\SR3701_5\SR3701.DATA5 2097160192 66 8 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE I:\ORACLE\RES\SAPDATA2\SR3701_6\SR3701.DATA6 2097160192 67 8 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE I:\ORACLE\RES\SAPDATA2\SR3701_7\SR3701.DATA7 2097160192 68 8 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE I:\ORACLE\RES\SAPDATA2\SR3701_8\SR3701.DATA8 2097160192 69 8 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE I:\ORACLE\RES\SAPDATA2\SR3701_9\SR3701.DATA9 2097160192 70 8 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE K:\ORACLE\RES\SAPDATA4\SR3701_1\SR3701.DATA1 20971528192 44 10 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE L:\ORACLE\RES\SAPDATA5\SR3701_2\SR3701.DATA2 20971528192 45 11 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE L:\ORACLE\RES\SAPDATA5\SR3701_3\SR3701.DATA3 20971528192 46 11 NOLINK FILE 0 0 8192

PSAPSR3701 ONLINE* ONLINE L:\ORACLE\RES\SAPDATA5\SR3701_4\SR3701.DATA4 10485768192 47 11 NOLINK FILE 0 0 8192

PSAPSR3DB ONLINE* ONLINE+ K:\ORACLE\RES\SAPDATA4\SR3DB_1\SR3DB.DATA1 2097160192 41 10 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ K:\ORACLE\RES\SAPDATA4\SR3DB_2\SR3DB.DATA2 2097160192 42 10 NOLINK FILE 10485760000 20971520 8192

PSAPSR3DB ONLINE* ONLINE+ K:\ORACLE\RES\SAPDATA4\SR3DB_3\SR3DB.DATA3 1048584192 43 10 NOLINK FILE 10485760000 20971520 8192

PSAPSR3USR ONLINE* ONLINE+ H:\ORACLE\RES\SAPDATA1\SR3USR_1\SR3USR.DATA1 20979712 40 7 NOLINK FILE 10485760000 20971520 8192

PSAPTEMP ONLINE# ONLINE+ I:\ORACLE\RES\SAPDATA2\TEMP_1\TEMP.DATA1 2097160192 -1 8 NOLINK FILE 10485760000 20971520 8192

PSAPUNDO ONLINE- ONLINE+ J:\ORACLE\RES\SAPDATA3\UNDO_1\UNDO.DATA1 8766103552 2 9 NOLINK FILE 10485760000 20971520 8192

SYSAUX ONLINE* ONLINE+ H:\ORACLE\RES\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 251666432 3 7 NOLINK FILE 10485760000 20971520 8192

SYSTEM ONLINE* SYSTEM+ H:\ORACLE\RES\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 1073750016 1 7 NOLINK FILE 10485760000 20971520 8192

BR0119I Redo log files

File Size Group Device Status Link Type

F:\ORACLE\RES\MIRRLOGA\LOG_G11M2.DBF 52429312 1 5 INUSE NOLINK FILE

E:\ORACLE\RES\ORIGLOGA\LOG_G11M1.DBF 52429312 1 4 INUSE NOLINK FILE

F:\ORACLE\RES\MIRRLOGB\LOG_G12M2.DBF 52429312 2 5 INUSE NOLINK FILE

E:\ORACLE\RES\ORIGLOGB\LOG_G12M1.DBF 52429312 2 4 INUSE NOLINK FILE

F:\ORACLE\RES\MIRRLOGA\LOG_G13M2.DBF 52429312 3 5 INUSE NOLINK FILE

E:\ORACLE\RES\ORIGLOGA\LOG_G13M1.DBF 52429312 3 4 INUSE NOLINK FILE

F:\ORACLE\RES\MIRRLOGB\LOG_G14M2.DBF 52429312 4 5 INUSE NOLINK FILE

E:\ORACLE\RES\ORIGLOGB\LOG_G14M1.DBF 52429312 4 4 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

E:\oracle\RES\origlogA\cntrl\cntrlRES.dbf 14106624 0 4 NOLINK FILE

E:\oracle\RES\origlogB\cntrl\cntrlRES.dbf 14106624 0 4 NOLINK FILE

G:\oracle\RES\sapdata1\cntrl\cntrlRES.dbf 14106624 0 6 NOLINK FILE

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.10

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

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

ORA-01031: insufficient privileges

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.10 BR0307I Shutting down database instance RES ...

BR0280I BRBACKUP time stamp: 2009-07-10 14.53.17 BR0308I Shutdown of database instance RES successful

BR0056I End of database backup: beazhkrz.afd 2009-07-10 14.53.10 BR0280I BRBACKUP time stamp: 2009-07-10 14.53.17

BR0054I BRBACKUP terminated with errors

-

Regards,

Venkata.

Show replies
Show replies
sunny_pahuja2
Active Contributor
‎07-11-2009 6:42 PM
0 Kudos

Hi,

It looks like after upgrade you did not run sapdba_role.sql script. Have you run this script after upgrade ?

If you have excuted this script then Check SAP Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role.

Thanks

Sunny

Former Member
‎07-11-2009 8:26 AM
0 Kudos

make sure the user name and it's privlage as well.

Check the privlage of directory where u want to save the Backup.

if possible could u send the backup log.

Thanks

presu

Show replies
Show replies
Ask a Question