RMAN Reports Missing Data Files When You Submit a Restore

Valid on UNIX and Linux platforms.

Symptom

When you restore data, Oracle RMAN reports missing data files, and jobs fail.

Solution

To remedy the missing data file errors, consider the following solution:

  1. Ensure that the RMAN data that is stored on Arcserve Backup media was not destroyed. If the data was destroyed, expire the data using from the Oracle RMAN catalog using Oracle RMAN commands.
  2. Ensure that the Oracle RMAN catalog information was not purged from the Arcserve Backup database. If the information was purged, merge the information from the Arcserve Backup media into the Arcserve Backup database, and then resubmit the jobs.
  3. If you are attempting to restore Oracle RMAN data to an alternative node, verify that the value specified for SBT_ORIGINAL_CLIENT_HOST in sbt.cfg is the node name of the Oracle server that was backed up. With these parameters, SBT_ORIGINAL_CLIENT_HOST overrides the source node with the host name and SBT_SOURCE_NAME overrides the destination node with the host name when you submit the job.
  4. Note: The sbt.cfg configuration file is stored in the Agent for Oracle home directory on the UNIX or Linux server.