Restoring a specific datafiles in Oracle

[storageguy]

Hi,

Is there a way to restore a specific data files for Oracle? I don't see it as an option. I can change the location of the data files to restore to, but I cannot select a specific data files that I want to restore.

Thanks

[PetrM]

Hello,

If you're talking about Veeam Explorer for Oracle, there is no option to select individual files because explorer restores the entire database. But you can change data file paths in the restore wizard. For granular restore operations, I recommend using Veeam Plug-in for Oracle RMAN as RMAN allows individual data files restore, for example:

Code: Select all

RUN
{
  ALTER DATABASE DATAFILE 9 OFFLINE;
  SET NEWNAME FOR DATAFILE 9 TO '/disk2/users01.dbf';
  RESTORE DATAFILE 9;
  SWITCH DATAFILE ALL;
  RECOVER DATAFILE 9;
  ALTER DATABASE DATAFILE 9 ONLINE;
}

Thanks!