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
- The limit is read when a process starts: restart the backup agent and the sessions that run RMAN after the change.
- The original stanzas for the other users (daemon, bin, sys, and so on) are not reproduced: only the entries for the users involved in the backup are relevant.