12c Rman Recover Table Fails If Max_string_size is EXTENDED

(Doc ID 1575031.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

RMAN recover table command fails if instance is using max_string_size= EXTENDED:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03004: fatal error during execution of command
RMAN-10041: Could not re-create polling channel context following failure.
RMAN-10024: error setting up for rpc polling
RMAN-10005: error opening cursor
RMAN-10002: ORACLE error: ORA-03114: not connected to ORACLE
RMAN-03002: failure of recover command at 04/15/2013 16:37:19
RMAN-06136: ORACLE error from auxiliary database: ORA-03114: not connected to ORACLE
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 04/15/2013 16:37:19
RMAN-11003: failure during parse/execution of SQL statement: alter database open read only
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-14693: The MAX_STRING_SIZE parameter must be EXTENDED.


Seem max_string_size parameter is not set in the auxiliary instance.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms