Oracle 19c RPM based Installation

Oracle 19c RPM based Installation

Hello, friends in this article we going to Install Oracle 19c RPM based on Oracle Linux 7 64-bit and the article based on a server installation with a 2GB swap, please follow all the steps carefully. If you have Unbreakable Linux Network (ULN) access, so as per oracle documentation you can install it using the … Read more Oracle 19c RPM based Installation

Share this
Share

Oracle Database 19c Installation on Oracle Linux 7

oracle 19c installation on linux

Hello, friends in this article we are going to discuss Oracle database 19c (64-bit) Installation on Oracle Linux 7. Using this article we are going to Install Oracle 19c server based with a 2GB swap. Software I used in this article VMware Oracle Linux 7 (64-bit) Oracle Database 19c (19.3, 64-bit) Download Database Software You … Read more Oracle Database 19c Installation on Oracle Linux 7

Share this
Share

Display all the tables with foreign key

tables with foreign key

Hello, friends in this article we are going to discuss how to display all the tables in a schema with foreign key relations and the number of records for the parent and the child tables. Import view only using impdp Click here to read The following query will solve our problem, execute it as a … Read more Display all the tables with foreign key

Share this
Share

Oracle 19c Active Data Guard-DML Redirection

19c DML Redirection

Hello friends in this article we are going to discuss about oracle 19c DML Redirection feature with Data Guard. ACTIVE DATA GUARD DML REDIRECTION is new feature in Oracle 19c which is enable Data Manipulation Language (DML) operations on the standby server to be redirect and run on the production (Primary) database. The updated data … Read more Oracle 19c Active Data Guard-DML Redirection

Share this
Share

19c data guard new features

19c data guard new features

Hello friends, in this article I’m going to discuss here oracle 19c data guard new features. The changes in Oracle 19c Data Guard concepts and administration are listed below The process of flashback a physical standby to a point-in-time that was captured on the production (primary) is simplified by automatically replicating restore points from production … Read more 19c data guard new features

Share this
Share

Oracle 19c Data Guard Configuration step by step

Oracle 19c Data Guard Configuration

Hello friends in this article, we going to discuss Oracle 19c Data Guard Configuration step by step. Oracle Data Guard is a high availability model which prevent downtime and data loss by using redundant system and software to eliminate single point of failure. Our Environment for this practice Primary Environment DB_NAME OCP DB_UNIQUE_NAME OCP IP … Read more Oracle 19c Data Guard Configuration step by step

Share this
Share

Storing RMAN output in log file

RMAN Outputs in Log file

Hello, friends in this article we are going to discussed how to store RMAN outputs in the log file. What is the RMAN log file? RMAN log file is a just text file which is store complete output of RMAN commands. Generally, this file is used to check the backup has been done successfully or … Read more Storing RMAN output in log file

Share this
Share
Share