Unsolved
This post is more than 5 years old
33 Posts
0
2153
February 14th, 2012 23:00
Online sap backup failed in legato?
When we running the sap online backup in legato, backup is failling with the below error...
BR0051I BRBACKUP 7.00 (43)
BR0248I BR_TRACE: level 0, function main entry with '/usr/sap/R3P/SYS/exe/run/brbackup -c force -u SYSTEM/*******'
BR0055I Start of database backup: behwwtks.anf 2012-02-15 11.36.42
BR0484I BRBACKUP log file: /oracle/R3P/sapbackup/behwwtks.anf
BR0477I Oracle pfile /oracle/R3P/102_64/dbs/initR3P.ora created from spfile /oracle/R3P/102_64/dbs/spfileR3P.ora
BR0280I BRBACKUP time stamp: 2012-02-15 11.36.42
BR0301W SQL error -1116 at location BrDbaSynCheck-1, SQL statement:
'SELECT COUNT(*) FROM SAP_SDBAH WHERE BEG = '00000000000000''
ORA-01116: error in opening database file 7
ORA-01110: data file 7: '/oracle/R3P/sapdata4/r3p_5/r3p.data5'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 1280001
BR0280I BRBACKUP time stamp: 2012-02-15 11.36.42
BR0301E SQL error -1116 at location BrLicCheck-14, SQL statement:
'SELECT COUNT(*) FROM SAP_SAPLIKEY'
ORA-01116: error in opening database file 109
ORA-01110: data file 109: '/oracle/R3P/sapdata4/r3p_67/r3p.data67'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 1280001
BR0280I BRBACKUP time stamp: 2012-02-15 11.36.42
BR0301W SQL error -1116 at location BrbDbLogOpen-5, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20120215113642', 'anf', 'R3P', ' ', '9999', ' ', 'behwwtks', '7.00 (43)')'
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/oracle/R3P/sapdata5/r3p_3/r3p.data3'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 1292801
BR0324W Insertion of database log header failed
BR0056I End of database backup: behwwtks.anf 2012-02-15 11.36.42
BR0280I BRBACKUP time stamp: 2012-02-15 11.36.42
BR0054I BRBACKUP terminated with errors
Can any one plz help us to fix this issue?
CarlosRojas
1.7K Posts
1
February 14th, 2012 23:00
Hi,
Please take a look at this link:
http://oraclehandson.wordpress.com/2011/04/27/ora-27092-size-of-file-exceeds-file-size-limit-of-the-process/
Thank you.
Carlos.
Msat1
33 Posts
0
February 14th, 2012 23:00
Hi Carlos,
Thanks for the quick response. we can see the below ouput. the ulimit size is set to unlimited. client os is HP_ux
CarlosRojas
1.7K Posts
0
February 14th, 2012 23:00
Hi there,
Here is Oracle's description of the error:
ORA-27092: xxxxi: size of file exceeds file size limit of the process
Cause: an attempt was made to open a file that exceeds the process's file size limit (ulimit), additional information
shows the current limit (logical blocks) and the size of the file (logical blocks)
Action: increase the processes file size limit (ulimit) and retry.
These are the sizes:
Additional information: 262143 (Currently set)
Additional information: 1292801 (Minimum limit required)
What is your OS?
Thank you.
Carlos.