This discussion is archived
1 Reply Latest reply: Oct 21, 2011 9:14 AM by Paula B RSS

ORA-00843: Parameter not taking MEMORY_MAX_TARGET in to account, see alert

user8665771 Newbie
Currently Being Moderated
Hi Friends,
I am trying to do the ACTIVE DATA GUARD. When run the ADG script, It throw the below error. Please help me to solve this.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/19/2011 00:57:55
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-00843: Parameter not taking MEMORY_MAX_TARGET in to account, see alert log for more information

RMAN>

My primary database configuration is below,

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 256M
sga_target big integer 0
SQL>
SQL> show parameter target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 192M
memory_target big integer 0
pga_aggregate_target big integer 53267660
sga_target big integer 0
SQL>

Thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points