My Oracle Support Banner

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 11.1.0.6 to 11.2.0.4 [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.

Symptoms

 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".

Changes

 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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.