6

In a Oracle 12c multitenant DB instance with multiple PDBs, is it possible to enable ARCHIVELOG mode on a single PDB?

4
  • ,Yes. but You must do this from the root container. Feb 28, 2017 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, 2017 at 11:17
  • Do you mean archivelog mode for one PDB but not others? Feb 28, 2017 at 11:23
  • Yes. On a single PDB not affecting others...
    – sgargel
    Feb 28, 2017 at 11:25

1 Answer 1

8

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

1
  • 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, 2017 at 11:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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