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 Khan Feb 28 '17 at 11:14
  • For root container do you refer to CDB? In this way all PDBs will be affected, isn't it? – sgargel Feb 28 '17 at 11:17
  • Do you mean archivelog mode for one PDB but not others? – Andrew Brennan Feb 28 '17 at 11:23
  • Yes. On a single PDB not affecting others... – sgargel Feb 28 '17 at 11:25

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

Oracle Database 12c Feature: Multitenant Database

  • I came to your own conclusion after looking at this link but not having found explicit in oracle documentation I was left with the doubt. – sgargel Feb 28 '17 at 11:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.