Dataguard Monitor (tool)

Dataguard Monitor

Some of my fun tools I have created during my free time. :)

Dataguard Monitor a monitoring tool for monitor the log shipping to dataguard server. It will auto upgrade every minute. The status show the current status of the recovery process and the archive log number/instance node currently applied. The log not apply show the number of archive log waiting to be apply.

• DGcheck.exe is the main executable file
• Dgcheck.exe.config – configuration file. Key1 is the sys password, Key2 is the connection string
• Oracle.DataAccess.dll – the required oracle ddl file

Setup

1. Download oracle odp.net ODAC1120320Xcopy_32bit from Oracle website
2. Extract the zip file to c:\temp
3. Install using the command
1.  install.bat odp.net20 c:\oracle\odp odp
2. (to uninstall uninstall all c:\oracle\odp)
4. Unzip to the dataguard_status.zip
5. Execute the DGcheck.exe

Download Files

DGcheck.exe

DGCheck.config