OraFAQ Forum: Multitenant » Multitenant SHUTDOWN TRANSACTIONAL

Home » Server Options » Multitenant » Multitenant SHUTDOWN TRANSACTIONAL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multitenant SHUTDOWN TRANSACTIONAL [message #603257]

Thu, 12 December 2013 11:11

Frank Naude
Messages: 4571
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?

Report message to a moderator

Re: Multitenant SHUTDOWN TRANSACTIONAL [message #603259 is a reply to message #603257]

Thu, 12 December 2013 11:50

Frank Naude
Messages: 4571
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!?

Report message to a moderator

Previous Topic:	Effect on SDB on resizing a datafile on PDB
Next Topic:	how to create Pluggable Database on another node

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 29 07:31:03 CST 2023