重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: RMAN OSB backup ORA-19506 ORA-27028 ORA-19511 sbt__shmcreate: Internal error [打印本页]

作者: 刘泽宇 时间: 2025-9-19 19:13
标题: RMAN OSB backup ORA-19506 ORA-27028 ORA-19511 sbt__shmcreate: Internal error
现象：
RMAN backup fails with

ORA-19506 "failed to create sequential file, name=\"%s\", parms=\"%s\""
ORA-27028 "skgfqcre: sbtbackup returned error"
ORA-19511 sbt__shmcreate: Internal error - Failed to create shared memory area of size 16838152 + 4440 bytes (Oracle Secure Backup error: 'system is out of shared segments (shared memory manager)')

原因：
Check the operating system kernel settings.

处理方法：
For example, on Linux:

Set in /etc/sysctl.conf. You should check how much RAM is in the system to confirm these are applicable. This is from a server with 16GB RAM.

kernel.shmall = 1073741824
kernel.shmmni = 4096
kernel.msgmni = 2878
kernel.msgmax = 8192
kernel.msgmnb = 65536
kernel.sem = 250 32000 100 142
kernel.shmmax = 4398046511104

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)