Shulou(Shulou.com)06/01 Report--

As long as 11g opens the archive, multi-tenants just open the archive.

APPLIES TO:Oracle Database-Enterprise Edition-Version 12.1.0.1 and laterInformation in this document applies to any platform.GOALRunning 12c database and need to configure archivelog, shall we configure it in PDB or CDB?SOLUTIONAll 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: test $sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 10 12:34:59 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, OLAP Advanced Analytics and Real Application Testing optionsSQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED- 2 PDB$SEED READ ONLY NO 3 PDB11 READ WRITE NOSQL > SQL > archive log list Database log mode No Archive ModeAutomatic archival DisabledArchive destination / u01/app/oracle/product/12.1.0/dbhome_1/dbs/archOldest online log sequence 32Current log sequence 34SQL > SQL > alter system set log_archive_dest_1='location=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch';System altered.SQL > archive log list Database log mode No Archive ModeAutomatic archival DisabledArchive destination / u01/app/oracle/product/12.1.0/dbhome_1/dbs/archOldest online log sequence 32Current log sequence 34SQL > SQL > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL > startup mount ORACLE instance started.Total System Global Area 1174405120 bytesFixed Size 2923680 bytesVariable Size 436208480 bytesDatabase Buffers 721420288 bytesRedo Buffers 13852672 bytesDatabase mounted.SQL > alter database archivelog; Database altered.SQL > alter database open;Database altered.SQL > SQL > alter system switch logfile System altered.SQL >! ls-l / u01/app/oracle/product/12.1.0/dbhome_1/dbs/archtotal 4murr RWMurr-1 oracle oinstall 1024 Mar 10 17:37 1_35_965910550.dbfSQL > SQL > show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED -2 PDB$SEED READ ONLY NO 3 PDB11 MOUNTEDSQL > alter session set container=PDB11 Session altered.SQL > archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination / u01/app/oracle/product/12.1.0/dbhome_1/dbs/archOldest online log sequence 34Next log sequence to archive 36Current log sequence 36SQL > alter system switch logfile;alter system switch logfile*ERROR at line 1:ORA-65040: operation not allowed from within a pluggable database

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.