All rights reserved.Ĭonnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Step4:-Now we are going to Import 12c database (1835008 Rows) dpdump]$ impdp system/oracle dumpfile=hari1.dmp logfile=hari1.log directory=DATA_PUMP_DIR SQL> insert into chennai select * from chennai Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production Step3:-After export i am inserting more records in Chennai ~]$ sqlplus hari/hari Warning: Permanently added ‘192.168.2.157’ (RSA) to the list of known password: Step2:-copy the datapump files to 11g server to 12c gghome]$ cd dpdump]$ scp hari1.dmp authenticity of host ‘192.168.2.157 (192.168.2.157)’ can’t be established. Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at 20:02:45 u01/app/oracle/admin/source/dpdump/hari1.dmp Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/PROCACT_INSTANCE Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/USER Total estimation using BLOCKS method: 88 MB Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** dumpfile=hari1.dmp schemas=hari directory=DATA_PUMP_DIR logfile=hari1.log FLASHBACK_SCN=1584462Įstimate in progress using BLOCKS method. With the Partitioning, OLAP, Data Mining and Real Application Testing optionsįLASHBACK automatically enabled to preserve database integrity. All rights reserved.Ĭonnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production Step1:-Export the table “chennai” using flashback_scn gghome]$ expdp system/oracle dumpfile=hari1.dmp schemas=hari directory=DATA_PUMP_DIR logfile=hari1.log FLASHBACK_SCN=1584462Įxport: Release 11.2.0.3.0 - Production on Tue Jul 31 20:02:25 2018Ĭopyright (c) 1982, 2011, Oracle and/or its affiliates. Start the initial dataload using Datapump on source side 11g database
GGSCI (gg-12.2.com ) add replicat rep1 exttrail /u01/gghome/dirdat/ad checkpointtable gguser.checkpoint Successfully created checkpoint table gguser.checkpoint. GGSCI (gg-12.2.com) add checkpointtable gguser.checkpoint Manager is running (IP port gg-12.2.com.7810, Process ID 3999). GGSCI (gg-12.2.com) 9> dblogin userid gguser,password gguser Target side 12c database GG Configuration GGSCI (gg-11.2.com ) add rmttrail /u01/gghome/dirdat/ad extract dpump1 GGSCI (gg-11.2.com) add extract dpump1 exttrailsource /u01/gghome/dirdat/ac Program Status Group Lag at Chkpt Time Since Chkpt GGSCI (gg-11.2.com ) add exttrail /u01/gghome/dirdat/ac extract ext1 GGSCI (gg-11.2.com ) add extract ext1 tranlog begin now 19:56:34 INFO OGG-01980 Schema level supplemental logging is enabled on schema HARI for all scheduling columns. 19:56:34 INFO OGG-01785 Schema level supplemental logging is enabled on schema HARI.
GGSCI (gg-11.2.com ) info schematrandata hari 19:56:12 INFO OGG-01976 SCHEMATRANDATA for scheduling columns has been added on schema hari. 19:56:12 INFO OGG-01788 SCHEMATRANDATA has been added on schema hari. GGSCI (gg-11.2.com ) add schematrandata hari GGSCI (gg-11.2.com) dblogin userid gguser,password gguser Operating system character set identified as UTF-8.Ĭopyright (C) 1995, 2014, Oracle and/or its affiliates. Oracle GoldenGate Command Interpreter for Oracle Step1:-Login in to 11g server and connect to gghome]$. Source 11g database side GG Configuration
Oracle 10g to 12c upgrade upgrade#
High Level Steps upgrade from 11g to 12c databaseġ)check network between source and target.ģ)setup extract and datapump on source siteĥ)export and import initial load using SCN In this article we are going to see Zero downtime database upgrade from 11g to 12c using Oracle Goldengateġ)Using Goldengate we are going to upgrade from 11g to 12c database without any downtime.Ģ)Already Data is available source11g scheme Hari. Zero downtime database upgrade from 11g to 12c using Oracle Goldengate