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