PostgreSQL VACUUM and MVCC

   PostgreSQL uses MVCC (multi-version concurrency control) to provide transactional semantics. In the simplest form, MVCC lets each transaction work on a different copy of a row in a table. What it means is whenever a row is updated, a new version of the row is created.

Tracing Oracle Data Guard

 Tracing can also be enabled in dataguard using the parameter "Log_Archive_Trace"

The values can be set using DG-Broker (if configured) or at SQL prompt as below.

Feedspot - Top database blog list

Dear All,

I am pleased to inform  that I received this recognition from Feedspot and I'm proud to be part of the awesome family- Thank you Anuj and Team for this recognition!

Consistency check before performing RMAN resetlogs.

The article covers consistency check before performing OPEN RESETLOGS after restoring a database using backup