Oracle 12c save state works only in open mode

Question

Hi DBA's,

I have a query. I am using below query to save the state of PDB's but it works only when CDB is in open state but fails in case of open read only. Even in case of open ready only the PDB's might be in read only or mounted state. Is there any work around or am i missing something?

"ALTER PLUGGABLE DATABASE ALL SAVE STATE"

Thanks for your help

Answer 1

The container has to be open for write otherwise the save state cannot be "saved" within the containers meta data.

also, can only save the state of READ ONLY or READ WRITE (not MOUNTED) pluggable databases.

finally, this function is only available in 12.1.0.2 (not 12.1.0.1)

hope this helps

Dave