Oracle Team

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(…)

Dataguard Oracle 12.2: Keeping Physical Standby Sessions Connected During Role Transition

By Mouhamadou Diaw As of Oracle Database 12c Release 2 (12.2.0.1), when a physical standby database is converted into a primary you have the option to keep any sessions connected to the physical standby, without disruption, during the switchover/failover. When(…)

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,(…)

Oracle 12c – Combining Flashback Drop and Flashback Query

By William Sescu If you think that Flashback Drop feature just brings back your table, then this is only half of the story. It does much more than that. Besides undropping the table, it also brings back your constraints, your(…)

OEL 7 – How to disable IPv6 on Oracle Linux 7 – Follow Up

By William Sescu This is a follow up to the Blog were I explained how to disable IPv6 on Oracle Linux 7. If you have done all the steps which I have explained here http://dbi-services.com/blog/oel-7-how-to-disable-ipv6-on-oracle-linux-7/  then you have already(…)

Oracle 12c – Issues with the HEATMAP Segment even if the heat map feature is not used

By William Sescu When I don’t need I feature, I don’t turn it on, or do not use it because it reduces the possibility to run into issues. Most of the times this is true, however, during the preparation for(…)