Log in Processes for golden gate having different database

-
                    Log in Processes for golden gate having different database

1.Log in process in goldengate for Teradata

ggsci>dblogin sourcedb td_uat, userid DBU_GGATE_MEMP, PASSWORD DBU_GGATE$FEB17

2.Log in process in goldengate for SQL Server Database

ggsci>dblogin targetdb td_uat, userid DBU_GGATE_MEMP, PASSWORD DBU_GGATE$FEB17

3.Log in process in goldengate for Oracle

ggsci>dblogin USERIDALIAS ogg_bmscrbu

4.Log in process in goldengate for Hadoop(Cloudera)

(There is no db login for Hadoop as it has only hdfs file system rather than database)

Comments

Post a Comment

Popular posts from this blog

Oracle Golden Gate FAQ

-
Image
                                                      Oracle Golden Gate FAQ Q. What type of Topology does Goldengate support? GoldenGate supports the following topologies. 1. Unidirectional 2. Bidirectional 3. Peer-to-peer 4. Broadcast 5. Consolidation 6. Cascasding Q. What are the main components of the Goldengate replication? The replication configuration consists of the following processes. 1. Manager 2. Extract 3. Pump 4. Replicate Q. What transaction types does Goldengate support for Replication? Goldengate supports both DML and DDL Replication from the source to target. Q. What are the supplemental logging pre-requisites? The following supplemental logging is required. 1. Database supplemental logging 2. Object level logging Q. Why is Supplemental logging required for Replication? Integrated Capture (IC): 1. In the Integrated Capture mode, GoldenGate works directly with the database log mining server to receive the data changes in the form of log
Read more

Oracle Golden gate - Long running transactions while stopping an extract

-
Oracle Golden gate  - Long running transactions while stopping an extract ? Below is how you can find it out and kill if needed. GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN Sending showtrans request to EXTRACT EXRAJ ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064 Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288 ------------------------------------------------------------ XID:                  1630.17.201166 Items:                1        Extract:              EXRAJ    Redo Thread:          1      Start Time:           2013-05-10:21:43:50  SCN:                  1586.3900894393 (6815719025849)  Redo Seq:             74058 Redo RBA:             104066064          Status:               Running            ------------------------------------------------------------ XID:            
Read more

FAQ on Oracle Golden gate for unix & windows

-
                                        FAQ on Oracle Golden gate for unix & windows 1.What is the purpose of running   the Reverse utility • To restore a test database to its original state before the test run. Because the Reverse utility only backs out changes, a test database can be restored in a matter of minutes, much more efficiently than a complete database restore, which can take hours. • To reverse errors caused by corrupt data or accidental deletions. For example, if an UPDATE or DELETE command is issued without a WHERE clause, the Reverse utility reverses the operation. 2.What needs to do for using the Reverse utility • Run Extract to extract the before data. • Run the Reverse utility to perform the reversal of the transactions. • Run Replicat to apply the restored data to the target database. 3.How the Reverse utility reverses the forward operations Reversing the ordering of database operations in an extract file, a series of extract
Read more