RAM&KRISHNA BLOG

ORACLE_SID = [TICO] ? +ASM irut.back.tic.com@/home/oracle: asmcmd NOTE: GET THE DATAFILES LOCATION FROM DBA_DATA_FILES VIEW ASMCMD> cd +DATA/ticotest/datafile/ ASMCMD> ls -ltr Type Redund Striped Time Sys Name DATAFILE UNPROT COARSE JUL 03 08:00:00 Y SYSAUX.771.755506741 DATAFILE UNPROT COARSE JUL 03 08:00:00 Y SYSTEM.772.755506741 DATAFILE UNPROT COARSE JUL 03 08:00:00 Y UNDOTBS1.778.755506739 DATAFILE UNPROT COARSE JUL 03 08:00:00 Y USERS.779.755506737 ASMCMD> thats it

cat run_monitoring_Gg.sh ./monitoring_gg.sh TEST /u01/gg_home/12.2.0.1 ./monitoring_gg.sh TESTP  /u01/gg_home/12.2.0.1 cat DBNAME _monitoring_gg.log cat DBNAME _monitoring_gg.log rm DBNAME _monitoring_gg.log rm DBNAME _monitoring_gg.log -      Monitoring.sh - cat monitoring_gg.sh #!/bin/ksh # Script      : monitoring_gg.sh # Version     : 1.0 # Purpose     : To monitor Goldengate processes and latency # Usage       : monitoring_gg.sh ORACLE_SID GOLDENGATE_HOME # Example     : monitoring_gg.sh DBNAME /u01/app/goldengate/11.2.1.0.17 # # Parameters: #   1. ORACLE_SID: Database Instance name. This parameter is used to set the appropriate DB environment variables. (NOTE: This is the Instance name not Database name.) #   2. GOLDENGATE_HOME: Home directory of Goldengate installation # # ****************** # Functions # ****************** # Usage function. function show_usage {     echo " "     echo "Usage: $P