Quick Dirty Script for Checking Oracle Data Gurad Gap and Emailing it
Situation: primary DB: prd_CCC standby DB: prd_WWW file 1: gap-check.bat @echo off cls echo. echo. echo This script checks for Archive Logs at prd_ccc and Applied Logs at prd_www echo. echo Querying prd_ccc (Primary) echo select max(sequence#) "Primary" from v$archived_log where archived='YES';|sqlplus -s / as sysdba echo Querying prd_www (Standby) echo select max(sequence#) "Standby" from v$archived_log where applied='YES';|sqlplus -s / as sysdba echo. DGMGRL / "show configuration" date /t && time /t && hostname && whoami file 2: emailer.ps1 $Username = "username" $EmailPassword = "password" $today = Get-Date $Username = $Username $EmailTo = "adam@jasabyte.com" $EmailFrom = "server@jasabyte.com" $Body = Get-Content .\status.log -Raw $Subject = "PRIMARY/STANDBY DB GAP - $today" $SMTPServer = "mail.smtp2go.com" $SMTPMessage = New-Object System.Net.Mai...
LOL teros letak blog
ReplyDeletewakakaka. mati2 tadi aku ingat kau yg buat.
ReplyDeletetuh a.. aku pon mule2 engat aku yg buat. haha.. mane dtg tah die pom name 'Adam. XD
ReplyDelete