Recoverable error during job execution (related to shared snapshot controlfile)

  • 0
  • 1
  • Problem
  • Updated 5 years ago
  • Solved
  • (Edited)
I get the following warning e-mails daily (generic names used):

DB_SYNC job for "{Group}/{DB_name}" encountered a recoverable error during execution. The job was able to continue, but there may be additional effects on your operations. Cause: RAC database "{DB_name}" has a snapshot controlfile that may not reside in a shared location.

The action suggests:

The snapshot control file should reside in a location accessible from all cluster nodes. Current snapshot control file location is configured to "/orashare/rman/{DB_name}/snapcf.f". If this is not a shared location, use RMAN "CONFIGURE SNAPSHOT CONTROLFILE NAME TO <fullpath shared location>;" command to set it to a correct shared location. If it is a shared location, no action is required.

But when I check the accessibility of that file across all the nodes, I see that it comes up fine (one line per node in the cluster):

-rw-r----- 1 oracle oinstall 63M Aug  7 06:32 /orashare/rman/{DB_name}/snapcf.f
-rw-r----- 1 oracle oinstall 63M Aug  7 06:32 /orashare/rman/{DB_name}/snapcf.f
-rw-r----- 1 oracle oinstall 63M Aug  7 06:32 /orashare/rman/{DB_name}/snapcf.f
-rw-r----- 1 oracle oinstall 63M Aug  7 06:32 /orashare/rman/{DB_name}/snapcf.f

Is this a common issue with a quick fix?



Photo of Avindra Goolcharan

Avindra Goolcharan

  • 404 Points 250 badge 2x thumb

Posted 5 years ago

  • 0
  • 1
Photo of Michael Brown

Michael Brown

  • 1,540 Points 1k badge 2x thumb
Official Response

Unless the snapshot control file resides in an ASM filesystem, we can't presently determine whether the file is in a location accessible to all the nodes, so we generate this warning. If you are using ASM in this cluster, the easiest fix for this would be to configure the snapshot control file to be in ASM. This is the typical configuration in a RAC cluster.

If this is not possible, but you are certain that the location is a shared location (which it does appear to be based on the given output), then you may simply ignore the warning. 

Thank you,