Mir Sayeed Hassan Blog- Oracle DBA

        Oracle GoldenGate (OGG), Configuration & Simple Test in our Test ENV Step by Step Procedure to Setup of the OGG Configuration & Tested with simple table in our test ENV, I Have used the below two machine in single instance Oracle DB 11g (11.2.0.4) In the following configuration I have used the following Hosts and Databases Server: Source DB:                     SID: oggtest1                     Hostname: ogg-test1 Target DB                   SID: oggtest2                   Hostname: ogg-test2 DB Setup - Enable Forced Logging Forced logging should be enabled on the source database to ensure that all changes are written to the redo logs. By default database is not configuration with enable logging. To check if FORCE_LOGGING is enabled in the source database use the below query: [ oracle@ogg-test1]$ !sq SQL> SELECT force_logging FROM v$database; FORCE_LOGGING ------------- NO If not enabled, then

Create the Simple DBLINK Consider DB Scenario: SID: testdb1 (Source DB), SID: testdb2 (Target DB), Table: t1 Create Database Links On each server create a database link to the other database. On the source server (testdb1) as the mir user, create the following database link: [oracle@testdb1]$ sqlplus mir/mir SQL> CREATE DATABASE LINK testdb2 CONNECT TO mir IDENTIFIED BY mir USING 'testdb2'; On the target server (testdb2) as the mir user, create the following database link: [oracle@testdb2]$ sqlplus mir/mir SQL> CREATE DATABASE LINK testdb1 CONNECT TO mir IDENTIFIED BY mir USING 'testdb1'; Create a table with record in source db (testdb1) & create the only structure in target db (testdb2) $ sqlplus mir/mir SQL>  create table t1(eno number(10)); SQL> insert into t1 values(1);     -- Similary insert for total 5 records SQL> select count(*) from t1;                    5  SQL> commit; Copy Test

Move the datafiles ( System, SYSAUX, UNDOTBS, TEMP, REDO LOGFILES) into the new location : USERS TBS Note: It does not require the database to be bonce or in mount stage for USERS tablespace Get the datafile location exist SQL> select name from v$datafile ;     (Old Location of al the datafiles) NAME ------------------------------------------------ /u01/app/oracle/oradata/oggtest2/system01.dbf /u01/app/oracle/oradata/oggtest2/sysaux01.dbf /u01/app/oracle/oradata/oggtest2/undotbs01.dbf /u01/app/oracle/oradata/oggtest2/users01.dbf /u01/app/oracle/oradata/oggtest2/example01.dbf Moving Normal Data Files To move the datafile associated with the USERS tablespace, fallow the below steps: -         Make the users tablespace offline: SQL> alter tablespace users offline; Tablespace altered. SQL> exit Now move or copy  the tablespace users into the new location $ mv /u01/app/oracle/oradata/oggtest2/users01.dbf  /oradata/datafiles/ $ !sq SQL> alter

Setup of Oracle Golden Gate for Oracle Database 11G Download the OGG Software & Copy to the linux machine $ mkdir OGG_HOME [oracle@oracleTestServer ~]$ cd /backup/OGG_HOME/ [oracle@oracleTestServer OGG_HOME]$ pwd /backup/OGG_HOME [oracle@oracleTestServer OGG_HOME]$ ls fbo_ggs_Linux_x64_shiphome.zip [oracle@oracleTestServer OGG_HOME]$ unzip fbo_ggs_Linux_x64_shiphome.zip [oracle@oracleTestServer OGG_HOME]$ ls fbo_ggs_Linux_x64_shiphome      OGG-12.2.0.1.1-ReleaseNotes.pdf fbo_ggs_Linux_x64_shiphome.zip  OGG-12.2.0.1-README.txt [oracle@oracleTestServer OGG_HOME]$ cd fbo_ggs_Linux_x64_shiphome/Disk1/ [oracle@oracleTestServer Disk1]$ ls install  response  runInstaller  stage [oracle@oracleTestServer Disk1]$ ./runInstaller (Select the Oracle Goldengate for Oracle Database 11g & Fallow the Instruction) Note: Install this OGG into the New Location [oracle@oracleTestServer 11.2.0]$ pwd /u01/app/oracle/produc

Perform the Failover by using the DGMGRL (Observer Utility) in our Test Env On Primary Database [oracle@pr ~]$ !sq sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 12 02:28:04 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>  SELECT NAME,DB_UNIQUE_NAME, OPEN_MODE,DATABASE_ROLE FROM V$DATABASE; NAME      DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE --------- ------------------------------ -------------------- ---------------- PR        pr                             READ WRITE           PRIMARY On Standby Database [oracle@std scripts]$ !sq sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 12 02:28:21 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edi