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
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
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
In this article we going to discuss how we will get ddl of users and roles. You also read to like How to Change password without showing the actual password on screen? We can get ddl of users and roles using toad also, but in this article we are going to get metadata manually. Generally, … Read more How to get ddl of users and roles?
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
In this article, we are going to discuss how to upgrade Oracle 11g (184.108.40.206) to 19c (220.127.116.11) manually. Follow me step by step carefully. Start upgrade 11g to 19c manually. Source Environment. About Source Details OS Details Redhat Linux 7.6 (64 bit) Oracle Database version 18.104.22.168 Database Name OCP ORACLE_HOME path /u01/app/oracle/product/22.214.171.124/dbhome_1 Target Environment. About … Read more How to upgrade 11g to 19c manually?
Oracle database 18c available for Linux and Microsoft Windows and in this article we are going to discuss how to install oracle 18c on windows. Minimum hardware requirements for Oracle 18c. These are the minimum hardware requirements for oracle 18c installation. 2GB RAM 10GB Free space on your machine disk 16GB swap Minimum screen resolution … Read more How to Install Oracle 18c on Windows?
Uninstall Oracle 18c? Dear friends if you using windows platform for Oracle database so I think you know that very well this is not an easy task to uninstall oracle software like other software. In this tutorial, we are going to learn how to uninstall oracle 18c from windows manually. You also read convert non-cdb … Read more How to Uninstall Oracle 18c from Windows
Hello friends, In this article we are going to discus, how to use ALTER TABLE MODIFY column. Using this command we can modify table structure if required after table creation. ALTER TABLE MODIFY In this practical we are using following table which is have three columns. SQL> desc ocptech; Name Null? Type ———— —— ———- … Read more Oracle ALTER TABLE MODIFY
Transport Database from Linux to Windows Hello friends in this article we are going to discussed how to Migrate Database from Linux to windows. Transportable Database (TDB) require all the datafiles format must be converted to the targeted platform format. How Migrate Database from Linux to windows? During TDB, the datafiles conversion can take place … Read more How to Transport Database from Linux to windows?