• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Create an output file from GGSCI commands

by admin

1. Create a shell script: ggsci_out.sh. It should contain the following:

./ggsci < {parameter file} >{output file}

example:

$ vim ggsci_out.sh
./ggsci  >ggsci_out.list

2. The shell script access mode must be executible

$ chmod +x ggsci_out.sh

3. Create a parameter file that contains the desired ggsci command. Example for INFO TRANDATA command:

$ vim ggsci.prm
dblogin userid {userid}, password {password}
info trandata {schema}.{table}

Example for STATS command

$ vim ggsci.prm
stats *, total, hourly

4. From the Linux/UNIX command prompt, run the shell script:

$ ./ggsci_out.sh

The output will be written to ggsci_out.list.

Filed Under: GoldenGate, oracle

Some more articles you might also be interested in …

  1. SQL*Plus Editing Commands
  2. XA and NON-XA
  3. ORA-28007: the password cannot be reused
  4. ORA-01506: missing or illegal database name
  5. How to Find the SQL_ID for a SQL statement or PL/SQL block
  6. How to Use Startup, Shutdown, and Alter Database commands in Oracle 12c
  7. How to Recover A Dropped Tablespace Using TSPITR
  8. Interview Questions : Oracle 12c Multitenant Database Architecture
  9. How to upgrade Oracle database to 12c Pluggable database (Multitenant) using Transportable tablespace(TTS) method
  10. How to Clone PDB With Oracle Key Vault (OKV)

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright