1 Reply Latest reply on Jul 8, 2013 12:15 PM by sharmad

    Cannot run RMAN Validation or RMAN Hot Backup Script after they have been working  on a Standby database


      Problem Description


      Standby database in a Fast-Start-Failover configuration.  Last evening database was successfully backup using a Full backup. 

      Validation script that runs every morning fails with: (this ran successfully yesterday morning)


      ORA-00604: error occurred at recursive SQL level 1

      ORA-01219: database not open: queries allowed on fixed tables/views only

      ORA-06508: PL/SQL: could not find program unit being called: "SYS.X$DBMS_BACKUP_RESTORE"

      RMAN-04015: error setting target database character set to WE8MSWIN1252

      DB is on and on windows x64bit

      Any help is appreciated.

      Thanks in advance!