Tags » Data Guard

Fast-Start Failover for Maximum Protection in #Oracle 12c

Fast-Start Failover is supported with Maximum Protection in 12cR2. Also Multiple Observers can now monitor the same Data Guard Configuration simultaneously. I will show both in this article. 1,095 more words


Creating a RAC 12.1 Data Guard Physical Standby environment (2)

In the first part of this mini-series you saw me define the environment as well as creating a primary database. With that out of the way it’s time to think about the standby. 1,526 more words


Auto Sync for Password Files in #Oracle 12c Data Guard

A useful enhancement in 12cR2 is that password files are automatically synchronized in a Data Guard environment:

$ dgmgrl sys/oracle_4U@cdb1
DGMGRL for Linux: Release - Production on Tue Jan 10 07:38:15 2017

Copyright (c) 1982, 2016, Oracle and/or its affiliates. 169 more words

How DB_LOST_WRITE_PROTECT works with Data Guard


Today I will blog again about a Data Guard topic. There are a couple of best practices out there which one should follow. One of these best practises is enabeling block checking and lost write protection. 2,005 more words


Change Sys Password in Oracle Data Guard Environment .

Normally You can change the Sys password in Oracle single instance using Alter command.

connect / as sysdba
ALTER USER sys IDENTIFIED BY "new_password";

but in Oracle data guard environment it will work but your log transferring process will stop with following Error. 88 more words


Creating a RAC 12.1 Data Guard Physical Standby environment (1)

I have just realised that the number of posts about RAC 12c Release 1 on this blog is rather too small. And since I’m a great fan of RAC this has to change :) In this mini-series I am going to share my notes about creating a Data Guard setup on my 2 node RAC primary + identical 2 node RAC standby system in the lab. 804 more words