2 Replies Latest reply: May 18, 2014 10:10 AM by rp0428 RSS

    ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED while testing RECOVER TABLE

    Fabricio_Jorge

      Hi all,

       

      RDBMS: 12.1.0.1.0

      OS: CentOS 6.3

       

      I am testing the new feature of restoring tables using RMAN, but i got the following error:

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of recover command at 05/17/2014 23:27:13

      RMAN-03015: error occurred in stored script Memory Script

      RMAN-03009: failure of sql command on clone_default channel at 05/17/2014 23:27:12

      RMAN-11003: failure during parse/execution of SQL statement: alter pluggable database  PDBPROD1 open read only

      ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.

       

       

      The RMAN command is:

       

      recover table USR_PROD.TAB_CHAMADAS OF PLUGGABLE DATABASE PDBPROD1 until sequence 314 auxiliary destination '/backup/auxiliary';

       

       

      My CDB and my PDB are both configured with MAX_STRING_SIZE, as you can see below:

       

      ### cdb ###

      SQL> show parameter max_string

       

      NAME     TYPE VALUE

      ------------------------------------ ----------- ------------------------------

      max_string_size     string EXTENDED

       

       

      ### pdb ###

      SQL> show parameter max_string

       

      NAME     TYPE VALUE

      ------------------------------------ ----------- ------------------------------

      max_string_size     string EXTENDED

       

      ... as you can see, the MAX_STRING_SIZE is already set to EXTENDED, so why RMAN is complaining about it?

       

      Does anyone got this error?

       

      Thanks in advance.