The following commands are available to open and close one or more PDBs when connected to the CDB as a privileged user. 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.
#Oracle db startup time 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). Home » Articles » 12c » Here Multitenant : Startup and Shutdown Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1)
0 kommentar(er)
