Oracle 12c

Purging Unified Audit Trail in 12cR1

By Franck Pachot . When you want to empty a table you have two methods: delete and truncate. If, for any reason (see previous post) the Unified Audit Trail has become too big, you cannot directly delete or truncate(…)

Oracle 12c – Is VKTM always your top process?

By William Sescu If VKTM is always your top cpu consuming process, then this blog might be something for you. Especially in virtual environments, I have seen often the VKTM process as the top process, even if the VM was(…)

Oracle 12c – How to Recover lost DataGuard Broker Configuration Files

By William Sescu If you are using RMAN to back up your database, you are already doing the right thing. However, RMAN does not take care of everything. e.g. it is not backing up the following things, to mention just(…)

Oracle 12cR2: Online tablespace encryption

By Franck Pachot . By default, all data is visible in the datafiles. Transparent Tablespace Encryption (TDE) can be used to get them encrypted. It requires Enterprise Edition plus Advanced Security Option. Except in the Oracle Cloud when it is(…)

12cR2: Recover nonlogged blocks after NOLOGGING in Data Guard

By Franck Pachot . You can accept to do NOLOGGING operations on bulk loads or index build according that you do a backup just after, and that your recovery plan mentions how to load the data again in case(…)

Oracle 12c – Recreating a Controlfile in a Data Guard environment with noresetlogs

By William Sescu Sometimes you might run into situations where the controlfile does not represent the backups and archivelogs correctly, because of a mismatch of the control_file_record_keep_time and the RMAN retention. The controlfile has non circular and a circular records.

12c Unified Auditing and AUDIT_TRAIL=DB in mixed mode

By Franck Pachot . Oracle enables some auditing by default, and if you don't do anything, the tables where it is stored will grow in SYSAUX. Don't wait to get an alert when it is too late. Everything that fills(…)

12cR2: lockdown profiles and ORA-01219

By Franck Pachot . When you cannot open a database, you will get some users unhappy. When you cannot open multitenant database, then the number of unhappy users is multiplied by the number of PDBs. I like to encounter problems(…)

Oracle 12c – How to correct the error: “RMAN-20005: target database name is ambiguous”

By William Sescu I do have a Data Guard environment, where I have configured the RMAN DB_UNIQUE_NAME persistent setting for my primary and the standby. With the RMAN DB_UNIQUE_NAME settings I am able to run reports my Oracle Data Guard(…)

12cR2 real-time materialized view (on query computation)

By Franck Pachot . Materialized views is a very old feature (you may remember that it was called snapshots a long time ago). It has all advantages of a view, as you can define any select statement that joins, filters,(…)