Advanced Restore Options (Redirect)

Use this dialog box to rename and/or redirect one or more datafiles when the data is restored as well as to redirect table spaces to another location for restore.

Redirect All Table Spaces to

Specifies whether to redirect all table spaces displayed in the Object column to the specified location. Use the space or click Browse to include or change this location. 

Redirect

Specifies whether individual table spaces and/or datafiles can be redirected to the specified location. Select the desired tablespaces and/or datafiles in the window that you want to redirect and type the path in the New Path entry field.

New Path

Displays the specified location for redirection.  You can use this space to modify this location.

Browse

Click to browse to a new path. The new path will then be displayed in the New Path entry field.

Apply

Click to set the path or name changes. Changes will then be displayed in the New Path column.

Clear

Click to clear the New Path entry field.

Find&Replace

Click to find an old path location and replace it with the new path

Redirect Temp Table Spaces To

Select to type or browse the location to restore the temp files to a different directory structure than the source database. You can redirect these temp files to a duplicate database during the restore.

When you try to restore all the data and temp files to a different directory structure, the system will add DB_CREATE_FILE_DEST PFILE parameter to the target database.

Example:

DB_CREATE_FILE_DEST='/oracle/oradata/LUN_DUP/CSDB/ddr_dup/'