What’s going on? “Connected to an idle instance”, but database is running.

I have seen this a few times over the past few months, cases where a database is running but when you try and initiate a local connection to it, you receive the “connected to an idle … [Read more...]

Top 5 considerations when implementing a logical replication solution

In this post I want to look at how you can get your data flowing by implementing a real-time logical replication solution to replicate data between databases. Replication can solve many … [Read more...]

A few notes on Dbvisit Standby Monitoring

Today I decided to spend some time providing you with more detail on how you can monitor Dbvisit Standby. But before I get into the details, I would like to recommend, first of all, … [Read more...]

Tips, tricks and secret knowledge: a Dbvisit Standby roundup.

Dbvisit Standby has been around for a good few years now. It has been put through its paces by more than 500 customers, spread across 80 countries, and is considered the #1 alternative … [Read more...]

Synchronize your Standby Database using Dbvisit Standby

When using standby databases sometimes the unexpected happens, where you are faced with a standby that still requires recovery (archive logs need to be applied), but the archive logs are … [Read more...]

Solving the mystery of conflicts with LIST CONFLICT [+Video]

A conflict is raised at the target database when one of more of the following are present: 1. SQL affects zero rows This causes data divergence and so a conflict is raised. This … [Read more...]

Lost an Archive Log File? Use RMAN Incremental Backups to Resync Your Standby Database

Anyone who has done time on the "tech frontline" knows that there are occasions in production systems when the unexpected transpires. Whether such events are of human origin, for … [Read more...]

Dbvisit Standby versus Dbvisit Replicate

Since we have launched Dbvisit Replicate in 2011, we have been getting questions on exactly what the difference is between the two products and where you would use one over the other. … [Read more...]

Dbvisit Standby: Connect failover to standby database

After a switch-over or fail-over to an Oracle Standby database using Dbvisit Standby, the Oracle Database Administrator (DBA) faces the challenge of switching clients to the new activated … [Read more...]

Upgrading an Oracle database with DBUA

Oracle provides the Database Upgrade Assistant (DBUA) to automate the upgrade process and makes appropriate recommendations for configuration options such as tablespaces and redo logs. … [Read more...]