Migrating an Oracle 11g Database to an 11g Database in the Oracle Cloud via Data Pump Conventional Export/Import

Before You Begin Purpose In this tutorial, you learn how to migrate on-premises Oracle 11g database schemas to an 11g database in Oracle Database Cloud Service, using Data Pump conventional export and import. Last Updated March 2016, Release 16.1.5 Please note that Oracle develops its cloud services in an agile manner and makes rapid changes…

Dataguard commands and SQL scripts

Physical Standby Commands _________________________ To start redo apply in foreground: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To stop redo apply process on the Standby database (to stop MRP): SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; To start real-time redo apply: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;…

Setting Up Table Replication In Goldengate

In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. PRESPLAY.EMP; PRESPLAY.DEPT; PREREQUISITE: Make sure the goldengate installation is completed and manager process is running on both source and target hosts. 1. Enable supplemental logging for those tables.[SOURCE] 2. Prepare extract parameter file[ SOURCE ] Here –…