Database Administration & Monitoring, Database management, Oracle Dbvisit – Switchover failing with ORA-00600 error due to Unified Auditing been enabled 28.05.2020 by Marc Wagner I have been recently deploying dbvisit version 9.0.10 on Standard Edition SE2 18.7. Graceful switchover failed with error : ORA-00600: Interner Fehlercode, Argumente: [17090], [], [], [], [], [], [], [], [], [],[], [] (DBD ERROR: OCIStmtExecute)(…)
Database Administration & Monitoring, Database management, Oracle Applying archive log on a standby is failing with error ORA-00756: recovery detected a lost write of a data block 28.05.2020 by Marc Wagner During one last ODA project, I was deploying dbvisit software version 9.0.10 on Oracle database SE Edition version 18.7. From time to time I was getting lost write of a data block with type KTU UNDO on the standby. Through(…)
Database Administration & Monitoring, Oracle dbvisit dbvctl process is terminating abnormally with Error Code: 2044 29.11.2019 by Marc Wagner When applying archive logs on the standby, dbvctl process can terminate abnormally with Error Code: 2044. This can happen in case there are several archive logs with huge size to be applied.
Database Administration & Monitoring, Oracle Adding a dbvisit standby database on the ODA in a non-OMF environment 23.10.2019 by Marc Wagner I have recently been working on a customer project where I had been challenged adding a dbvisit standby database on an ODA X7-2M, named ODA03. The existing customer environment was composed of Oracle Standard 12.2 version database. The primary database,(…)
Database Administration & Monitoring, Oracle Having multiple standby databases and cascading with dbvisit 23.10.2019 by Marc Wagner Dbvisit standy is a disaster recovery solution that you will be able to use with Oracle standard edition. I have been working on a customer project where I had to setup a system having one primary and two standby databases.
Database Administration & Monitoring 2 x ODA X6-2S + Dbvisit Standby: Easy DR in SE 21.10.2016 by Oracle Team By Franck Pachot . What's common with Standard Edition, simplicity, reliability, high performance, and affordable price? Dbvisit standby can be an answer because it brings Disaster Recovery to Standard Edition without adding complexity ODA Lite (the new X6-2S and 2M)(…)
Database Administration & Monitoring Compare source and target in a Dbvisit replication 05.07.2016 by Oracle Team By Franck Pachot . You've setup a logical replication, and you trust it. But before the target goes into production, it will be safer to compare source and target. At least count the number of rows. But tables are continuously(…)
Database Administration & Monitoring, Oracle Interested in a deep dive of logical replication? 11.11.2015 by Oracle Team By Franck Pachot . It's next week at #DOAG2015 Interested in a deep dive of logical replication? Let's try it. The best way to learn is to try it and this is the idea of #RepAttack where you can quickly(…)
Database Administration & Monitoring, Oracle Dbvisit replicate allows DDL replication even when source and destination have different structure 02.11.2015 by Oracle Team By Franck Pachot . I've tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software - at least in their current version -(…)
Database management, Oracle Oracle CDC for Datawarehouse, Dbvisit replicate as an alternative 26.08.2015 by Oracle Team By Franck Pachot . You don't want to reload the datawarehouse database every night. And you may want to have it refreshed more often, in real-time during the day. There is another reason to capture all changes from the(…)