Rename or Redirect Files on Restore

The capability of renaming files or data objects during restore is a feature supported by the Windows/Unix/Macintosh File System iDataAgents as well as the DB2, Oracle and SQL Server iDataAgents. However, there are some agent-specific differences as to how this feature is implemented, which are discussed below.

Some agents also supporting renaming files that are restored via a Map file. See Restore Data Using a Map File - Support for a list of Agents that support this type of Restore.

Windows, UNIX, and Macintosh iDataAgents

For supported File System iDataAgents, one of the options available during a restore operation is the ability to append a suffix that you supply. On the Windows platform, this suffix is appended to the filename (i.e., before the extension). On the Unix/Mac platforms, the suffix is appended after the extension. Renaming files as they are restored allows them to be restored without overwriting existing files, yet remain in the same place. You can then view both the restored file, with the appended filename, and the original file.

Example Windows

Entering the string "temp" in the Rename Restore Files dialog box, will rename file1.txt to file1temp.txt.on restore.

Example UNIX

Entering the string "temp" in the Rename Restore Files dialog box, will rename file1.txt to file1.txttemp on restore.

DB2 iDataAgent

The DB2 iDataAgent provides the capability to rename one or more table spaces or table space containers upon restore from the Redirect tab of the Advanced Restore Options dialog box. Renaming these items as they are restored allows them to be restored without overwriting existing table spaces or table space containers.

Oracle iDataAgent

The Oracle iDataAgent provides the capability to rename one or more datafile(s) upon restore, from the Redirect tab of the Advanced Restore Options dialog box. Renaming datafiles as they are restored allows them to be restored without overwriting existing datafiles and tablespaces. See Redirecting Data During Restores for more information.

SQL Server iDataAgent

The SQL Server iDataAgent provides the capability to rename one or more database(s) upon restore, as well as their associated database path(s), from the Advanced SQL Restore Options dialog box.