摘要：以启动DB12为例子 1.nomount阶段 2.mount阶段：打开控制文件，Root和pdbs都被mount起来 3.open阶段：root被打开，pdbs仍然是mounted状态，seed pdb处于只读状态 4.打开PDB 阅读全文
Oracle 12C -- 统一启动/关闭PDBs
2015-11-01 16:02 by abce, 1043 阅读, 0 推荐, 收藏,
摘要：SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE ------------------------------ ---------- PDB$SEED READ ONLY PDB1 MOU... 阅读全文
Oracle 12C -- 不同容器之间切换
2015-11-01 15:44 by abce, 1311 阅读, 0 推荐, 收藏,
摘要：1.使用connect 2.使用alter session 阅读全文
Oracle 12C -- 删除PDB
2015-10-31 14:59 by abce, 2737 阅读, 0 推荐, 收藏,
摘要：删除PDB SQL> select con_id,pdb_name,status from cdb_pdbs; CON_ID PDB_NAME STATUS ---------- ------------------------------ ---------... 阅读全文
Oracle 12C -- plug unplugged PDB into CDB
2015-10-31 14:46 by abce, 840 阅读, 0 推荐, 收藏,
摘要：connetct to CDB as a common user and verify that pdb_test is closed A PDB must be dropped from the CDB before it can be plugged back into the same CDB 阅读全文
Oracle 12C -- clone a remote pdb
2015-10-31 13:52 by abce, 687 阅读, 0 推荐, 收藏,
摘要：Connect to the remote CDB and prepare the remote PDB for cloning. Create a user in the remote database for use with the database link. In this case, w 阅读全文
Oracle 12C -- clone a non-cdb as a pdb
2015-10-31 12:43 by abce, 618 阅读, 0 推荐, 收藏,
摘要：将non-CDB置为只读模式： 连接到CDB，创建一个DBLINK，连接到non-cdb： 克隆non-cdb，并执行脚本： 打开克隆好的数据库： 阅读全文
Oracle 12C -- 使用local PDB克隆新的PDB
2015-10-30 17:08 by abce, 687 阅读, 0 推荐, 收藏,
摘要：1.将用于克隆的PDB至于只读状态：startup open read only 2.登陆CDB 3.打开原来的PDB 阅读全文
Oracle 12C -- Plug in a Non-CDB as a PDB
2015-10-30 16:45 by abce, 351 阅读, 0 推荐, 收藏,
摘要：1.备份non-CDB数据库2.关闭non-CDB数据库 3.将non-CDB至于只读状态 4.创建一个XML文件(在non-CDB中创建) 这里创建的xml文件和原库的数据文件组成了一个unplugged PDB 5.关闭non-CDB数据库6.登陆CDB 阅读全文
ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged
2015-10-30 14:45 by abce, 2931 阅读, 0 推荐, 收藏,
摘要：SQL> drop pluggable database pdb2; drop pluggable database pdb2 * ERROR at line 1: ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged SQL> drop pluggable database pdb2 ... 阅读全文
浙公网安备 33010602011771号