Database Administration (MOSC)

MOSC Banner

Is turning supplemental logging in cdb means all pdbs have supplemental logging on?

edited Dec 13, 2023 6:58AM in Database Administration (MOSC) 5 commentsAnswered ✓
Hi everyone,

1. in cdb, 
alter database add supplemental logging data.

does it means, all pdbs will inherit supplemental logging 
and do not have to go into a particular pdb to do this command again?


2. which data dictionary table will tell supplemental logging in pdb?
CHECKING V$database is only from CDB
select
   SUPPLEMENTAL_LOG_DATA_MIN,
   SUPPLEMENTAL_LOG_DATA_PK,
   SUPPLEMENTAL_LOG_DATA_UI
from
   v$database;  <--- ONLY for the cdb, what about pdb level?


SUPPLEME SUP SUP
-------- --- ---
YES      YES YES

Thanks


friendly

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