RMAN backup warning errors ORA-19883 and ORA-19864 explanation
(Doc ID 1982992.1)
Last updated on FEBRUARY 17, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
RMAN not using Unused Block Compression/Optimization during backup.
ORA-19883 and ORA-19864 errors seen in the alert.log file of the database when an RMAN backup is taken with "Unused Block Optimization".
This usually happens when RMAN is taking a backup of a bigfile tablepace and that tablespace has reached certain size, usually after reaching more than 2.5Tb, but some customer have seen those errors only when the bigfile is more than 4TB.
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