Database Administration (MOSC)

MOSC Banner

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.

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