--CDB内：

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 SAMPDB                         MOUNTED

         5 PDB2                           MOUNTED

SQL> alter database add logfile thread 1 group 43 '/u01/app/oracle/oradata/PROD/redo01_1.log' size 10m;

Database altered.

-- 切换到pdb

SQL> alter session set container=pdb2;

Session altered.

SQL> alter database add logfile thread 1 group 44 '/u01/app/oracle/oradata/PROD/redo01_1.log' size 10m;

alter database add logfile thread 1 group 44 '/u01/app/oracle/oradata/PROD/redo01_1.log' size 10m

*

ERROR at line 1:

ORA-65040: operation not allowed from within a pluggable database

你要加的日志组pdb状态为mount，需要切换pdbs状态，alter database pluggable all open；然后切到

指定的pdbs里进行操作，alter session  set container=PDB2；

alter databse add logfile thread 1 group 1 ('+DATADG') size 2G;