Arctera

Clone command errors in a Data Guard environment using the MEMORY_TARGET feature for Oracle 11g (1824713)

The dbed_vmclonedb command displays errors when attempting to take a clone on a STANDBY database in a dataguard environment when you are using the MEMORY_TARGET feature for Oracle 11g.

When you attempt to take a clone of a STANDBY database, the dbed_vmclonedb displays the following error messages:

Retrieving snapshot information ...                          Done
Importing snapshot diskgroups ...                            Done
Mounting snapshot volumes ...                                Done
Preparing parameter file for clone database ...              Done
Mounting clone database ...
ORA-00845: MEMORY_TARGET not supported on this system


SFDB vxsfadm ERROR V-81-0612 Script 
/opt/VRTSdbed/applications/oracle/flashsnap/pre_preclone.pl failed.

<!--NeedCopy-->

This is Oracle 11g-specific issue known regarding the MEMORY_TARGET feature, and the issue has existed since the Oracle 11gr1 release. The MEMORY_TARGET feature requires the /dev/shm file system to be mounted and to have at least 1,660,944,384 bytes of available space. The issue occurs if the /dev/shm file system is not mounted or if the file system is mounted but has available space that is less than the required minimum size.

Workaround: To avoid the issue, remount the /dev/shm file system with sufficient available space.

To remount the /dev/shm file system with sufficient available space

  1. Shut down the database.
  2. Unmount the /dev/shm file system:
   # umount /dev/shm
   <!--NeedCopy-->
  1. Mount the /dev/shm file system with the following options:
   # mount -t tmpfs shmfs -o size=4096m /dev/shm
   <!--NeedCopy-->
  1. Start the database.
Clone command errors in a Data Guard environment using the MEMORY_TARGET feature for Oracle 11g (1824713)

In this article