Oracle 多租户数据库开启force logging

登录数据库并切换到对应的PDB：

CONN / AS SYSDBA
ALTER SESSION SET CONTAINER = pdb5;

-- Enable FORCE LOGGING.
ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE RESTRICTED FORCE;
ALTER PLUGGABLE DATABASE pdb5 ENABLE FORCE LOGGING;
ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE FORCE;

COLUMN pdb_name FORMAT A20
COLUMN force_logging FORMAT A15
COLUMN force_nologging FORMAT A15

SELECT pdb_id,
       pdb_name,
       logging,
       force_logging,
       force_nologging
FROM   cdb_pdbs
ORDER BY 1;

    PDB_ID PDB_NAME             LOGGING   FORCE_LOGGING   FORCE_NOLOGGING
---------- -------------------- --------- --------------- ---------------
         7 PDB5                 LOGGING   YES             NO

-- Enable FORCE NOLOGGING.
ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE RESTRICTED FORCE;
ALTER PLUGGABLE DATABASE pdb5 ENABLE FORCE NOLOGGING;
ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE FORCE;

SELECT pdb_id,
       pdb_name,
       logging,
       force_logging,
       force_nologging
FROM   cdb_pdbs
ORDER BY 1;

    PDB_ID PDB_NAME             LOGGING   FORCE_LOGGING   FORCE_NOLOGGING
---------- -------------------- --------- --------------- ---------------
         7 PDB5                 LOGGING   YES             NO

-- Disable FORCE LOGGING.
ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE RESTRICTED FORCE;
ALTER PLUGGABLE DATABASE pdb5 DISABLE FORCE NOLOGGING;
ALTER PLUGGABLE DATABASE pdb5 OPEN READ WRITE FORCE;

SELECT pdb_id,
       pdb_name,
       logging,
       force_logging,
       force_nologging
FROM   cdb_pdbs
ORDER BY 1;

    PDB_ID PDB_NAME             LOGGING   FORCE_LOGGING   FORCE_NOLOGGING
---------- -------------------- --------- --------------- ---------------
         7 PDB5                 LOGGING   NO              NO