ORA-16778 and ORA-12514 while adding a standby database to a new Data Broker configuration

Posted on by Ahmed Abdel Fattah

One of my customers re-created the data guard broker configuration, but he faces the following errors while adding the standby database:ORA-16778 and ORA-12514Environment: Primary: ORACLE_SID=proddb1 ORACLE_BASE=/u01/app/oracle PS1=$PWD<$ORACLE_SID> ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/db_home4 Standby: ORACLE_SID=proddb1 ORACLE_BASE=/u01/app/oracle PS1=$PWD<$ORACLE_SID> ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/db_home4 The Standby database is configured correctly and is receiving and applying logs from the primary database, no gaps (still he didn't create … Continue reading ORA-16778 and ORA-12514 while adding a standby database to a new Data Broker configuration

Oracle Database Guard 12c Implementation with RAC (Step-by-Step)

Posted on by Ahmed Abdel Fattah

Introduction: This is a real data guard implementation case for one of my clients. Data Guard is implemented between two clusters that reside on two different supercluster machines. The below procedure applies between any two clusters, it doesn't matter if it is a supercluster or Exadata or normal servers. I tried to put as much … Continue reading Oracle Database Guard 12c Implementation with RAC (Step-by-Step)

Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment

Posted on by Ahmed Abdel Fattah

Introduction: We may classify the database services into two types of services : 1- Database Services 2- Cluster Managed Database Services Please note that: - The procedure dbms_service.start_service - used with the first type - is deprecated in databases managed by Oracle Clusterware and Oracle Restart with Release 11.2. While the procedure remains available in … Continue reading Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment

Oracle Database Fast Cloning Options for Databases on Supercluster

Posted on by Ahmed Abdel Fattah

I had a question from one of my customers about the available fast cloning options for Oracle databases. This customer has a supercluster on the production site and another supercluster on the DR site. The client requirement is to be able to prepare a new Test/Dev database in minutes , not hours for their large … Continue reading Oracle Database Fast Cloning Options for Databases on Supercluster

How do Nologging Operations affect Recovery and Data Guard?

Posted on by Ahmed Abdel Fattah

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. Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure. What is Nologging: NOLOGGING can be used to prevent bulk operations from … Continue reading How do Nologging Operations affect Recovery and Data Guard?