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

标题: 恢复PDB到过去时间报错RMAN-04014 [打印本页]

作者: 郑全 时间: 2020-1-16 18:21
标题: 恢复PDB到过去时间报错RMAN-04014

rman> RECOVER TABLESPACE PDB1:TEST_TBS

UNTIL SCN 832972
AUXILIARY DESTINATION '/tmp/';
RMAN> ALTER TABLESPACE PDB1:TEST_TBSONLINE;

starting up automatic instance CDB1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/16/2020 17:22:17
RMAN-04014: startup failed: ORA-27104: system-defined limits for shared memory was misconfigured

作者: 郑全 时间: 2020-1-17 09:50
是以下参数的原因：
kernel.shmmax = 2061508608

cdb sga_max_size 为2G,再复制一个cdb1，就超过这个值了。
修改为以下值即可
kernel.shmmax = 4061508608

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