I wrote:
>> During an online backup, a file "tablespace_map" is created in the data directory that
>> contains the original locations of the tablespaces.
>>
>> During recovery, the symbolic links are restored from that directory.
>>
>> So you have to un-tar the tablespaces into the same location as in the original database
>> cluster. The good news is that you can find the locations in the "tablespace_map" file
>> and don't need to document them somewhere.
Wolfgang Brandl wrote:
> Thanks it is working perfectly.
> Even if i choose to redirect the database to new location and adapting the tablespace_map
> file to this new locations it is working.
> Do you think there are any concerns doing this redirect restore?
That should be fine.
Yours,
Laurenz Albe