Database Backup and Recovery (MOSC)

MOSC Banner

Incremental differential backup size equals to Full backup size.

Hello all,

I have a multitenant oracle 19c RAC database using ASM and block change tracking. However I've noticed, that the incremental lvl 1 backups are almost as huge as the full backups, so I checked the DB alertlog and foung this:

UMKDB(3):not using change tracking for this File# 43,

UMKDB(3):csno: 1

UMKDB(3):not using change tracking for this File# 52,

UMKDB(3):csno: 1

UMKDB(3):not using change tracking for this File# 50,

UMKDB(3):csno: 1

UMKDB(3):not using change tracking for this File# 54,

UMKDB(3):csno: 1

2022-03-16T23:12:47.669003+01:00

UMKDB(3):not using change tracking for this File# 40,

UMKDB(3):csno: 1

UMKDB(3):not using change tracking for this File# 45,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center