Tags » Data Guard

Flashing Back an Activated Standby Database (Primary) into a Physical Standby Database


One of my critical primary database was gone to the down due to an uncertain cause. We couldn’t open it.  I started the recovery on primary. 351 more words

Data Guard

How do Nologging Operations affect Recovery and Data Guard?

What is Redo Information:

Each Oracle Database instance has redo logs, which consists of two or more preallocated files that store all changes made to the database as they occur. 1,512 more words

Oracle Database

orapwd gives OPW-00029 Password complexity failed in #Oracle 12.2

When I tried to create a password file for a 12.2 database, it initially failed with my favorite (simple) password:

$ orapwd file=$ORACLE_HOME/dbs/orapwprima password=oracle

OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters. 123 more words

Oracle Multitenant 12.2 – the big challenge of PDB hot cloning in MAA environments

One of Oracle’s key features introduced with Multitenant 12.2 is the possibility to clone pluggable databases while they are open for read / write operations. This is really a great feature – and as long as you work in a standalone container database it works perfect. 1,334 more words


Data Guard Broker Failover


Primary database is down

Log into the Data Guard Broker on standby node and check the configuration (dgmgrl sys/<password>)

Issue the failover command.

Modify the listener.ora file on the new primary node to allow it to listen for connections from the old primary. 242 more words

AWR Warehouse and Data Guard - Conclusions

Unfortunately AWR Warehouse and Data Guard do not work together seamlessly, however by understanding some of the implementation details, and following some simple steps you can help to mitigate most problems that may be encountered. 362 more words

AWR Warehouse