enabling archivelog for only one PDB in a CDB
Hi,
We are in Oracle Database 19.9.
We have one CDB (CKTL1) with 3 PDBs :
SYS @ CKTL1> select name, open_mode from v$pdbs;
NAME OPEN_MODE
-------- ---------
PDB$SEED READ ONLY
PROD READ WRITE
TEST1 READ WRITE
TEST2 READ WRITE
Archive log is enabled on CKTL1 :
SYS @ CKTL1> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
[...]
With this configuration, the entire CDB is in archive log mode.
Is it possible to disable archive logging for only one PDB (TEST1 and/or TEST2) or, in other words, to have archive logging for only one PDB (PROD) ?
Note I don't want to create a CDB with archive logging enabled with only PROD PDB, and another CDB without logging for TEST1 and TEST2 PDBs.