1 Reply Latest reply: Oct 21, 2011 11:14 AM by Paula B RSS

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

    user8665771
      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.