[20140613]12c PDB資料庫與shutdown abort

[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)裡面,如果沒有在一個會話裡面,就沒有這個現象.