Tags » Data Guard

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

Switchover Failed in Data Guard Broker

Recently I did some Data Guard tests on RAC. Both primary and standby databases were on different Exadata QuarterRack. During one test, I might mess up some data guard parameters. 1,029 more words


RAC & Data Guard - FAL issues after role change

Today I had to convert a physical standby to snapshot standby using the DG Broker. The steps to perform this are very simple and completed with no errors. 208 more words


Restore datafile from service: A cool #Oracle 12c Feature

You can restore a datafile directly from a physical standby database to the primary. Over the network. With compressed backupsets. How cool is that?

Here’s a demo from my present class… 208 more words


How to Check Whether Physical Standby is in Sync with the Primary or Not and resolved gap ?

Step by Step Process to Resolved gap on Standby database.

1. Check the name and status of database.
2. Check for GAP on standby… 483 more words

Data Guard

Recover Primary Database from Standby Database Using RMAN Backup Files.

Oracle actively promotes the offloading of workload from the primary database to what would otherwise be a completely passive standby database. The suggestions for what to offload include reporting and backup tasks. 1,683 more words

Data Guard