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 al...

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;                ...

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/...

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@oracleTest...

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                 ...