11g 怎么開歸檔，多租戶就怎么打開歸檔就好了。

創(chuàng)新互聯(lián)服務項目包括松溪網站建設、松溪網站制作、松溪網頁制作以及松溪網絡營銷策劃等。多年來，我們專注于互聯(lián)網行業(yè)，利用自身積累的技術優(yōu)勢、行業(yè)經驗、深度合作伙伴關系等，向廣大中小型企業(yè)、政府機構等提供互聯(lián)網行業(yè)的解決方案，松溪網站推廣取得了明顯的社會效益與經濟效益。目前，我們服務的客戶以成都為中心已經輻射到松溪省份的部分城市，未來相信會繼續(xù)擴大服務區(qū)域并繼續(xù)獲得客戶的支持與信任！

APPLIES TO:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.
GOAL

Running 12c database and need to configure archive log, shall we configure it in PDB or CDB?

SOLUTION

All 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:

測試
<roidb01:cdb1:/home/oracle>$sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sat Mar 10 12:34:59 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11                          READ WRITE NO

SQL> 
SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch
Oldest online log sequence     32
Current log sequence           34
SQL> 
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 Mode
Automatic archival             Disabled
Archive destination            /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch
Oldest online log sequence     32
Current log sequence           34
SQL>     

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1174405120 bytes
Fixed Size                  2923680 bytes
Variable Size             436208480 bytes
Database Buffers          721420288 bytes
Redo Buffers               13852672 bytes
Database 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/arch
total 4
-rw-r----- 1 oracle oinstall 1024 Mar 10 17:37 1_35_965910550.dbf

SQL> 

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB11                          MOUNTED
SQL> alter session set container=PDB11;

Session altered.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch
Oldest online log sequence     34
Next log sequence to archive   36
Current log sequence           36
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

當前標題：CDBorPDB打開歸檔
當前網址：http://www.chinadenli.net/article38/pescsp.html

成都網站建設公司_創(chuàng)新互聯(lián)，為您提供微信公眾號、靜態(tài)網站、關鍵詞優(yōu)化、響應式網站、商城網站、網站策劃

廣告

聲明：本網站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)