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: 

Backup Issue

Former Member

on ‎11-07-2009 5:31 AM

0 Kudos

Dears,

We are getting below error in online backup :

BR0301E SQL error -1116 at location BrBackAlter-3, SQL statement:

'/* BRBACKUP */ ALTER DATABASE BEGIN BACKUP'

ORA-01116: error in opening database file 2

ORA-01110: data file 2: '/oracle/GD1/sapdata1/undo_1/undo.data1'

ORA-27092: size of file exceeds file size limit of the process

Additional information: 262143

Additional information: 1090561

BR0280I BRBACKUP time stamp: 2009-11-06 16.08.18

BR0316E 'Alter database begin backup' failed

BR0056I End of database backup: bebvxacu.anf 2009-11-06 16.08.18

BR0280I BRBACKUP time stamp: 2009-11-06 16.08.18

BR0054I BRBACKUP terminated with errors

This is first time when we are taking backup of the server,Please suggest if we are missing something in configuration.

Regards,

Shivam

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member524429
Active Contributor
‎11-07-2009 5:49 AM
0 Kudos

Hi Shivam,

Please refer the following SAP Notes:

[Note 129439 - Maximum file sizes with Oracle|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=129439]

[Note 553854 - Oracle: Problems with file size limit|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=553854]

Increase the processes file size limit (ulimit) and retry

Regards,

Bhavik G. Shroff

Show replies
Show replies
Former Member
‎11-07-2009 6:28 AM
0 Kudos

Dears,

I have already checked these notes and set all ulimit parameters to unlimited.

Please suggest.

Shivam

stefan_koehler
Active Contributor
‎11-07-2009 9:09 AM
0 Kudos

Hello Shivam,

where do you store your backup (Disk/Tape)?

What is your OS and which filesystem are you using?

Regards

Stefan

Former Member
‎11-07-2009 9:25 AM
0 Kudos

Dear Stefan,

We are taking backup on tape and we are using AIX 6.1 OS.

File systems are:

/dev/hd4 1.00 0.28 0.72 28% /

/dev/hd2 12.00 2.48 9.52 21% /usr

/dev/hd9var 0.50 0.07 0.43 15% /var

/dev/hd3 7.00 2.47 4.53 36% /tmp

/dev/fwdump 0.81 0.00 0.81 1% /var/adm/ras/platform

/dev/hd1 1.00 0.05 0.95 6% /home

/dev/hd11admin 0.12 0.00 0.12 1% /admin

/proc - - - - /proc

/dev/hd10opt 0.50 0.20 0.30 40% /opt

/dev/livedump 0.25 0.00 0.25 1% /var/adm/ras/livedump

/dev/fslv00 8.00 0.15 7.85 2% /oracle

/dev/fslv01 150.00 72.00 78.00 49% /oracle/PD1

/dev/fslv02 15.00 2.54 12.46 17% /usr/sap/trans

/dev/fslv03 7.00 1.31 5.69 19% /sapmnt/PD1

/dev/fslv04 10.00 4.95 5.05 50% /oracle/stage

/dev/fslv05 35.00 26.18 8.82 75% /oracle/PD1/oraarch

/dev/fslv07 50.00 43.56 6.44 88% /software

/dev/fslv06 6.00 4.79 1.21 80% /usr/sap/PD1

drwxr-xr-x 8 orapd1 dba 256 Sep 04 18:35 sapdata1

drwxr-xr-x 11 orapd1 dba 4096 Sep 04 18:35 sapdata2

drwxr-xr-x 9 orapd1 dba 256 Sep 04 18:35 sapdata3

drwxr-xr-x 5 orapd1 dba 256 Sep 04 18:35 sapdata4

Please suggest.

Shivam

stefan_koehler
Active Contributor
‎11-07-2009 9:34 AM
0 Kudos

Hello Shivam,

if you are taking backup to tape .. the file system type (JFS/JFS2) is not important.

Could you please post the output of the following commands


shell> su - ora<SID>
shell> ps -fu ora<SID>
shell> ulimit -a
shell> su - <SID>adm
shell> ulimit -a

Regards

Stefan

former_member524429
Active Contributor
‎11-07-2009 9:35 AM
0 Kudos

Dear Shivam,

What is the ulimit settings for the Oracle user?

On UNIX, you can use "ulimit" to define a user-specific limit for the file size. If the limit that is set is too restrictive, the aforementioned terminations may occur. You can use "ulimit" to check how the limit for ora<sid> and <sid>adm is set. The "unlimited" value is useful here. Also note that the "ulimit" is not output in bytes. Instead, it is specified in operating system blocks. Therefore, in the case of 512-byte blocks, the output "4194303" indicates that the limit is 2 GB. Ref: [553854|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=553854]

Regards,

Bhavik G. Shroff

Edited by: Bhavik G. Shroff on Nov 7, 2009 3:06 PM

former_member524429
Active Contributor
‎11-07-2009 10:14 AM
0 Kudos

Dear Shivam,

Please refer the following useful links.

[|]

See [Note 323816 - User limits on AIX|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=323816]

For ora<sid> , <sid>adm users, the data, stack and memory settings to be set to "unlimited" as they may face some issues with their jobs.

Regards,

Bhavik G. Shroff

Former Member
‎11-07-2009 11:06 AM
0 Kudos

grcdev:oragd1> ps -fu oragd1

UID PID PPID C STIME TTY TIME CMD

