Home » Server Options » Multitenant » Multitenant SHUTDOWN TRANSACTIONAL
Multitenant SHUTDOWN TRANSACTIONAL [message #603257] Thu, 12 December 2013 11:11 Go to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
According to http://docs.oracle.com/cd/E16655_01/server.121/e17636/cdb_pdb_admin.htm
Quote:
There is no SHUTDOWN command for a PDB that is equivalent to SHUTDOWN TRANSACTIONAL or SHUTDOWN ABORT for a non-CDB.


I can confirm that "SHUTDOWN TRANSACTIONAL" on a PDB works just fine, but I guess it's the same as a simple "SHUTDOWN" or "ALTER PLUGGABLE DATABASE...CLOSE".

What I would like to know is: will a SHUTDOWN TRANSACTIONAL on the CDB "cascade" to the transactions in the PDB's (similar to an RMAN backup on the CDB that will include data files from all PDB's)? Or will it selfishly only care about its own transactions?
Re: Multitenant SHUTDOWN TRANSACTIONAL [message #603259 is a reply to message #603257] Thu, 12 December 2013 11:50 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Found the answer myself:

It will not wait! Transactions (and sessions) on the PDB will simply be terminated.
SQL> shutdown transactional;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> insert into x values (1);

1 row created.

SQL> 
SQL> /
insert into x values (1)
            *
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 11355
Session ID: 17 Serial number: 205

Nice!?
Previous Topic: Effect on SDB on resizing a datafile on PDB
Next Topic: how to create Pluggable Database on another node
Goto Forum:
  


Current Time: Thu Mar 28 08:08:28 CDT 2024