ORA-04031 during rman duplicate

posted Mar 25, 2011, 4:15 PM by Sachchida Ojha   [ updated Mar 26, 2011, 8:54 AM ]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/25/2011 22:53:31
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u07/ARBPRDDB/archive/arbprddb_1_330411_576139613.arc'
ORA-00283: recovery session canceled due to errors
ORA-04031: unable to allocate 1052696 bytes of shared memory ("shared pool","unknown object","PMR sga heap","log read buffer")

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, ant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sqlunregister, upgrade, validate, {, "
RMAN-01007: at line 0 column 2 file: standard input

SYS@DUPRAT1  SQL>show parameter shared

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 6710886
shared_pool_size                     big integer 128M
shared_server_sessions               integer
shared_servers                       integer     0
SYS@DUPRAT1  SQL>show parameter large

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_partition_large_extents         string      DEFAULT
large_pool_size                      big integer 0
SYS@DUPRAT1  SQL>show sga

Total System Global Area  254754816 bytes
Fixed Size                  2205680 bytes
Variable Size             159385616 bytes
Database Buffers           83886080 bytes
Redo Buffers                9277440 bytes


SYS@RAT1  SQL>show parameter sha

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cursor_sharing                       string      EXACT
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shadow_core_dump                     string      partial
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 12000000
shared_pool_size                     big integer 0
shared_server_sessions               integer
shared_servers                       integer     1
SYS@RAT1  SQL>show sga

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2222616 bytes
Variable Size            2617247208 bytes
Database Buffers         1.3388E+10 bytes
Redo Buffers               26525696 bytes
SYS@RAT1  SQL>show parameter large

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_partition_large_extents         string      DEFAULT
large_pool_size                      big integer 0
SYS@RAT1  SQL>
SYS@RAT1  SQL>show parameter memory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 30G
memory_target                        big integer 30G
shared_memory_address                integer     0
SYS@RAT1  SQL>




Comments