TPITR With LOB and Subpartition Fails With RMAN-6019 ORA-1029
(Doc ID 2654778.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
TPITR (RECOVER TABLE command) fails with following errors when taget table has both LOB column and Subpartitions.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/12/2020 13:18:47
RMAN-06136: Oracle error from auxiliary database: ORA-01029: internal two task error
RMAN-06019: could not translate tablespace name ""
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/12/2020 13:18:47
RMAN-06136: Oracle error from auxiliary database: ORA-01029: internal two task error
RMAN-06019: could not translate tablespace name ""
Changes
This problem reproduces when following all conditions are met.
- Table A has a LOB column
- Table A is configured as a Partition Table and has Subpartitions
- Run "RECOVER TABLE" command via RMAN against Table A
- Fix of BUG:26828994 is applied
Fix of BUG:26828994 is included in
- 18.1.0
- 12.2.0.1.181016 (Oct 2018) Database Release Update (DB RU)
- 12.1.0.2.181016 (Oct 2018) Database Patch Set Update (DB PSU)
- 12.1.0.2.181016 (Oct 2018) Database Proactive Bundle Patch
- 12.2.0.1.180831 (Aug 2018) Bundle Patch for Windows Platforms
- 12.1.0.2.180831 (Aug 2018) Bundle Patch for Windows Platforms
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |