Oracle Database 12c and 18c的创新：实现更好的数据管理.pptx

Advanced Innovation of Oracle Database 12c and Oracle Database 18c: Better Data Management;Introduction;Presentation Objectives: ;Security;Major Challenges;Administrative Privileged Users;New information in the new 12c format Account status Last successful login time Authentication method used Enhancements enforced on application common and local administrative users in the CDB and PDBs;Privilege Analysis;;Privilege Checking: Using INHERIT REMOTE PRIVILEGES;BEQUEATH DEFINER View ;Oracle Database 12c Auditing;Security and Performance: Audit Architecture;Consolidation;Simplicity: Audit Policy;DBMS_FLASHBACK_ARCHIVE;History or archive tables: Compressed and deduplicated;User Context Metadata;;Available Redaction Methods;Oracle Data Redaction: Examples;Benefits of Transparent Sensitive Data Protection (TSDP);Protecting Sensitive Data with TSDP and Other Security Features;Schema-Only Account;External directories store user credentials and authorizations in a central location (LDAP-compliant directory, such as OID, OUD, and OVD). Eases administration through centralization Enables single-point authentication Eliminates the need for client-side wallets Example: User changes job roles. Security administrator changes the user roles in Oracle Virtual Directory. No changes are made to the services that the user accesses.;Choosing Between EUS and CMU;Backup and Recovery using RMAN ;Backing Up and Restoring Very Large Files;Recovering Databases by Using Third-Party Snapshots;Duplicating an Active Database;Transporting Data Across Platforms;Encrypted Tablespaces Transportability;Table Recovery from RMAN Backups;Oracle Data Pump, SQL*Loader, and External Tables;Full Transportable Export/Import: Overview;Full Transportable Export/Import: Usage;Disabling Logging for Oracle Data Pump Import;Exporting Views as Tables;Specifying the Encryption Password;Compressing Tables During Import;Enables multiple workers to perform metadata and data export and import operations at the same tim