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.