OraEasy

Introduction: As Oracle 19c stands as the Long-Term Support (LTS) release in Oracle’s database roadmap, upgrading from Oracle 12c is not merely a version shift—it’s a strategic move to maintain support, unlock advanced features, and ensure long-term performance, stability, and compliance. In this article, we will see how to upgrade the database from 12c to 19c step by step. Methods of Upgradation: Using DBUA (Database Upgrade Assistant) Using Manual method Using autoupgrade.jar We have already covered the upgrade using DBUA. Please visit Upgrade Using DBUA In this article we will use Manual method for upgrade. Prerequisites: 12c binary installed with database. 19c binary installed without database. Sufficient disk space for tablespace & archive growth. Minimum 6 hrs downtime for Production database. Environment: Source Database Hostname devdb.oraeasy.com Database Name D...

Introduction: Failover occurs when the primary database is completely lost or becomes inaccessible. In such events, the standby database is promoted to serve as the new primary to ensure service continuity. However, the original primary does not automatically transition to a standby role, particularly if it is damaged or unrecoverable. If Flashback Database is not enabled on the original primary, it becomes necessary to re-create the primary database from scratch using methods such as RMAN Duplicate. Prerequisites: Oracle Data Guard should be configured. We consider here that Primary is completely lost. Environment: Server Primary Standby Hostname Source Target IP 192.168.80.51 192.168.80.111 OS OEL 9 OEL 9 SID ORCLDC ORCLDR Service Name ORCLDC ORCLDR Now proceed to Fai...