oragd1 352418 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 389190 1 0 Oct 10 - 0:38 /oracle/GD1/102_64/bin/tnslsnr LISTENER -inherit

oragd1 499874 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 508002 1 0 16:10:38 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 524320 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 528446 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 561174 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 577694 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 606392 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 659530 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 688248 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 720986 1 0 16:06:02 - 0:03 oracleGD1 (LOCAL=NO)

oragd1 733368 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 774178 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 827574 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 831694 1 0 16:06:02 - 0:08 oracleGD1 (LOCAL=NO)

oragd1 868458 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 979078 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1105962 1 0 16:12:23 - 8:22 oracleGD1 (LOCAL=NO)

oragd1 1126444 1 0 16:08:28 - 0:03 oracleGD1 (LOCAL=NO)

oragd1 1151042 1 0 15:23:06 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1167422 1 0 00:55:24 - 1:58 oracleGD1 (LOCAL=NO)

oragd1 1212556 1 0 14:39:10 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1241342 1 0 07:00:42 - 0:01 oracleGD1 (LOCAL=NO)

oragd1 1290374 1 0 16:07:37 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1302572 1 0 14:32:00 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1327116 655474 0 15:29:25 pts/0 0:00 -ksh

oragd1 1331338 1 0 16:07:46 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1339536 1 0 16:07:48 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1343650 1327116 0 15:29:47 pts/0 0:00 ps -fu oragd1

ulimit -a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) unlimited

threads(per process) unlimited

processes(per user) unlimited

For gd1adm

su - gd1adm

grcdev:gd1adm> ulimit -a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) unlimited

threads(per process) unlimited

processes(per user) unlimited

Please suggest.

Shivam

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

grcdev:oragd1> ps -fu oragd1

UID PID PPID C STIME TTY TIME CMD

oragd1 352418 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 389190 1 0 Oct 10 - 0:38 /oracle/GD1/102_64/bin/tnslsnr LISTENER -inherit

oragd1 499874 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 508002 1 0 16:10:38 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 524320 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 528446 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 561174 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 577694 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 606392 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 659530 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 688248 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 720986 1 0 16:06:02 - 0:03 oracleGD1 (LOCAL=NO)

oragd1 733368 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 774178 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 827574 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 831694 1 0 16:06:02 - 0:08 oracleGD1 (LOCAL=NO)

oragd1 868458 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 979078 1 0 16:06:02 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1105962 1 0 16:12:23 - 8:22 oracleGD1 (LOCAL=NO)

oragd1 1126444 1 0 16:08:28 - 0:03 oracleGD1 (LOCAL=NO)

oragd1 1151042 1 0 15:23:06 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1167422 1 0 00:55:24 - 1:58 oracleGD1 (LOCAL=NO)

oragd1 1212556 1 0 14:39:10 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1241342 1 0 07:00:42 - 0:01 oracleGD1 (LOCAL=NO)

oragd1 1290374 1 0 16:07:37 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1302572 1 0 14:32:00 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1327116 655474 0 15:29:25 pts/0 0:00 -ksh

oragd1 1331338 1 0 16:07:46 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1339536 1 0 16:07:48 - 0:00 oracleGD1 (LOCAL=NO)

oragd1 1343650 1327116 0 15:29:47 pts/0 0:00 ps -fu oragd1

ulimit -a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) unlimited

threads(per process) unlimited

processes(per user) unlimited

For gd1adm

su - gd1adm

grcdev:gd1adm> ulimit -a

time(seconds) unlimited

file(blocks) unlimited

data(kbytes) unlimited

stack(kbytes) unlimited

memory(kbytes) unlimited

coredump(blocks) unlimited

nofiles(descriptors) unlimited

threads(per process) unlimited

processes(per user) unlimited

Please suggest.

Shivam

stefan_koehler
Active Contributor
‎11-07-2009 11:45 AM
0 Kudos

Hello Shivam,

thanks for the output .. this seems to be a really "strange" issue.

Can you please also provide the output of the following command (please don't forget the code tag):


shell> mount
shell> cat /etc/security/limits

Thanks and Regards

Stefan

Former Member
‎11-10-2009 6:10 AM
0 Kudos

Dear Stefan,

Output of the cat /etc/security/limits is 

default:
        fsize = 2097151
        core = 2097151
        cpu = -1
        data = 262144
        rss = 65536
        stack = 65536
        nofiles = 2000

root:
        fsize = -1     
        data = -1
        stack = -1
        core = 2097151
        rss = 65536
        nofiles = 2000

pconsole:
        stack_hard = 131072
        data = 1280000
        data_hard = 1280000

esaadmin:
        stack = 393216
        stack_hard = 393216

gd1adm:
        fsize = -1     
        data = -1
        stack = -1
        core = 2097151
        rss = -1
        nofiles = -1

smgd1adm:
        fsize = -1     
        data = -1
        stack = -1
        core = -1
        rss = -1
        nofiles = -1

oragd1:
        fsize = -1     
        data = -1
        stack = -1
        core = -1
        rss = -1
        nofiles = -1

Shivam

Former Member
‎11-10-2009 7:32 AM
0 Kudos

Hi Shivam,

Please check Oracle metalink 271331.1 to get the rid of this problem.

To access Oracle Metalink see OSS Note 758563: "Oracle Metalink access for SAP customers.

Thanks,

Shambo

Ask a Question