[20140613]12c PDB数据库与shutdown abort.txt
D:\tools\rlwrap>sqlplus sys/XXXXX@test01p as sysdba
sqlplus sys/btbtms@test01p as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Fri Jun 13 21:49:26 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SYS@test01p> @ver
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
SYS@test01p> select * from scott.dept1;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SYS@test01p> update scott.dept1 set loc=lower(loc);
4 rows updated.
SYS@test01p> shutdown abort
Pluggable Database closed.
SYS@test01p> alter session set container=cdb$root;
Session altered.
SYS@test01p> # alter pluggable database all open;
Pluggable database altered.
SYS@test01p> alter session set container=test01p;
Session altered.
SYS@test01p> select * from scott.dept1;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING new york
20 RESEARCH dallas
30 SALES chicago
40 OPERATIONS boston
--可以发现shutdown abort在会话里面暗含有一个commit.当然这个在1个会话(user=sys)里面,如果没有在一个会话里面,就没有这个现象.