Set-Location \\mybackupserver\mydb\backupset
$compareDate = (Get-Date).AddDays(-1)
$rmanfile=Get-ChildItem -Recurse | Where-Object { $_.LastWriteTime -ge $compareDate }
$cmd = "cmd.exe"
$rmanun = "target /"
$sqlun = "/ as sysdba"
$chg_arc_dir_restore="alter system set log_archive_dest_1='location=\\myprodserver\archivelog\';"
$chg_arc_dir="alter system set log_archive_dest_1='location=F:\oradata\PSPRODDB\ARCHIVELOG' ;"
$logfile=".\recoverStandbyDB_log.log"
$chg_arc_dir | sqlplus -silent $sqlun | Out-File -append $logfile

#$args = "/c exit | sqlplus $sqlun @$sqlFileToExecute"
#&$cmd $args  
$Done_date=Get-Date
"starting recovery of standby database.... $Done_date" | Out-File -append $logfile

foreach ($a in $rmanfile) 
  { 
    $b=($a -split " ") ; 
   $catit="catalog backuppiece '\\mybackupserver\mydb\backupset\$B';";
   $catit
   #$catit | rman target /  | Out-File -append $logfile
   }
 #$chg_arc_dir | sqlplus -silent $sqlun | Out-File -append $logfile
 #$recover_database="recover database;"
 #$recover_database | rman target /  | Out-File -append $logfile
 #$chg_arc_dir_restore | sqlplus -silent $sqlun | Out-File -append $logfile
#$sql_recov = @"
# recover standby database until cancel ;
# auto
#"@
 
 #$sql_recov | sqlplus "/ as sysdba" | Out-File -append $logfile

$Done_date=Get-Date 
 "Done with recover standby database.... on $Done_date" | Out-File -append $logfile