10/13/2023 0 Comments Check database startup time oracleNext, we open both pluggable databases, but only save the state of PDB1.ĪLTER PLUGGABLE DATABASE pdb1 SAVE STATE Notice the PDBs are in READ WRITE mode before the restart, but in MOUNTED mode after it. We will start off by looking at the normal result of a CDB restart. This is done using the ALTER PLUGGABLE DATABASE command. The 12.1.0.2 patchset introduced the ability to preserve the startup state of PDBs through a CDB restart. Preserve PDB Startup State (12.1.0.2 onward) You can customise the trigger if you don't want all of your PDBs to start. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.ĮXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN' There is no default mechanism to automatically start them when the CDB is started. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn't be implementing a trigger in the manner discussed in this section.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |