6
PDBs and Local Objects PDBs also own local objects PDBs have a local SYSTEM and SYSAUX tablespace PDBs may have their own local TEMP tablespace PDBs can own one or more application schemas: Local tablespaces Local users and roles PDBs own all application objects within their schemas By default, PDBs can only see their own objects PDB1 PDB3 PDB2 CDB1 SYSTEM SYSAUX TEMP SYSTEM SYSAUX TEMP SYSTEM SYSAUX TEMP AP_DATA HR_DATA MFG_DATA AP_ROLE AP HR_ROLE HR MFG_ROLE MFG

8
Sharing: Its a Good Thing! Sharing common resources - when it makes sense - tends to reduce contention as well as needless resource over-allocation: Not all PDBs demand high CPU cycles Not all PDBs have same memory demands Not all PDBs have same I/O bandwidth needs DSS/DW: MBPS OLTP: IOPS and Latency Result: More instances with less hardware

17
Cloning From the PDB Seed Database From CDB1 instances alert log: Mon Mar 31 08:02:52 2014 ALTER SYSTEM: Flushing buffer cache inst=0 container=3 local Pluggable database PROD_AP closed Completed: ALTER PLUGGABLE DATABASE prod_ap CLOSE IMMEDIATE ALTER PLUGGABLE DATABASE prod_ap OPEN READ ONLY Mon Mar 31 08:03:03 2014 Due to limited space in shared pool (need 6094848 bytes, have 3981120 bytes), limiting Resource Manager entities from 2048 to 32 Opening pdb PROD_AP (3) with no Resource Manager plan active Pluggable database PROD_AP opened read only Completed: ALTER PLUGGABLE DATABASE prod_ap OPEN READ ONLY CREATE PLUGGABLE DATABASE qa_ap FROM prod_ap Mon Mar 31 08:06:16 2014 **************************************************************** Pluggable Database QA_AP with pdb id - 4 is created as UNUSABLE. If any errors are encountered before the pdb is marked as NEW, then the pdb must be dropped **************************************************************** Deleting old file#8 from file$ Deleting old file#9 from file$ Deleting old file#10 from file$... Deleting old file#21 from file$ Deleting old file#22 from file$ 2 2 3 3 > > Adding new file#23 to file$(old file#8) Adding new file#24 to file$(old file#9)... Adding new file#28 to file$(old file#14) Marking tablespace #7 invalid since it is not present in the describe file Marking tablespace #8 invalid since it is not present in the describe file Marking tablespace #9 invalid since it is not present in the describe file... Marking tablespace #12 invalid since it is not present in the describe file Marking tablespace #13 invalid since it is not present in the describe file Marking tablespace #14 invalid since it is not present in the describe file Successfully created internal service qa_ap at open ALTER SYSTEM: Flushing buffer cache inst=0 container=4 local **************************************************************** Post plug operations are now complete. Pluggable database QA_AP with pdb id - 4 is now marked as NEW. **************************************************************** Completed: CREATE PLUGGABLE DATABASE qa_ap FROM prod_ap

23
Upgrating* a Non-CDB To a PDB A pre-12cR1 database can be upgrated* to a 12cR1 PDB Either … Upgrade the source database to 12cR1 non-CDB Plug upgraded non-CDB into existing CDB as new PDB … or: Clone new empty PDB into existing CDB from PDB$SEED Migrate data from source database to newly-cloned PDB *WARNING: As a member of POEM, I am qualified to make up words. For your own safety, please do not try this without a certified POEM member present; poor grammar and misspelling may result.

27
Backup, Restore, and Recover Non-CDBs, CDBs, and PDBs Image copy backups now support multi-section, multi-channel BACKUP operations SECTION SIZE directive fully supported Faster image copy file creation What is backed up in multiple section(s) … …can be restored in multi-channel fashion more quickly Backups for TTS can now be taken with tablespace set open in READ WRITE mode