Oracle 19C archivelog 还是不可以pdb级别设置, standby db可以

Where to configure Archive Log mode for multitenant structures - CDB or PDB (Doc ID 2284641.1)

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

Running 12c database and need to configure archive log, shall we configure it in PDB or CDB?
 

Solution

All PDBs share the same redo log files, so it's not possible to enable archivelog mode only for a specific PDB.
All PDBs share the archivelog mode of CDB.
Remember that PDBs themselves don't have a dedicated instance (processes and memory areas) so they share CDB's ones.

Configuring of archivelog mode should be implemented in CDB.

For more details on how to configure this feature, please refer to below doc:

Managing Archived Redo Log Files
http://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN008

上一篇:Golang | Leetcode Golang题解之第452题用最少数量的箭引爆气球-题解:


下一篇:接口隔离原则在前端的应用-结论