千家信息网

CDB or PDB打开归档

发表于:2025-01-31 作者:千家信息网编辑
千家信息网最后更新 2025年01月31日,11g 怎么开归档,多租户就怎么打开归档就好了。APPLIES TO:Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
千家信息网最后更新 2025年01月31日CDB or PDB打开归档

11g 怎么开归档,多租户就怎么打开归档就好了。

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 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 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:测试$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 4-rw-r----- 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
0