Introducing CA ARCserve Backup Agents and Options › Using Options › CA ARCserve Backup UNIX and Linux Data Mover › Best Practices › Best Practices for Protecting Oracle Data › Troubleshooting Oracle RMAN Backups with UNIX and Linux Data Mover › RMAN Reports Missing Data Files When You Submit a Restore

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 CA 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 CA ARCserve Backup database. If the information was purged, merge the information from the CA ARCserve Backup media into the CA ARCserve Backup database, and then resubmit the jobs.
3. If you are attempting to restore Oracle RMAN data to an alternative node, do the following:
   • Ensure 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.

   Note: The sbt.cfg configuration file is stored in the Agent for Oracle home directory on the UNIX or Linux server.