Oracle Utilities - OCP: Oracle Database 12c Administrator Certified Professional - page 616

Summary
In this chapter, you learned about the Oracle Database 12 c Utility programs and how they
work in the multitenant architecture. You learned more about how Oracle Data Pump can
be used to migrate database content from a non-CDB into a PDB and how to migrate con-
tent between PDBs within a CDB or across CDBs. You learned how to use SQL*Loader to
load data stored in flat files into a PDB within a CDB, building on the knowledge gained in
previous chapters. You learned about the components of SQL*Loader, the record formats,
the parameters, the control file and data files, and the advantages of the direct path load
over the conventional path load. You also learned how to use SQL*Loader express mode,
which is basically running SQL*Loader with a streamlined configuration to load data.
In this chapter, we discussed audit operations that are pertinent to the multitenant envi-
ronment, discussing local and common audit policies. We discussed how auditing can be
applied to the utilities introduced in this chapter, specifically Data Pump and SQL*Loader
direct path mode activities.
In the last section of this chapter, we introduced other Oracle products that have unique
characteristics in the multitenant environment. We introduced Database Vault as a means
to provide a higher level of protection of sensitive or confidential application data that is
stored in Oracle Database schemas. We also provided an example of how to plug a vault-
enabled database into a CDB environment.
Next, we introduced the Oracle Data Guard option, which provides high availability
through the implementation of one or more standby databases that are kept up to date with
the primary database. You learned that Oracle Data Guard applies to the entire CDB and
all the PDBs that are within the CDB. We introduced physical and logical standby data-
bases, and we discussed how to create a PDB in the primary and synchronize it with the
standby databases.
Finally, we introduced Oracle LogMiner, which uses SQL to query online and archived
redo log files to determine the history of activity in the database. LogMiner can be used to
determine how logical corruption occurred, determine how to perform fine-grained recovery
of specific rows of data, determine table activity rates, and track (audit) user activities in the
database. You learned about the new CDB-related views for LogMiner.
Exam Essentials
Know the components of Data Pump in the Oracle Database 12 c multitenant architecture.
Make sure you understand the different components of Data Pump, including the programs
and types of files.
Understand how to use Data Pump with CDBs. Know that you use Data Pump to move
content into a PDB, a non-CDB into a PDB, or one PDB into another PDB.
Know the components of SQL*Loader. Understand the different components of SQL*Loader.