OracleNotes

Datapump Import impdp in 12c includes a new parameter to disable logging during data import. This option could improve performance of import tremendously during large data loads.

The TRANSFORM=DISABLE_ARCHIVE_LOGGING is  used to disable logging. The value can be Y or N. Y to disable logging and N to enable logging. The second attribute specifies whether to exclude tables and/or indexes.

If the database is running with FORCE LOGGING enabled, data pump ignores disable logging request.

Examples:

Disable logging for tables and indexes:

impdp DIRECTORY=mydump DUMPFILE=hrtest.dmp \
  SCHEMAS=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

Disable logging for tables only:

impdp DIRECTORY=mydump DUMPFILE=hrtest.dmp SCHEMAS=hr \
   TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y:TABLE

or

impdp DIRECTORY=mydump DUMPFILE=hrtest.dmp SCHEMAS=hr \
    TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y \
    TRANSFORM=DISABLE_ARCHIVE_LOGGING:N:INDEX

 

 

Oracle11g Grid Infrastructure introduced SYSASM administrative privilege, in 12c we have 3 more administrative privileges… SYSBACKUP, SYSDG, SYSKM.

SYSDBA, SYSOPER and SYSASM privileges and behavior are similar to 11gR2 in 12c database as well.

SYSBACKUP administrative privilege has ability to perform RMAN backup and recovery operations, database startup and shutdown. This administrative user connects to the database as SYSBACKUP user [remember SYSDBA and SYSASM connect to the database as SYS user]. Read list of privileges for SYSBACKUP in Oracle Documentation.

SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl. This administrative privilege connects to the database as SYSDG user. Read list of privileges for SYSDG in Oracle Documentation.

SYSKM administrative privilege has ability to perform transparent data encryption wallet operations. This privilege connects to the database as SYSKM user. Read list of privileges for SYSKM in Oracle Documentation.

The new default users SYSBACKUP, SYSDG and SYSKM cannot be dropped.

With the introduction of new administrative privileges, the super administrator privilege SYSDBA should be used only for major operations such as upgrade.

The Unified Audit Trail captures all activities by administrative users.