Issue description
when I did standby creation on other host by using rman duplicate command I've got an error like:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/27/2014 15:41:59
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system
was really surprised because the standby was configured with less SGA memory than actual primary like
32Gb - SGA* on Production
4 Gb - SGA* on Standby
* - as for MEMORY_TARGET parameter
Reason for the Issue
the problem was in system configuration
[root@sby01 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_sby01-lv_root 53G 18G 34G 35% /
tmpfs 3.0G 30M 2.9G 1% /dev/shm
/dev/vda1 485M 100M 360M 22% /boot
10.1.1.5:/u02 734G 494G 240G 68% /u02
Workaround
[root@sby01 ~]# vi /etc/fstab
#
# /etc/fstab
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_sby01-lv_root / ext4 defaults 1 1
UUID=ae17aee-972b-4f91-806b-f3e33d29a0 /boot ext4 defaults 1 2
/dev/mapper/vg_mtksby01p2-lv_swap swap swap defaults 0 0
tmpfs /dev/shm tmpfs defaults,size=8g 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
I've allocated 8Gb for tmpfs
[root@sby01 ~]# mount -o remount /dev/shm
when I did standby creation on other host by using rman duplicate command I've got an error like:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/27/2014 15:41:59
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-00845: MEMORY_TARGET not supported on this system
was really surprised because the standby was configured with less SGA memory than actual primary like
32Gb - SGA* on Production
4 Gb - SGA* on Standby
* - as for MEMORY_TARGET parameter
Reason for the Issue
the problem was in system configuration
[root@sby01 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_sby01-lv_root 53G 18G 34G 35% /
tmpfs 3.0G 30M 2.9G 1% /dev/shm
/dev/vda1 485M 100M 360M 22% /boot
10.1.1.5:/u02 734G 494G 240G 68% /u02
Workaround
[root@sby01 ~]# vi /etc/fstab
#
# /etc/fstab
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/vg_sby01-lv_root / ext4 defaults 1 1
UUID=ae17aee-972b-4f91-806b-f3e33d29a0 /boot ext4 defaults 1 2
/dev/mapper/vg_mtksby01p2-lv_swap swap swap defaults 0 0
tmpfs /dev/shm tmpfs defaults,size=8g 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
I've allocated 8Gb for tmpfs
[root@sby01 ~]# mount -o remount /dev/shm