CDB or PDB Open archive

Source: Internet
Author: User

11g How to open the archive, multi-tenant on how to open the archive just fine.

Applies to:oracle database-enterprise edition-version and laterinformation in this document applies to any PL Atform. Goalrunning 12c database and need to configure archive log, 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 has a dedicated instance (processes and memory areas) so they share CDB ' s ones. Configuring of Archivelog mode should is implemented in CDB.  For more details about how to configure the feature, please refer to below doc: Test <roidb01:cdb1:/home/oracle> $sqlplus/  As Sysdbasql*plus:release Production on Sat April 12:34:59 2018Copyright (c) 1982,, Oracle. All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release productionwith The partitioning, OLAP, Adva nced 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 NOS Ql> sql> Archive Log list;database log mode No archive Modeautomatic archival Disabledarchi ve destination/u01/app/oracle/product/12.1.0/dbhome_1/dbs/archoldest online log sequence 32Current log seq Uence 34sql> sql> alter system set log_archive_dest_1= ' location=/u01/app/oracle/product/12.1.0/dbhome_1/db S/arch '; System altered. Sql> Archive Log list;database log mode No archive modeautomatic archival disabledarchive dest           Ination/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 byte Sdatabase buffers 721420288 Bytesredo buffers 13852672 bytesdatabase mounted. sql> ALTER DATABASE Archivelog;D atabase 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 4-rw-r-----1 Oracle oinstall 1024x768 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 Destinat ion/u01/app/oracle/product/12.1.0/dbhome_1/dbs/archoldest Online log sequence 34Next log sequence to archive 36Current Lo G sequence 36sql> alter system switch logfile;alter system switch Logfile*error at line 1:ora-65040:operatio N not allowed from within a pluggable database

CDB or PDB open archive

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.