[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)里面,如果没有在一个会话里面,就没有这个现象.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-1191459/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-1191459/