Database Reference
In-Depth Information
attempt to close a PDB with the SHUTDOWN command, no new connections will be allowed
to the PDB. NORMAL , IMMEDIATE , TRANSACTIONAL , and ABORT rules apply as in the CDB:
SQL> SHOW CON_NAME
CON_NAME
------------------------------
PDB1
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB1 READ WRITE
SQL> SHUTDOWN IMMEDIATE
Pluggable Database closed.
SQL> select name, open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB1 MOUNTED
SQL>
If there are pending transactions or any sessions connected to the current
PDB container, the SHUTDOWN TRANSACTIONAL command will wait until the
transactions are committed or rolled back and wait for the sessions to dis-
connect, and then SHUTDOWN will continue.
Closing a PDB
If you attempt to close the local PDB with the ALTER PLUGGABLE DATABASE CLOSE command
while users are connected to the PDB, the command will disallow new connections and
wait for existing sessions to disconnect. This is similar in function to the SHUTDOWN NORMAL
command. ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE behaves much like SHUTDOWN
IMMEDIATE , will end any sessions in the local PDB, and will shut down the PDB:
SQL> SHOW CON_NAME
CON_NAME
------------------------------
PDB1
Search WWH ::




Custom Search