Oracle 23c installation on Linux
OCP Technology
by Shripal
4M ago
Here we will learn Oracle 23c installation on Linux step by step. In this article we will also learn how to Create and Configure Oracle Database instead of DBCA. Software Used In this practice, we are using the following software: System Requirements The system should be configured as per the below requirements: RAMMinimum 1 GB […] The post Oracle 23c installation on Linux appeared first on Leader in Oracle Consulting ..read more
Visit website
Export from 11g and import to 19c
OCP Technology
by Shripal
7M ago
In this article, we are going to learn how to export from 11g and import to 19c. As you know the Oracle DATA PUMP is a very powerful tool and using the Export and Import method we can load the from the lower Oracle database version to the higher Oracle Database version and vice versa. Step […] The post Export from 11g and import to 19c appeared first on Leader in Oracle Consulting ..read more
Visit website
How to Activate Standby Database as Primary after Failover
OCP Technology
by Shripal
1y ago
When it comes to database management, the ability to failover to a standby database is an essential feature for high availability and disaster recovery. In the event of a failure in the primary database, the standby database can take over as the new primary database. (Activate Standby Database as Primary after Failover) However, once the […] The post how to Activate Standby Database as Primary after Failover appeared first on Leader in Oracle Consulting ..read more
Visit website
Manual Reinstate old Primary Using Flashback
OCP Technology
by Shripal
1y ago
In this article, we will learn how to reinstate old primary using flashback (Oracle Data Guard). This is a lengthy task of rebuilding the corrupt or lost primary database, but with flashback technology, it is a very easy task now. Steps to Reinstate old Primary Using Flashback in Oracle DataGuard Read here Reinstate with DG […] The post Manual Reinstate old Primary Using Flashback appeared first on Leader in Oracle Consulting ..read more
Visit website
How to reinstate the old Primary as a Standby after Failover in Oracle
OCP Technology
by Shripal
1y ago
In this practice, we reinstate the old primary as a standby after failover in oracle. Currently, my primary database name "digital" is still active. My Environment: For this practice below are my environment details: Primary Database: The primary database name is DIGITAL. Standby Database: The Standby database name is DIGIDR. Check the MRP process on […] The post How to reinstate the old Primary as a Standby after Failover in Oracle appeared first on Leader in Oracle Consulting ..read more
Visit website
Oracle Dataguard Switchover with broker
OCP Technology
by Shripal
1y ago
To perform an Oracle Data Guard switchover with broker, you can follow these general steps: Prepare for the switchover Before starting the switchover process, make sure that both the primary and standby databases are synchronized and that all required logs have been applied to the standby database. Also, ensure that the broker is configured and […] The post Oracle Dataguard Switchover with broker appeared first on Leader in Oracle Consulting ..read more
Visit website
How to setup Data Guard Broker Configuration
OCP Technology
by Shripal
1y ago
Setting up Data Guard Broker Configuration involves the following steps. Before DG Broker setup you must have a Data Guard setup Read How to switchover in Data Guard Step 1. Current status of Broker Check the current status of DG Broker on both sides: Primary Side: Standby Side: Step 2: Very the Archive Gap Before […] The post How to setup Data Guard Broker Configuration appeared first on Leader in Oracle Consulting ..read more
Visit website
Oracle 19c Dataguard setup with PDB
OCP Technology
by Shripal
1y ago
Oracle 19c Dataguard setup with PDB, Dataguard is a disaster recovery solution that provides a high level of data protection and availability for Oracle databases. It provides real-time data protection, and automatic failover protection, and enables the creation of one or more standby databases for a primary database. Dataguard with PDB (Pluggable Database), a PDB […] The post Oracle 19c Dataguard setup with PDB appeared first on Leader in Oracle Consulting ..read more
Visit website
Patching 19.3 to 19.16 step by step
OCP Technology
by Shripal
1y ago
In this article, we are going to learn how to apply patching from 19.3 to 19.16 step by step. Today we applying patch number 34133642 on the Linux platform. Download OPATCH Version To update the OPATCH version we need to download it first and then replace it with the existing OPATCH in ORACLE HOME. Download […] The post Patching 19.3 to 19.16 step by step appeared first on Database Expert Support ..read more
Visit website
ORA-16019: Cannot Use Db_recovery_file_dest With LOG_ARCHIVE_DEST Or LOG_ARCHIVE_DUPLEX_DEST
OCP Technology
by Shripal
1y ago
SQL> alter system set log_archive_dest_2=’service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr’;alter system set log_archive_dest_2=’service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr’* ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-16019: cannot use LOG_ARCHIVE_DEST_2 with LOG_ARCHIVE_DEST orLOG_ARCHIVE_DUPLEX_DEST ORA-16019 Description DB_RECOVERY_FILE_DEST and LOG_ARCHIVE_DEST destinations we cannot use at the same time. The value of anyone should have a […] Th ..read more
Visit website

Follow OCP Technology on FeedSpot

Continue with Google
Continue with Apple
OR