‘ORA-19909: datafile 1 belongs to an orphan incarnation’ during duplicate for standby
Some time ago my colleague Pavel Tolstorukov asked me for help with failing DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE. The problem appeared during the recovery phase. The exact error looked like below: We worked on this together and were able to identify the…
Oracle 19c solves ORA-00026 when killing PDB sessions
Oracle Multitenant was a big architectural change for Oracle Database. I guess it was not so easy to introduce it to such a complex system. Unsurprisingly, there were some side effects introduced, but Oracle works hard to correct them. One example is ORA-00026: missing or…
Useful Oracle tools – DBCOMP
Getting lost writes (e.g. ORA-00752: recovery detected a lost write of a data block) is one of the worst DBA’s nightmares. There are a lot of very important questions popping up. Apart from the obvious ones on how to solve the problems reported (hopefully without…
Be careful with ‘save state’ in Data Guard configuration
Users are complaining that from time to time they are connecting to standby database which is opened read-only, instead to primary opened also for writing. What can be the root cause? Previous usage of below command: It keeps not only information about the state of…
Side effect of ExaWatcher workaround for LSOF check
While analysing the problem with ExaWatcher not being able to start, I found quite nasty side effect of a workaround implemented in recent versions of this useful tool. In fact, you will hit it only on Exadata X7 where you had previously implemented another workaround…
Learn and certify for free: Oracle Cloud Infrastructure and Oracle Autonomous Database
If you ever hesitated to jump into learning about Oracle Cloud Infrastructure or Oracle Autonomous Database the time is now! Oracle Cloud Free Tier together with Always Free Services is already available since last year. This is very useful, as it allows to familiarize with…
Useful Oracle tools – purgeLogs
Recently I’ve came across a nice tool provided by Oracle named purgeLogs, so I would like to shortly blog about it for reference (also for me). As the name suggests it is meant to be used for cleaning up log and trace files. Unfortunately, it…
Small fix for SQLcl Java problem with Oracle 12.1
Let’s say you want to quickly use some cool features of SQLcl inside the script running on the database server, but only Oracle below version 12.2 is available there (which is the first one being shipped with SQLcl). This means that you have to download…
Exadata Cloud at Customer: Real-life experiences
Today again very short post, just pointing to my recent article inside new issue of UKOUG magazine called #PTK (former Oracle Scene): Exadata Cloud at Customer: Real-life experiences. Enjoy! Advertisements
Oracle ACE Associate
Today short post, just to announce that I became Oracle ACE Associate! I’m happy to be recognised by the Community and would like to thank all the people I’ve met during my career, who positively influenced me (not only with technical and Oracle knowledge!) and…
Social Media @trivadis