Oracle 12c Upgrade: 03 – Configuring and Creating CDBs and PDBs

Card Set Information

Author:
Tralala
ID:
295970
Filename:
Oracle 12c Upgrade: 03 – Configuring and Creating CDBs and PDBs
Updated:
2015-04-20 02:56:29
Tags:
Oracle 12c Upgrade Configuring Creating CDBs PDBs
Folders:

Description:
Oracle 12c Upgrade: 03 – Configuring and Creating CDBs and PDBs
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. What is required to use Multitenant Architecture?
    Enterprise Edition and the Multitenant Option
  2. How many PDB can a CDB hold?
    Zero, One or up to 252
  3. What containers form a CDB?
    • Root Container CDB$ROOT 1
    • Seed Container PDB$SEED 1
    • User Container PDBs 0-252
  4. How many CDB's per instance?
    1
  5. What is the difference between root SYSTEM and pdb SYSTEM tablespaces?
    • root SYSTEM holds Oracle metadata
    • pdb SYSTEM holds User metadata
  6. What doesn't a PDB have?
    • Background processes
    • undo tablespace, it uses the CDB’s.
    • Redologs, it uses the CDB’s.
    • Controlfiles
  7. What is unique to a PDB?
    • It’s own tablespaces
    • It’s own local users and local roles
    • It’s own metadata
  8. How does Data Guard interact with a Multitenant Architecture?
    Configured for the entire CDB not individual PDBs
  9. What structures are optional in a PDB?
    • A temporary tablespace or can use the CDB temporary tablespace.
    • It’s own Resource Manager Plan or can use the default CDB one.
  10. In a CDB environment, describe users?
    Users can be common users (at the CDB level) or local users (local to a PDB)
  11. At which level is patching done?
    CDB
  12. How does multitenant architecture change the way database connections are made?
    This doesn’t change the way to connect to the database,
  13. To create a CDB which initialization parameter must be set to allow the creation of PDBs?
    ENABLE_PLUGGABLE_DATABASE=TRUE
  14. What are the default containers created when CDB is created?
    • CDB$ROOT and PDB$SEED
    • PDBs are optional
  15. In what ways can a PDB be created?
    • By plugging in a PDB into the container.
    • By cloning another PDB inside the same CDB : CREATE PLUGGABLE DATABASE NEW_PDB FROM OTHER_PDB;
    • By issuing the : CREATE PLUGGABLE DATABASE NEW_PDB;.
  16. When creating a PDB, what role is given to the admin user?
    PDB_DBA
  17. In views, which CON_IDs identify ROOT and SEED?
    • CON_ID=1 state for the CDB$ROOT
    • CON_ID=2 for the PDB$SEED
  18. Which view lists CDB$ROOT, the PDB$SEED and all the PDBs created?
    V$CONTAINERS
  19. Which view would show the OPEN_MODE, OPEN_TIME and TOTAL_SIZE for CDB and PDBs
    V$CONTAINERS
  20. What are the CDB_ equivalent of?
    DBA_ views
  21. What column do all the CDB_ have?
    CON_ID column to identify which container it belongs to.
  22. To unplug a PDB you must follow what steps?
    • close the PDB : alter pluggable database mypdb close;
    • unplug the pdb : alter pluggable database mypdb unplug into ‘mypdb.xml';
  23. To plug a PDB you must issue what command?
    create pluggable database new_pdb using ‘/tmp/unplugged_pdb.xml';
  24. To drop a PDB you must follow what steps?
    • close the PDB : alter pluggable database mypdb close;
    • drop the PDB : drop pluggable database mypdb including datafiles
  25. What package is used to convert a standard database to a PDB?
    DBMS_PDB
  26. What does the DBMS_PDB.DESCRIBE procedure do?
    Creates the XML metadata file containing information about TABLESPACE, DATAFILES, OPTIONS, PARAMETERS of a Non-CDB database.
  27. What is the command to create a pluggable database from seed?
    • CREATE PLUGGABLE DATABASE PDB02
    • ADMIN USER pdb_adm
    • IDENTIFIED BY Password1
    • FILE_NAME_CONVERT=('/data/oradata/CDB01/pdbseed/','/data/oradata/CDB01/PDB02/');
  28. What is the difference between FILE_NAME_CONVERT and PDB_FILE_NAME_CONVERT?
    • FILE_NAME_CONVERT is stated in the CREATE PLUGGABLE DATABASE COMMAND
    • PDB_FILE_NAME_CONVERT is an initialization parameter and sets the filename convert for the PDB at session level so FILE_NAME_CONVERT does not have to be called.
  29. What are the two main PDB views?
    DBA_PDBS and V$PDBS
  30. How is a PDB opened?
    ALTER PLUGGABLE DATABASE PDB02 OPEN ....
  31. If a PDB has an status of NEW, how is this changed to READ WRITE?
    Open the PDB READ WRITE
  32. What are the steps to clone a PDB?
    • Close source
    • Open source read only
    • Run CREATE PLUGGABLE DATABASE target FROM source with FILE_NAME_CONVERT to copy files to source
    • Close source
    • Open source read write
  33. What are the steps to unplug a PDB
    • Close PDB
    • Create XML with ALTER PLUGGABLE DATABASE PDB03 UNPLUG INTO '/tmp/db01.xml'
    • Drop the PDB, but keep datafiles DROP PLUGGABLE DATABASE DB01 KEEP DATAFILES;
  34. What are the steps to plug in a PDB
    • Check compatibility of the XML file using DBMS_PDB.check_plug_compatibility procedure
    • Copy datafiles into location
    • Run CREATE PLUGGABLE DATABASE PDB03 USING '/tmp/db01.xml'
  35. How is a pluggable database removed?
    • ALTER PLUGGABLE DATABASE DB03 CLOSE;
    • DROP PLUGGABLE DATABASE DB03 INCLUDING DATAFILES;
    • or
    • DROP PLUGGABLE DATABASE DB03 KEEP DATAFILES;
  36. How is a Non-container database migrated to a PDB?
    • Shutdown non-container database
    • Startup non-container database read only
    • Run DBMS_PDB.DESCRIBE to create XML
    • Shutdown non-container database
    • Run CREATE PLUGGABLE DATABASE PDBXXX USING
    • Run noncdb_to_pdb.sql against the new PDB
  37. What is a PDBA?
    A pluggable database administrator
  38. To how many containers can a permanent tablespace be associated?
    One
  39. How is EM Express used to create a PDB?
    It can't
  40. How is a seed container modified?
    It can't be modified
  41. What are the Oracle-supplied common users created in all containers?
    SYS and SYSTEM
  42. How are the attributes of the SEED database datafiles defined?
    • At CDB creation
    • Cannot be altered once the database is created
  43. How can Transportable tablespace/Database be used plug a non-CDB into a CDB?
    • TTS or TDB export the non-CDB
    • Create to new CDB to host the non-CDB
    • Connect to new PDB and import dump flle and data files
  44. Where should application schemas and objects be stored in a Multitenant environment?
    In a PDB
  45. Which view shows reasons for any incompatibility that prevents the plugging of a PDB?
    PDB_PLUGIN_VIOLATIONS
  46. What can Oracle Golden Gate Replication allow?
    Plug a Non-CDB into a PDB.
  47. When SHUTDOWN is issued in a PDB, what state will be PDB be in?
    MOUNT
  48. What script is run as the last stage of plugging in a Non-CDB?
    noncdb_to_pdb.sql

What would you like to do?

Home > Flashcards > Print Preview