Pass the start date + time and end date + time to the following script. It looks at the alert log file and obtains the no of archive logs that have been applied during media recovery in that time interval.
#!/usr/bin/perl -w
BEGIN { push @INC,”/home/user/TimeDate-1.16/lib/” }
use Date::Parse;
$start=str2time(@ARGV[0]);
chomp(@ARGV[1]);
$end=str2time(@ARGV[1]);
$log=’path to the log file’;
open(ALERTLOGFILE,$log) or die “Not able to [...]
Filed under: oracle | Tagged: log, oracle, perl | Leave a Comment »


