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.
#Check database startup time oracle upgrade#
The following commands are available to open and close the current PDB when connected to the PDB as a privileged user.ĪLTER PLUGGABLE DATABASE OPEN READ WRITE ĪLTER PLUGGABLE DATABASE OPEN READ ONLY ĪLTER PLUGGABLE DATABASE OPEN UPGRADE ĪLTER PLUGGABLE DATABASE CLOSE ĪLTER PLUGGABLE DATABASE OPEN READ ONLY FORCE ĪLTER PLUGGABLE DATABASE CLOSE IMMEDIATE ĪLTER PLUGGABLE DATABASE OPEN READ WRITE The ALTER PLUGGABLE DATABASE command can be used from the CDB or the PDB. SHUTDOWN IMMEDIATE ALTER PLUGGABLE DATABASE
The following SQL*Plus commands are available to start and stop a pluggable database, when connected to that pluggable database as a privileged user. Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command. The SQL*Plus STARTUP and SHUTDOWN commands are available when connected to the CDB as a privileged user. Startup and shutdown of the container database is the same as it has always been for regular instances. Hybrid Read-Only Mode for PDBs in Oracle Database 23c.Multitenant : Startup and Shutdown of CDBs and PDBs.Preserve PDB Startup State (12.1.0.2 onward).Pluggable Database (PDB) Automatic Startup.
#Check database startup time oracle how to#
This article demonstrates how to startup and shutdown container databases (CDB) and pluggable databases (PDB).
The multitenant option introduced in Oracle Database 12c allows a single container database (CDB) to host multiple separate pluggable databases (PDB). All rights reserved.Home » Articles » 12c » Here Multitenant : Startup and Shutdown Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1) Digital Marketing WordPress Theme © Copyright 2020 - 2022, DBsGuru.
0 kommentar(er)
