Oracle

Oracle University Istanbul Expert Summit 2014

We had greate 3 days with the experts in their field. Pete Finnigan with great focus on Security. Database design according to the security principles. He also mentioned¬†encryption, leakage of critical data, dangerous functions and use of incorrect privileges. Jonathan Lewis gave tons of examples from simple ones to complex ones and show how to… Continue reading Oracle University Istanbul Expert Summit 2014

Oracle · PL/SQL - SQL

ORA-4068 Errors for Valid Objects

Compilation of oracle objects are pretty easy where there is no activity on the database. If the objects are heavily accessed and the compilation takes place then you should be prepared for the worst case scenarios.Depending on the object dependency and access rates, sometimes downtime is required. Offline the system and compile the objects and… Continue reading ORA-4068 Errors for Valid Objects

Dataguard · Oracle · RMAN

Restore Corrupt Datafile using Another Standby

If there is a corruption on one of the datafiles on a dataguard you can restore the corruption using another dataguard. I will explain how to do the restore operation in rman using oracle 11.2. ON THE WORKING DATAGUARD Backup the datafile as image copy. RMAN> BACKUP AS COPY DATAFILE 178 FORMAT “+data/test2/datafile/test_datafile178”; Uncatalog the… Continue reading Restore Corrupt Datafile using Another Standby

Exadata · Oracle

When is the last time you changed a flashdisk or harddisk on Exadata ?

Why is this question is important for a DBA ? Actually the results are pretty surprising when you execute the query and see the last inserted date of a harddisk or a flashdisk. In another way, that information shows you the time you changed a faulty harddisk or flashdisk on the exadata. If you deleted… Continue reading When is the last time you changed a flashdisk or harddisk on Exadata ?