In a Oracle 12c multitenant DB instance with multiple PDBs, is it possible to enable ARCHIVELOG
mode on a single PDB?
-
,Yes. but You must do this from the root container.– Md Haidar Ali KhanFeb 28, 2017 at 11:14
-
For root container do you refer to CDB? In this way all PDBs will be affected, isn't it?– sgargelFeb 28, 2017 at 11:17
-
Do you mean archivelog mode for one PDB but not others?– Andrew BrennanFeb 28, 2017 at 11:23
-
Yes. On a single PDB not affecting others...– sgargelFeb 28, 2017 at 11:25
1 Answer
Because all PDBs share the same redo log files, it's not possible to enable archive log mode only for a specific PDB. All PDBs share the archive log mode of the CDB.
Remember, the PDBs themselves don't have any instance (processes and memory areas) or control file and redo logs