LLI Wiki — My Digital Knowledge Base

ORA-27092 on AIX during an RMAN backup: fsize limit

Raise the fsize user limit in /etc/security/limits on AIX so that an RMAN backup agent can write files larger than the default limit.

On AIX, an RMAN backup run through a third-party backup agent can fail with ORA-27092, which reports that the size of a file exceeds the file size limit of the process:

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

The cause is the fsize user limit defined in /etc/security/limits, which is too low by default. The fix is to set fsize to -1 (unlimited) for the users that run the backup. Your UNIX administrator may need to show you the file.

Excerpt of /etc/security/limits

The default stanza limits fsize to 2097151:

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

Set fsize to unlimited

For the Oracle owner, set fsize to -1:

oracle:
        fsize = -1

If the backup agent runs as root and the root stanza uses the default limit, set it too:

root:
        fsize = -1

Notes

Mastodon LLIMastodon SocialFosstodon