Pluggable Database status ....

On Oracle Database 12c Enterprise Edition Release 12.2.0.1.0

SQL> def

DEFINE _DATE           = "23-07-2017 07:16:22" (CHAR)

DEFINE _O_VERSION      = "Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production" (CHAR)

DEFINE _O_RELEASE      = "1202000100" (CHAR)

set head off verify off echo off pages 1500 linesize 120 feedback off

alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';

select

'PDB_ID..................................................: '||PDB_ID ,

'PDB_NAME................................................: '||PDB_NAME ,

'DBID....................................................: '||DBID ,

'CON_UID.................................................: '||CON_UID,

'GUID....................................................: '||GUID ,

'STATUS..................................................: '||STATUS,

'CREATION_SCN............................................: '||CREATION_SCN,  

'VSN.....................................................: '||VSN, 

'LOGGING ................................................: '||LOGGING ,  

'FORCE_LOGGING ..........................................: '||FORCE_LOGGING ,

'FORCE_NOLOGGING ........................................: '||FORCE_NOLOGGING, 

'APPLICATION_ROOT........................................: '||APPLICATION_ROOT,  

'APPLICATION_PDB.........................................: '||APPLICATION_PDB, 

'APPLICATION_SEED........................................: '||APPLICATION_SEED,

'APPLICATION_ROOT_CON_ID.................................: '||APPLICATION_ROOT_CON_ID,

'IS_PROXY_PDB............................................: '||IS_PROXY_PDB,

'CON_ID..................................................: '||CON_ID, 

'UPGRADE_PRIORITY........................................: '||UPGRADE_PRIORITY,

'APPLICATION_CLONE.......................................: '||APPLICATION_CLONE,

'FOREIGN_CDB_DBID........................................: '||FOREIGN_CDB_DBID,

'UNPLUG_SCN..............................................: '||UNPLUG_SCN,

'FOREIGN_PDB_ID..........................................: '||FOREIGN_PDB_ID,

'CREATION_TIME...........................................: '||CREATION_TIME, 

'REFRESH_MODE............................................: '||REFRESH_MODE,

'REFRESH_INTERVAL........................................: '||REFRESH_INTERVAL

from CDB_PDBS

where 1=1

-- and PDB_ID=3

;

PDB_ID..................................................: 3

PDB_NAME................................................: ANUJ

DBID....................................................: 2259250378

CON_UID.................................................: 2259250378

GUID....................................................: 54F57A42B6BF1AD0E055000000000001

STATUS..................................................: NORMAL

CREATION_SCN............................................: 1524245

VSN.....................................................: 203424000

LOGGING ................................................: LOGGING

FORCE_LOGGING ..........................................: NO

FORCE_NOLOGGING ........................................: NO

APPLICATION_ROOT........................................: NO

APPLICATION_PDB.........................................: NO

APPLICATION_SEED........................................: NO

APPLICATION_ROOT_CON_ID.................................:

IS_PROXY_PDB............................................: NO

CON_ID..................................................: 3

UPGRADE_PRIORITY........................................:

APPLICATION_CLONE.......................................: NO

FOREIGN_CDB_DBID........................................: 1477822556

UNPLUG_SCN..............................................: 1523784

FOREIGN_PDB_ID..........................................: 2

CREATION_TIME...........................................: 23-07-2017 05:24:43

REFRESH_MODE............................................: NONE

REFRESH_INTERVAL........................................:

set linesize 200 

SET SERVEROUTPUT ON

col NAME for a30

COLUMN "RESTRICTED" FORMAT A10

select

d.PDB_ID,

v.name,

v.open_mode,

nvl(v.restricted, 'n/a') "RESTRICTED",

d.status from v$pdbs v , dba_pdbs d

where 1=1

and v.guid=d.guid

order by v.create_scn;

    PDB_ID NAME                           OPEN_MODE  RESTRICTED STATUS

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

         2 PDB$SEED                       READ ONLY  NO         NORMAL

         3 ANUJ                           MOUNTED    n/a        NORMAL

         4 ANUJ1                          READ WRITE NO         NORMAL