Tags » Data Guard

Script to identify the restore/recover point for archive logs

I did some work on an interesting project to keep a standby database in sync with a production primary database manually. This is not a true standby database as the primary database does not communicate with this standby database. 980 more words


Archived Logs Repository

Hello, everyone! On this post, I’ll write about the concept of Archived Log Repository. A few people know it, although most had contact indirectly with it. 167 more words

Sem Categoria

Don't go directly to Maximum Protection!

With a Data Guard Configuration in Maximum Performance protection mode, don’t go to Maximum Protection directly, because that leads to a restart of the primary database: 174 more words


Creating test databases using snapshot standby

At my current site there are multiple test databases which are refreshed on demand from Production. The current methodology is RMAN duplicate database which works but proves to be inefficient at certain times. 1,539 more words


archival process start in standby database


SYS@PTOPIC1> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DGRECOV/ptopic/
Oldest online log sequence 19269
Next log sequence to archive 19270… 323 more words