Hello,
I am testing the PDB automatic startup, introduced in 12.1.0.2 and I have noticed that when the CDB is in READ ONLY mode, the information from dba_pdb_saved_states is ignored:
SQL> /
CON_ID NAME OPEN_MODE RES
---------- ------------------------------ ---------- ---
1 CDB$ROOT READ ONLY NO
2 PDB$SEED READ ONLY NO
3 PDB1_12C MOUNTED
SQL> SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
CON_NAME INSTANCE_NAME STATE
-------------------- -------------------- --------------
PDB1_12C cdb12c OPEN
SQL> shutdown immediate;
SQL> startup
ORACLE instance started.
Database mounted.
Database opened.
SQL> select con_id,name,open_mode,restricted, open_time from v$containers;
CON_ID NAME OPEN_MODE RES
---------- ------------------------------ ---------- ---
1 CDB$ROOT READ WRITE NO
2 PDB$SEED READ ONLY NO
3 PDB1_12C READ WRITE NO
SQL> SELECT con_name, instance_name, state FROM dba_pdb_saved_states;
CON_NAME INSTANCE_NAME STATE
-------------------- -------------------- --------------
PDB1_12C cdb12c OPEN
Is this the correct behavior? I have tried to search the documentation, but I think I am missing something.