My Oracle Support Banner

ORA-4030 on Duplicate Database command with BACKUP LOCATION (Doc ID 2758012.1)

Last updated on APRIL 02, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Backup-Based DUPLICATE DATABASE command via RMAN fails by ORA-4030 when there are many directories and files under the directories which is specified in "BACKUP LOCATION".

(example of error messages of RMAN DUPLICATE command).
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at <Timestamp>
RMAN-05501: aborting duplication of target database
RMAN-06136: Oracle error from auxiliary database: ORA-03113: The connection between Client and Server process was broken.

When this problem happens, the chunk size of "fname_krbmsffn", "krbmsfhkey" and "krbmsffn" increase, and it appears in incident file of ORA-4030 as follows.

(example of messages in trace file of ORA-4030).
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** <Timestamp>
80%    25 GB, 52723521 chunks: "fname_krbmsffn "
                 pga heap ds=0x7fc6c208e200 dsprt=(nil)
13% 4183 MB, 52723523 chunks: "krbmsfhkey "
                 pga heap ds=0x7fc6c208e200 dsprt=(nil)
 7% 2414 MB, 52723522 chunks: "krbmsffn "
                 pga heap ds=0x7fc6c208e200 dsprt=(nil)
 0%   220 KB, 1 chunk : "Fixed Uga "
                 Fixed UGA heap ds=0x7fc6bd3e4f78 dsprt=0x7fc6c208e200

Changes

This is caused when there are many directories and files under the directories which is specified in "BACKUP LOCATION".
For example, the following DUPLICATE DATABASE command may hit this issue.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.