cancel
Showing results for 
Search instead for 
Did you mean: 

Restore Oracle DB from Tape to different OS

ayahya1
Level 1

Dears,

Hope you can help me in my case.

I took oracle DB backup existing on AIX 7 to the tape library.

I need to restore the data to a different client/OS (Windows Server 2016)

Is this possible? If yes can you give me the steps?

 

Thanks in advance

Regards

1 REPLY 1

Mouse
Level 6
Partner    VIP    Accredited Certified

In theory, Oracle backup sets are platform-agnostic as files, but when NBU takes a backup it also takes into account file system attributes and, again, generally speaking, it may not be possible to restore a file with Unix attributes on Windows.

If you do this as part of a migration, I would try to avoid tape as the medium and NBU altogether. Oracle can create a backup to a folder on disk which can be subsequently shared as NFS and mounted on Windows. Then, Oracle on Windows can access these files and will likely restore them. You will need an RMAN script that redefines placement of DBF files because of redirected restore but your DBA would know this as any redirected restore that involves changes to file locations even on Unix would require it.